Always a hotly debated topic.

--jeremy

MariaDB and PostgreSQL, almost neck and neck... but MariaDB by a nose!

PostgresSQL has always been excellent, but it has been on a roll this year with a large number of exciting new features.

A number of them are in the category... NoSQL or SQL? Choose Postgresql and get the best of both worlds where appropriate to your problem.

http://postgresweekly.com/issues

it is somehow absurd to have PostgreSQL and sqlite in the same category
sqlite is for sure the widest used db on planet and its wonderful,
and PostgreSQL is also wonderful
I want to be able vote for both!

Probably agree with that statement. sqlite is not something that would be used for a multi-user data management system. I use Firebird for that, but while we have an embedded version of Firebird, sqlite is more normal for local data management.

Recently I migrated PostgreSQL database from v. 9.1 to 9.3, and I was prepared for hard time, but it went smoothly and fast, zero problems! It's my favorite.

Normally I would vote Sqlite for all the Goodness you mention... except this year pgsql has been exploding with new and tasty features.

Although I don't know when Sqlite grew http://www.sqlite.org/lang_with.html Recursive Select..... but I certainly only became aware of it this year.

Sqlite is easy to use and learn and work!

For *real* database work, I'll (again) choose Postgres.

Firebird is growing, but the quirks are too many to make it useful
Oracle is too expensive and until they fix "" in varchar storing as NULL, it still is no real database imho. A database should store what you put in it and return the same value(s)
SQLite is growing better and better and is ideal for quick-n-dirty work but only works for use in a single process/thread
MySQL and MariaDB are useless when dealing in a mixed Unix-Windows environment due to their extremely stupid defaults (that esp on Windows are never changed to sane)

This year a change for me, MariaDB twas MySQL before.

Honorable mention. A favorite of mine, Sybase. We go back a long way.

Firebird, always!

I love sqlite.

I voted Firebird 3.0


Brings a list of impressive features
http://www.firebirdsql.org/en/news/f...testing-62805/

Though I don't use databases much these days, I have voted for sqlite because it is easy to use for basic needs.

I typically do not do database work, so I go with what the application recommends (which usually goes to MySQL as the lowest common denominator).

<ignore the following quote from the original post>
</ignore>

Didn't look down the main list far enough for the NoSQL DB....