LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   2014 LinuxQuestions.org Members Choice Awards (https://www.linuxquestions.org/questions/2014-linuxquestions-org-members-choice-awards-113/)
-   -   Database of the Year (https://www.linuxquestions.org/questions/2014-linuxquestions-org-members-choice-awards-113/database-of-the-year-4175528382/)

jeremy 12-15-2014 09:43 PM

Database of the Year
 
Always a hotly debated topic.

--jeremy

astrogeek 12-15-2014 10:21 PM

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

cyent 12-15-2014 11:27 PM

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

a4z 12-16-2014 02:07 AM

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! :)

lsces 12-16-2014 04:49 AM

Quote:

Originally Posted by a4z (Post 5285348)
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.

dr_agon 12-16-2014 02:33 PM

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.

cyent 12-16-2014 03:51 PM

Quote:

Originally Posted by a4z (Post 5285348)
I want to be able vote for both! :)

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.

veerain 12-16-2014 10:45 PM

Sqlite is easy to use and learn and work!

Tux! 12-17-2014 02:39 AM

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)

chrisretusn 12-17-2014 03:40 AM

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

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

warmbooter 12-17-2014 07:21 AM

Firebird, always!

kooru 12-17-2014 07:32 AM

I love sqlite.

mariuz 12-17-2014 08:15 AM

Firebird 3.0
 
I voted Firebird 3.0


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

fatmac 12-17-2014 08:40 AM

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

steeladept 12-17-2014 11:36 AM

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>
Quote:

That said, I have worked with MongoDB a lot this year and it is an interesting beast. Maybe not fit in this category, though, since it is a NoSQL option. Perhaps for next year break out DB to SQLDB and NSQLDB? Just a thought.
</ignore>

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


All times are GMT -5. The time now is 05:13 PM.