Database of the Year
 

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.

Firebird 3.0
 

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....

Firebird.

<sounds of crickets> MySQL. Again, like oatmeal in the morning, it is there.

software tools
 

It's unfortunate that there are three different entries for MySQL, MariaDB, and Percona. That's going to chop up the MySQL votes across three different segments, and perhaps give people the wrong impression.

Firebird forever!
Stable and lightweight. Easy-to-admin one-file database.
10+ years and 200+ installations of our system!
Most of them used without DBA assistance at all!

MySQL

LOL!!! Here come the low post count Firebird shills! Every year they seem to crawl out of the woodwork to push Firebird to artificial high showing in this poll. Have you no shame?!

Apparently not..... I vote PostgreSQL ;D

I'd vote for JavaDB / Apache Derby if I could.
Been using it quite a lot last year, haven't ran into any real trouble...yet :)

I like both MariaDB 10x and Percona for 5.x. I voted for Percona, as I found the Percona toolkit to be quite useful at work, particularly using xtrabackup as a non-locking alternative to mysqldump.

Sybase is my favorite. We're doing a lot more in MS SQL Server nowadays, and it's shown promise but Sybase is still our gold standard. Postgres will probably be the next platform in our sights as we've heard good things about it. It would be nice to move to something that cost a little less!

sqlite is useful in certain ways, but I wouldn't jump so far as to say it's my favorite ... or even the DB platform of the year ...

MySQL would fall below sqlite, because making a backup is flat-out ridiculous; I just want to send a single command, darn it.

Just here to be pedantic about the poll wording again. ;^) But these are "database management systems" ("relational database management systems" if they all qualify). A "database" is an actual collection of data.

Percona

And like so many other former Sun "properties", MySQL begins it's slow fade to irrelevance post Oracle takeover.

Meamwhile, PostgreSQL has risen from relative obscurity (look back 4-5 years results) to a respectable second place (although it deserves first;)