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

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!!

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

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

Why not just try it? It's not like you have to put cash on the barrel.

Steve

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.

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.

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.

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

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

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.

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

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.

fair enough,

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

(I only use postgres because I only know postgres)