Free database for Maker, what do you use

I need to decide on the type of database I am going to use.

I am familiar with Microsoft SQL and use that at work. Is MySQL free? Is there something better out there that anyone recomends I look into?

Thanks in advance for your guidance and recomendations!

MariaDB works well

There are the 3 big ones:

  • MS SQL is paid, has a lot of extensions to the languages
  • MySQL is free, and also has a lot of (different) extensions to the language
  • PostgreSQL is free, but tries to adhere to the SQL standard.

MariaDB is a fork of MySQL by the original authors of MySQL after Sun was bought by Oracle. So it’s pretty similar but the project have diverged a bit over the years.

For whatever use a Maker can have, any database will do.

1 Like

Unless you use the express edition, which is free but has some limitations: single core, 10GB Max per database.

For small projects, you might get away with a simple single-file sqlite database

1 Like

The majority of volunteer MySQL developers went over to MariaDB. If I couldn’t use PostgreSQL, I’d be using MariaDB.

2 Likes

I believe there is a 2GB ram allocation limit as well.

1 Like

If it’s just for personal use, you can also just use SQLite. There’s a seeded driver + translator now available, so you can pretty easily point it to a local database. I think there’s a few issues (resolved in 8.0.15) with history, but if you just need simple relationship mapping it works great. Extremely portable, too - it’s a single file on disk you can plainly copy.

3 Likes