LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > 2009 LinuxQuestions.org Members Choice Awards
User Name
Password
2009 LinuxQuestions.org Members Choice Awards This forum is for the 2009 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2009. This is your chance to be heard! Voting ends on February 9th.

Notices

View Poll Results: Database of the Year
MySQL 239 60.81%
PostgreSQL 89 22.65%
Drizzle 2 0.51%
Firebird 10 2.54%
sqlite 33 8.40%
EnterpriseDB 1 0.25%
Berkley DB 2 0.51%
InnoDB 1 0.25%
Oracle 8 2.04%
Cassandra 0 0%
DB2 3 0.76%
MariaDB 3 0.76%
MongoDB 2 0.51%
Hypertable 0 0%
Voters: 393. You may not vote on this poll

Reply
 
Search this Thread
Old 01-11-2010, 11:56 PM   #16
SkyEye
Member
 
Registered: Sep 2005
Location: Sri Lanka
Distribution: Fedora (workstations), CentOS (servers), Arch, Mint, Ubuntu, and a few more.
Posts: 441

Rep: Reputation: 40
Thumbs up


Quote:
Originally Posted by MBybee View Post
I think you have that backwards - RDBMS came most recently. I honestly don't think that the transition to RDBMS makes any sense in a large scale setting, but then again I was one of the big fans of the technology when it started really gaining ground.

SQL took a world full of custom, non-portable query languages and methods (InnoDB, DBase, IMS, ISAM/VSAM, BerkelyDB, Info) and standardized on a single simple API.

That being said, RDBMS is also not a one size fits all, especially if all you're doing is reading data that's not truly relational or gains no benefits from normalization or de-normalization.

Probably a discussion for a different thread... but please bear in mind that this is not a new idea. This is an ancient idea that was retired for a reason, just like virtualization and clustering. There are places and times for every approach - and trotting out 40 year old techniques with a nifty new name does not invalidate the 40 years since they were considered cutting edge nor the reasons why they fell from popularity
No, I meant what I said.

I know non-relational DBMSs are not new. How, old? I don't know. What I meant was that after a long period of domination by relarional/SQL based DBMSs the world is ready to give the alternative philosophies another try.

I'm not saying we should avoid relational DBMSs like a plague. They have proven their value. But approaches like document-oriented, key-value store, etc. NoSQL (so to speak) has gain a significant momentum to demand fair trial.

That's how technology works (and IMHO, how it should). Dominant/popular concepts get challenged by alternatives. Maybe a little at the beginning, but yet significant enough. Unix was (and still is) old. There was Windows, NetWare, etc. Then here we are with Linux and BSDs.

Evolving technologies are something that cannot be retired just like that. Because they won't stay in the same state where the rationale for their retirement holds true forever. And also things change sometimes creating enough leverage which weren't available back then. So virtualization, cloud computing, REST, Dynamic languages, etc. are not new topics. I'm not saying all these are oh-so-great either. However there is no denying that the industry is using virtualization, cloud concept, dynamix languages, REST, Linux, etc. If you and me didn't try FOSS OSs like Linux and BSDs we wouldn't be having this conversation either. But the point is "we did", and so did a lot of others. Isn't that just beautiful.

PS: I agree. Let's keep this thread flow on it's course. We were more or less off-topic. But enjoyed hearing from you.

Last edited by SkyEye; 01-12-2010 at 12:05 AM.
 
Old 01-12-2010, 07:31 PM   #17
nux_ro
LQ Newbie
 
Registered: Jan 2010
Location: London
Distribution: CentOS
Posts: 8

Rep: Reputation: Disabled
Postgre
 
Old 01-13-2010, 09:36 AM   #18
portamenteff
Member
 
Registered: Feb 2006
Location: Colorado
Distribution: sabayon
Posts: 178
Blog Entries: 1

Rep: Reputation: 36
mysql by far. especially with scripted web pages.
 
Old 01-13-2010, 03:18 PM   #19
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,983
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
As every year: postgres, without a shadow of a doubt.

:}
 
Old 01-13-2010, 08:37 PM   #20
raju.mopidevi
Senior Member
 
Registered: Jan 2009
Location: vijayawada, India
Distribution: openSUSE 11.2, Ubuntu 9.0.4
Posts: 1,155
Blog Entries: 12

Rep: Reputation: 92
My sql ..
 
Old 01-15-2010, 09:41 PM   #21
indienick
Senior Member
 
Registered: Dec 2005
Location: London, ON, Canada
Distribution: Arch, Ubuntu, Slackware, OpenBSD, FreeBSD
Posts: 1,853

Rep: Reputation: 65
MySQL - it's all we use at work!
 
Old 01-20-2010, 01:32 PM   #22
AleLinuxBSD
Member
 
Registered: May 2006
Location: Italy
Distribution: Ubuntu, ArchLinux, Debian, SL, OpenBSD
Posts: 272

Rep: Reputation: 37
PostgreSQL.

I'm curious even about more small alternatives for projects with more small data.
I hope (despite many doubts) that MariaDB go well.
Perhaps a day i will try even Firebird.
 
Old 01-20-2010, 02:04 PM   #23
rocket357
Member
 
Registered: Mar 2007
Location: 127.0.0.1
Distribution: OpenBSD-CURRENT
Posts: 476
Blog Entries: 118

Rep: Reputation: 74
None other than "The world's most advanced open source database"
 
Old 01-20-2010, 02:18 PM   #24
the1sephiroth
Member
 
Registered: Oct 2005
Location: east coast
Distribution: Ubuntu
Posts: 131

Rep: Reputation: 15
I've tried MySQL and sqlite, and I can say that I don't know enough to tell a difference in performance. I also run a rather low-usage site on the work intranet and Mysql seems to do just fine for it.
 
Old 01-20-2010, 09:05 PM   #25
clsgis
LQ Newbie
 
Registered: Nov 2007
Posts: 18

Rep: Reputation: 1
PostgreSQL, because its commercial competitor doesn't own it and its manual is better.
I just can't believe MySQL is safe with Oracle.
 
Old 01-20-2010, 09:49 PM   #26
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,983
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Quote:
Originally Posted by rocket357 View Post
None other than "The world's most advanced open source database"
And for people who don't know that slogan:

He is referring to PostgreSQL

Which is called either Postgres (for the old-timers)
or Postgres-queue-el, not Postgre. :}

Last edited by Tinkster; 01-20-2010 at 09:50 PM.
 
Old 01-20-2010, 10:54 PM   #27
nguyenhoangvk
LQ Newbie
 
Registered: Feb 2008
Posts: 5

Rep: Reputation: 0
mysql
 
Old 01-21-2010, 06:38 AM   #28
leedude
Member
 
Registered: Jan 2007
Location: Scotland
Distribution: Fedora, Debian
Posts: 81

Rep: Reputation: 15
sqlite.

damned useful.
 
Old 01-21-2010, 07:38 AM   #29
ojha_riddhish
LQ Newbie
 
Registered: Mar 2009
Location: Vapi, India
Distribution: RHEL 5, openSUSE 11.1, Ubuntu 8.10 / 9.04, Fedora 10
Posts: 19

Rep: Reputation: 0
MySQL for me
 
Old 01-21-2010, 02:58 PM   #30
Lexus45
Member
 
Registered: Jan 2010
Location: Kurgan, Russia
Distribution: Slackware, Ubuntu
Posts: 339
Blog Entries: 3

Rep: Reputation: 47
if MySQL, don't hesitate to look here http://monty-says.blogspot.com/2009/...ing-mysql.html
 
  


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 2007 LinuxQuestions.org Members Choice Awards 78 05-04-2009 04:36 AM
Database of the Year jeremy 2008 LinuxQuestions.org Members Choice Awards 60 02-22-2009 09:21 AM
Database of the Year jeremy 2005 LinuxQuestions.org Members Choice Awards 125 01-28-2007 02:14 AM


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

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration