Always a hotly debated topic.

--jeremy

mySQL.

Again the choice was not an easy one... There are others on the list, such as Oracle, I also like to work with.

Well,

With Oracle now requiring at least a phone call from an Oracle Sales Rep to just get the code for the Test Suite for building MySQL, I vote MariaDB.

I found it's better to go with the original author of MySQL (i.e. Michael "Monty" Widenius) and all the improvements and additional database engines he's put in than to stay with the codebase he left behind.

HTH.

2 members found this post helpful.

From a personal perspective, sqlite.

Of those on offer, I voted MariaDB - still love it for standard online SQL stuff - but I am really loving Orientdb, and recommend people to look at it

1 members found this post helpful.

Always used and voted for MySQL/MariaDB, but you gotta love how both of them manage to break your database on every upgrade, and you notice only after a few days or even months!

On every upgrade, I have to change some character encoding options, otherwise it gladly and silently inserts a lot of rubbish characters. This has happened at least two or three times to me. The last one was on MariaDB 10.0.28, where I had to reconfigure my database to use the `utf8mb4` encoding, because you know, `utf8` doesn't really mean `utf-8`, joke's on you, but rather just "a subset of UTF8 that can be represented in 3 bytes"!

MySQL

I'd normally vote sqlite since combined with the firefox addon sqlitemanager it's usability is just plain the greatest.

But if you haven't been paying attention, PostgreSQL is just not your daddies SQL elephant.

There are some really major strides forward there.

Here are some of the changelogs for the last few releases....

https://wiki.postgresql.org/wiki/Wha...PostgreSQL_9.3
https://wiki.postgresql.org/wiki/Wha...PostgreSQL_9.4
https://wiki.postgresql.org/wiki/Wha...PostgreSQL_9.5
https://wiki.postgresql.org/wiki/NewIn96

1 members found this post helpful.