LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > 2007 LinuxQuestions.org Members Choice Awards
User Name
Password
2007 LinuxQuestions.org Members Choice Awards This forum is for the 2007 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2007. This is your chance to be heard! Voting ends February 21st.

Notices

View Poll Results: Database of the Year
MySQL 436 54.36%
PostgreSQL 174 21.70%
Firebird 77 9.60%
sqlite 53 6.61%
Oracle 28 3.49%
Sybase 4 0.50%
DB2 5 0.62%
Berkley DB 4 0.50%
InnoDB 1 0.12%
EnterpriseDB 20 2.49%
Voters: 802. You may not vote on this poll

Reply
 
Search this Thread
Old 01-29-2008, 10:11 AM   #61
azucaro
Member
 
Registered: Jan 2005
Location: Washington, D.C.
Distribution: Arch (Custom), CentOS
Posts: 239

Rep: Reputation: 30

As a professional database admin, I have to say PostgreSQL is the best without a doubt.
 
Old 01-29-2008, 06:24 PM   #62
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
Quote:
Originally Posted by azucaro View Post
As a professional database admin, I have to say PostgreSQL is the best without a doubt.
And after having to deal with MySQL in a commercial/corporate environment in my previous and current job, I also agree that PostgreSQL is the more superior database that's opensource and free. I only use MySQL for web based PHP applications, etc.
 
Old 02-01-2008, 04:06 AM   #63
Takla
Member
 
Registered: Aug 2006
Distribution: Debian
Posts: 188

Rep: Reputation: 33
Database of the year just has to be the one the British govt lost while sending a full copy of it between departments, unencrypted and by cheap commercial courier. 2 DVDs containing full details (social, financial) of every child and parent/guardian in the UK. Is there a category for security breach of the year?
 
Old 02-01-2008, 12:36 PM   #64
Eric21
LQ Newbie
 
Registered: Feb 2006
Distribution: Ubuntu, Suse, Puppy
Posts: 4

Rep: Reputation: 0
Postgresql with PostGIS
 
Old 02-01-2008, 01:22 PM   #65
G13man
LQ Newbie
 
Registered: Jan 2008
Location: baltimore md usa
Distribution: 12.04.2 have had rh9.0 checking now ,dsl,ubuntu, pclos, smoothwall3,fedora,mandravia,
Posts: 26

Rep: Reputation: 14
sorry , can not vote due to the fact i do not use a data base...( c..not all new ppl vote for firefox)but am learning
 
Old 02-01-2008, 01:56 PM   #66
fdan52
LQ Newbie
 
Registered: Apr 2007
Posts: 1

Rep: Reputation: 0
How come no complaints about Oracle? I mean it's free if you don't go production (I.E. Business)

And if you do, the customer pays.
 
Old 02-02-2008, 12:06 AM   #67
jachguate
LQ Newbie
 
Registered: Jan 2008
Location: Guatemala
Distribution: debian
Posts: 7

Rep: Reputation: 0
Quote:
Originally Posted by fdan52 View Post
How come no complaints about Oracle? I mean it's free if you don't go production (I.E. Business)

And if you do, the customer pays.
I think you're forgetting the eXpress edition. If it meet the requirements, your customer can go to production using this edition for free (even in business).

Best regards.
 
Old 02-03-2008, 10:43 AM   #68
jobinau
LQ Newbie
 
Registered: Jun 2007
Posts: 5

Rep: Reputation: 0
Dear Friends,
Oracle is not a Free software.
Free means Free in "freedom of speech". not in terms of money.
Oracle XE and Microsoft MSDE are a scale down versions for those who bites.
Those are Just Fish hooks. ones you develop something based on that and put it into production. situation will force you to buy the other versions.
If you already used it for production, you will have already experienced the same.
So if you are planing to use any of them, please make sure that you know all the limitations imposed in them.
Thank you.
 
Old 02-08-2008, 04:58 AM   #69
zwlsky
LQ Newbie
 
Registered: Feb 2008
Location: QingDao,ShanDong,China
Posts: 2

Rep: Reputation: 0
I thank MySQL is the easiest to install and use!
 
Old 02-08-2008, 05:30 AM   #70
Mega Man X
Guru
 
Registered: Apr 2003
Location: ~
Distribution: Ubuntu, FreeBSD, Solaris, DSL
Posts: 5,339

Rep: Reputation: 63
Quote:
Originally Posted by zwlsky View Post
I thank MySQL is the easiest to install and use!
So you clearly never tried SQLite
 
Old 02-08-2008, 06:28 PM   #71
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,973
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Quote:
Originally Posted by Mega Man X View Post
So you clearly never tried SQLite :)
C'mon ... sqlite is great, and most certainly has its place, but
you can't really compare it with the stand-alone databases. You
*need* to be happy to do programming to use it. At least last
time I looked there was no stand-alone product.

That said: the ease of use and installation is what people
attribute to windows.
/me chuckles


Cheers,
Tink
 
Old 02-16-2008, 03:56 PM   #72
diilbert
Member
 
Registered: Nov 2003
Location: North of the Border
Distribution: Gentoo & Debian
Posts: 155

Rep: Reputation: 30
MySQL. Been using it for a long time and will continue to do so.
 
Old 02-19-2008, 06:11 AM   #73
nico.callewaert
LQ Newbie
 
Registered: Jan 2008
Posts: 2

Rep: Reputation: 0
PostgreSQL

Hi,

I love PostgreSQL, but I find triggers / functions difficult. There is not much documentation / examples available on these subjects. That withholds me from using it...

Best regards, Nico
 
Old 02-19-2008, 12:34 PM   #74
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,973
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Quote:
Originally Posted by nico.callewaert View Post
Hi,

I love PostgreSQL, but I find triggers / functions difficult. There is not much documentation / examples available on these subjects. That withholds me from using it...

Best regards, Nico
I'm curious: what are you missing in terms of the docu?
A discussion would blow the context of this thread, please
post your questions in Linux-Software or Programming.



Cheers,
Tink
 
Old 02-20-2008, 01:33 AM   #75
nico.callewaert
LQ Newbie
 
Registered: Jan 2008
Posts: 2

Rep: Reputation: 0
Quote:
Originally Posted by Tinkster View Post
I'm curious: what are you missing in terms of the docu?
A discussion would blow the context of this thread, please
post your questions in Linux-Software or Programming.



Cheers,
Tink
Hello !

Yes, sure, it's not the purpose to start a discussion on this thread. But to answer your question. Triggers / functions are different from let's say Firebird and I don't succeed to learn it. It would be great to have some example DB schema's full of triggers / functions. But that's off topic of course.

Thanks, best regards, Nico
 
  


Reply

Tags
postgres, postgresql


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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database of the Year jeremy 2006 LinuxQuestions.org Members Choice Awards 57 02-20-2007 11:42 AM


All times are GMT -5. The time now is 06:58 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