LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-16-2003, 04:08 PM   #1
Raspis21
Member
 
Registered: Jun 2003
Posts: 33

Rep: Reputation: 15
Pgsql or mysql? other?


Hi all,


I am planning a new sql server for my office, I am currently using Mysql. My question (since this is linux questions) is which does everyone feel is better, MySQL or Postgre? I have read quite a bit on this, but I'd like to hear is from a bunch of real lifers. Anyone? Don't hesitate to post or ask for more info.

Thanks,

Ras
 
Old 10-16-2003, 10:44 PM   #2
killjoy
Member
 
Registered: Mar 2001
Location: Atlanta,GA
Distribution: Red Hat, Mandrake
Posts: 66

Rep: Reputation: 15
I love MySQL
I run 6 websites (medium traffic) out of 1 DB with a celleron 600 and 128 MB RAM.
Never even blinks-and it's still pretty fast!!
 
Old 10-16-2003, 11:31 PM   #3
speter
Member
 
Registered: Sep 2003
Location: Edison, NJ
Distribution: Fedora, Mac OS X
Posts: 313

Rep: Reputation: 30
I'd give MySQL thumbs up, although I've not used postgreSQL, just MySQL and Oracle. Since I started with MySQL, I've had no reasons to want to switch, FWIW.

Steve
 
Old 10-17-2003, 12:31 PM   #4
Raspis21
Member
 
Registered: Jun 2003
Posts: 33

Original Poster
Rep: Reputation: 15
Ok,

Thanks guys, I like mySQL too, but I just want to make sure I am not missing out on anything postgre could serve up. (bad pun intended)

Everyone else...chime in will ya?


Thanks
 
Old 10-17-2003, 12:47 PM   #5
speter
Member
 
Registered: Sep 2003
Location: Edison, NJ
Distribution: Fedora, Mac OS X
Posts: 313

Rep: Reputation: 30
Quote:
Originally posted by Raspis21
Thanks guys, I like mySQL too, but I just want to make sure I am not missing out on anything postgre could serve up.
Why not just try it? It's not like you have to put cash on the barrel.

Steve
 
Old 10-17-2003, 01:55 PM   #6
mcleprechaun
Member
 
Registered: Oct 2003
Location: Missouri
Distribution: Slackware
Posts: 32

Rep: Reputation: 15
I started with PostgreSQL and I have never had a reason to switch. I have one server with MySQL and PostgreSQL both running so I can play with them. It is really a comfort thing as to what you are used to. Both are very capable and free but when I search for tools or look at DB applications, there seem to be more that are set up for MySQL.
No matter which one (or both) you run, I recommend PHPMyAdmin and PHPPgAdmim as the best GUI interfaces I have found.
 
Old 10-17-2003, 03:38 PM   #7
Pete Dogg
Member
 
Registered: May 2003
Location: Ontario, Canada
Distribution: Mandrake 9.0, RedHat 7.3, Mandrake 9.2
Posts: 178

Rep: Reputation: 31
i've looked quite a bit into this as well.

postgresql is FAR superior when it comes to mission critical data (row level locking etc). mysql just doesnt have the data integrity that you can count on.

mysql is good if you dont need a lot of locking and one users changes data at a time. like a small site with one admin and many readers.

i use mysql and sybase (costs money) in production. I have not used postgresql in production but if I were to switch the site that uses sybase, I could not use mysql I would have to go with postgresql.

After looking at this for a long time and wondering why people use mysql over postgresql. I believe it's because mysql has a bigger install base. If postgresql was the default DB your hosting provider offered, no one would complain.

Last edited by Pete Dogg; 10-17-2003 at 03:40 PM.
 
Old 10-17-2003, 03:40 PM   #8
notsoevil
Member
 
Registered: May 2001
Location: Louisville, Kentucky, USA
Distribution: RedHat ES
Posts: 120

Rep: Reputation: 15
I think it all really depends on what you need to do, the scale, the reliablity and such. I started with MySQL as a backend for applications, but ran into several walls trying to do complex queries that involved sub-selects. That's why I initially looked at PostgreSQL and I've never looked back.

I'm not sure if you know who Randall Scwartz is or not, but he's a well-respected author on Perl and in an article in Linux Magazine, he says that PostgreSQL is an open-source alternative to Oracle, as far as scalability, stability and features are concerned. And quite frankly, I agree with that.
 
Old 10-17-2003, 05:09 PM   #9
Raspis21
Member
 
Registered: Jun 2003
Posts: 33

Original Poster
Rep: Reputation: 15
Hey great,

Thanks guys, that is what I wanted to hear. I have looked as I said I have looked at a lot of comparisons, and think postgre could be a nice setup. I'll try it, but still keep that mysql ready as a backup. Thanks agian. Anyone else?


Ras
 
Old 11-03-2003, 08:47 AM   #10
elpot2
LQ Newbie
 
Registered: Oct 2003
Posts: 5

Rep: Reputation: 0
Hi,

Sybase 11.0.3.3 is now *free* for production use. You can dowload a copy from http://linux.sybase.com/ase/11033download.html

I've used Sybase on IBM AIX for years and have always liked it, so I'm eager to see what it's like on Linux.

Trevor

Last edited by elpot2; 11-03-2003 at 08:49 AM.
 
Old 11-05-2003, 09:07 PM   #11
Rico16135
Member
 
Registered: Aug 2003
Location: Texas, USA
Distribution: Slackware 9.1, SuSE 9.1
Posts: 245

Rep: Reputation: 30
I think that the people behind mysql would give an argument for every statement mentioned that would superiorize PostgreSQL . I think its all propaganda, I believe they are both great DB's but I would personally go with MYSQL because of the, (what I believe at least) better support, and tools. Not to say anything bad about Postgre tho.... they're both awesome.
 
Old 11-11-2003, 05:04 PM   #12
scorpatron
Member
 
Registered: Nov 2003
Location: New Zealand
Distribution: Redhat 9 2.4.20-8 Athlon, Windows 2000 Professional, FreeBSD
Posts: 122

Rep: Reputation: 15
propaganda?

postgres is designed to be able to handle mass databasing, MySQL however fast it is, cannot compete with postgres on a large scale.

but if you are thinking small then go with MySQL

Personally I am having some issues with the PHP-> PostGres module, which kinda sucks, but oh well
 
Old 11-12-2003, 02:05 AM   #13
Rico16135
Member
 
Registered: Aug 2003
Location: Texas, USA
Distribution: Slackware 9.1, SuSE 9.1
Posts: 245

Rep: Reputation: 30
I do think the folks behind mysql would argue about its mass database capability. They'd point to the many large billion dollar corps using mysql as their database solution. mysql has come along way since its inception into the business world.
 
Old 11-14-2003, 11:25 PM   #14
scorpatron
Member
 
Registered: Nov 2003
Location: New Zealand
Distribution: Redhat 9 2.4.20-8 Athlon, Windows 2000 Professional, FreeBSD
Posts: 122

Rep: Reputation: 15
fair enough,

in conclusion, both are much better than m$-access

(I only use postgres because I only know postgres)
 
  


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



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL & pgSQL problems w/ PHP dolvmin Linux - Software 2 10-28-2005 11:36 PM
Nothing after rc.pgsql in rc.M starts karlmdv Slackware 4 04-04-2005 04:44 PM
string tokenise in pl/pgsql hk_linux Programming 2 03-18-2005 06:00 AM
PL/pgSQL anyone? vickr1z Linux - Newbie 0 10-20-2004 01:58 AM
Dates in PL/PGSQL anisbet Linux - General 0 11-19-2001 11:16 AM


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