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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
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% |
 |
|
12-15-2014, 08:43 PM
|
#1
|
root 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 13,620
|
Database of the Year
Always a hotly debated topic.
--jeremy
|
|
|
12-15-2014, 09:21 PM
|
#2
|
Moderator
Registered: Oct 2008
Distribution: Slackware [64]-X.{0|1|2|37|-current} ::12<=X<=15, FreeBSD_12{.0|.1}
Posts: 6,354
|
MariaDB and PostgreSQL, almost neck and neck... but MariaDB by a nose!
|
|
|
12-15-2014, 10:27 PM
|
#3
|
Member
Registered: Aug 2001
Location: ChristChurch New Zealand
Distribution: Ubuntu
Posts: 400
Rep:
|
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
|
|
|
12-16-2014, 01:07 AM
|
#4
|
Senior Member
Registered: Feb 2009
Posts: 1,727
|
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! 
|
|
|
12-16-2014, 03:49 AM
|
#5
|
LQ Newbie
Registered: Nov 2003
Location: Broadway, UK
Posts: 24
Rep:
|
Quote:
Originally Posted by a4z
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.
|
|
|
12-16-2014, 01:33 PM
|
#6
|
Member
Registered: Sep 2007
Location: Poland
Distribution: Ubuntu LTS
Posts: 105
Rep:
|
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.
|
|
|
12-16-2014, 02:51 PM
|
#7
|
Member
Registered: Aug 2001
Location: ChristChurch New Zealand
Distribution: Ubuntu
Posts: 400
Rep:
|
Quote:
Originally Posted by a4z
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.
|
|
|
12-16-2014, 09:45 PM
|
#8
|
Senior Member
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524
|
Sqlite is easy to use and learn and work!
|
|
|
12-17-2014, 01:39 AM
|
#9
|
Member
Registered: May 2011
Location: Netherlands
Distribution: openSUSE
Posts: 114
Rep:
|
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 01:40 AM.
|
|
|
12-17-2014, 02:40 AM
|
#10
|
Senior Member
Registered: Dec 2005
Location: Philippines
Distribution: Slackware64-current
Posts: 3,374
|
This year a change for me, MariaDB twas MySQL before.
Honorable mention. A favorite of mine, Sybase. We go back a long way. 
|
|
|
12-17-2014, 06:21 AM
|
#11
|
LQ Newbie
Registered: Nov 2003
Posts: 2
Rep:
|
Firebird, always!
|
|
|
12-17-2014, 06:32 AM
|
#12
|
Senior Member
Registered: Sep 2012
Posts: 1,385
|
I love sqlite.
|
|
|
12-17-2014, 07:40 AM
|
#14
|
LQ Guru
Registered: Sep 2011
Location: Upper Hale, Surrey/Hants Border, UK
Distribution: One main distro, & some smaller ones casually.
Posts: 5,863
Rep: 
|
Though I don't use databases much these days, I have voted for sqlite because it is easy to use for basic needs.
|
|
|
12-17-2014, 10:36 AM
|
#15
|
LQ Newbie
Registered: Oct 2014
Posts: 24
Rep: 
|
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 11:00 AM.
|
|
|
All times are GMT -5. The time now is 08:06 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|