Jump to content

mySQL or postgreSQL?


umekille78

Recommended Posts

Hi!Can anyone help me and explain the diference between mySQL and postgreSQL. Im trying to set up a Linux webserver using Apache and PHP and a SQL program.If I remeber corectly postgreSQL is free. Is that right? And if so how much do mySQL cost?Can anyone help me with this? Is PHP and postgreSQL conpatable?/Per

Link to comment
Share on other sites

Check out this site for postgresql and mysql...http://www.vitavoom.com/postgresql.html

Looks good. I have never used postgresql...I think I will still stick with MySQL for development since my host of choice and most of the the others I have seen use MySql.Does postgreSQL have a GUI interface??? I don't like having to use phpMyAdmin to administer databases.
Link to comment
Share on other sites

I have never used this GUI, PGADMIN III. try it....http://www.pgadmin.org/

That looks awesome. phpMyAdmin (for MySQL) is web based and can be a pain in the neck, although it is good if you are away from your server.There is a desktop app for admin mySQL but it cost a lot.
Link to comment
Share on other sites

There are several differences between postgreSQL and MySQL, but most of them are relatively minor things that most people don't get involved with, like triggers and views. The newest versions of MySQL have added a lot of the features that were missing. The different databases also handle different data sizes better or worse, but there are people on both sides who will argue which one is better. Both of them are free, both are open source, both of them are fast, both of them are stable. There's little difference to which one you use in most situations, if you are using a database wrapper like Pear or something you build yourself you can basically switch between them without having to change your code.And yes, PHP also supports postgres:http://us2.php.net/manual/en/ref.pgsql.phpAlso, that link above that is pro-postgreSQL is obviously biased:

... is a RDMBS that has grown alone, instead of MySQL which is a hack of several tools "glued" together (MSQL, Berkeley DB). This lead to weird things like ISAM, MYISAM, BerkeleyDB, InnoDB, HEAP, MERGE, and Gemini table types (!?!) and other hybrid designs on MySQL's core..
Calling your competition a hack and using the punctuation "!?!" anywhere tells you that these guys are out to pimp postgres. In all actuality, you can pretty much use whichever one your server supports (or flip a coin if you want) and not see much of a difference, unless maybe you're building the next amazon.com or something. BTW, I think both amazon and yahoo use PHP/MySQL.Edit: here's a comparison of the two:http://www.databasejournal.com/features/my...cle.php/3288951I'm not sure about Amazon, but I know that places like Google, Slashdot, LiveJournal, etc use MySQL. Here is their customer list:http://www.mysql.com/customers/And here it is for postgres:http://www.postgresql.org/about/usersI think this is funny:LAMP (Linux/Apache/Middleware(Perl,PHP,Python,Ruby)/PostgreSQLApparently now the 'M' is middleware, and the 'P' is postgres. I thought it was Linux/Apache/MySQL/PHP.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...