LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > 2014 LinuxQuestions.org Members Choice Awards
User Name
Password
2014 LinuxQuestions.org Members Choice Awards This forum is for the 2014 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2014. This is your chance to be heard! Voting ends on February 3rd.


Notices


View Poll Results: Database of the Year
DB2 1 0.33%
Drizzle 0 0%
EnterpriseDB 0 0%
Firebird 26 8.55%
MariaDB 104 34.21%
MySQL 63 20.72%
Oracle 7 2.30%
Percona 2 0.66%
PostgreSQL 70 23.03%
sqlite 31 10.20%
Voters: 304. You may not vote on this poll

Reply
  Search this Thread
Old 12-15-2014, 09:43 PM   #1
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 12,461

Rep: Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337Reputation: 3337
Database of the Year


Always a hotly debated topic.

--jeremy
 
Old 12-15-2014, 10:21 PM   #2
astrogeek
Moderator
 
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=14, FreeBSD_10{.0|.1|.2}
Posts: 4,515
Blog Entries: 6

Rep: Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426Reputation: 2426
MariaDB and PostgreSQL, almost neck and neck... but MariaDB by a nose!
 
Old 12-15-2014, 11:27 PM   #3
cyent
Member
 
Registered: Aug 2001
Location: ChristChurch New Zealand
Distribution: Ubuntu
Posts: 336

Rep: Reputation: 73
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
 
Old 12-16-2014, 02:07 AM   #4
a4z
Senior Member
 
Registered: Feb 2009
Posts: 1,434

Rep: Reputation: 613Reputation: 613Reputation: 613Reputation: 613Reputation: 613Reputation: 613
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!
 
Old 12-16-2014, 04:49 AM   #5
lsces
LQ Newbie
 
Registered: Nov 2003
Location: Broadway, UK
Posts: 23

Rep: Reputation: 0
Quote:
Originally Posted by a4z View Post
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.
 
Old 12-16-2014, 02:33 PM   #6
dr_agon
Member
 
Registered: Sep 2007
Location: Poland
Distribution: Ubuntu LTS
Posts: 102
Blog Entries: 12

Rep: Reputation: 26
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.
 
Old 12-16-2014, 03:51 PM   #7
cyent
Member
 
Registered: Aug 2001
Location: ChristChurch New Zealand
Distribution: Ubuntu
Posts: 336

Rep: Reputation: 73
Quote:
Originally Posted by a4z View Post
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.
 
Old 12-16-2014, 10:45 PM   #8
veerain
Senior Member
 
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524

Rep: Reputation: 319Reputation: 319Reputation: 319Reputation: 319
Sqlite is easy to use and learn and work!
 
Old 12-17-2014, 02:39 AM   #9
Tux!
Member
 
Registered: May 2011
Location: Netherlands
Distribution: OpenSUSE
Posts: 47

Rep: Reputation: 21
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)

Last edited by Tux!; 12-17-2014 at 02:40 AM.
 
Old 12-17-2014, 03:40 AM   #10
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 614

Rep: Reputation: Disabled
This year a change for me, MariaDB twas MySQL before.

Honorable mention. A favorite of mine, Sybase. We go back a long way.
 
Old 12-17-2014, 07:21 AM   #11
warmbooter
LQ Newbie
 
Registered: Nov 2003
Posts: 2

Rep: Reputation: 6
Firebird, always!
 
Old 12-17-2014, 07:32 AM   #12
kooru
Senior Member
 
Registered: Sep 2012
Posts: 1,385

Rep: Reputation: 273Reputation: 273Reputation: 273
I love sqlite.
 
Old 12-17-2014, 08:15 AM   #13
mariuz
Member
 
Registered: Nov 2003
Distribution: gentoo
Posts: 69

Rep: Reputation: 19
Thumbs up Firebird 3.0

I voted Firebird 3.0


Brings a list of impressive features
http://www.firebirdsql.org/en/news/f...testing-62805/
 
Old 12-17-2014, 08:40 AM   #14
fatmac
Senior Member
 
Registered: Sep 2011
Location: Upper Hale, Surrey/Hants Border, UK
Distribution: AntiX
Posts: 1,978

Rep: Reputation: Disabled
Though I don't use databases much these days, I have voted for sqlite because it is easy to use for basic needs.
 
Old 12-17-2014, 11:36 AM   #15
steeladept
LQ Newbie
 
Registered: Oct 2014
Posts: 24

Rep: Reputation: Disabled
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....

Last edited by steeladept; 12-17-2014 at 12:00 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Database of the Year jeremy 2011 LinuxQuestions.org Members Choice Awards 53 03-05-2012 06:32 AM
Database of the Year jeremy 2009 LinuxQuestions.org Members Choice Awards 39 03-06-2010 05:16 AM
Database of the Year jeremy 2007 LinuxQuestions.org Members Choice Awards 78 05-04-2009 05:36 AM

LinuxQuestions.org > Forums > 2014 LinuxQuestions.org Members Choice Awards

All times are GMT -5. The time now is 09:36 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration