umekille78 Posted April 17, 2006 Share Posted April 17, 2006 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 More sharing options...
aspnetguy Posted April 17, 2006 Share Posted April 17, 2006 PHP has lots of great, built-in, functions for MySql. Choose that one...you will probably find more support for MySql as well. Link to comment Share on other sites More sharing options...
pulpfiction Posted April 17, 2006 Share Posted April 17, 2006 Check out this site for postgresql and mysql...http://www.vitavoom.com/postgresql.html Link to comment Share on other sites More sharing options...
aspnetguy Posted April 18, 2006 Share Posted April 18, 2006 Check out this site for postgresql and mysql...http://www.vitavoom.com/postgresql.html<{POST_SNAPBACK}> 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 More sharing options...
pulpfiction Posted April 18, 2006 Share Posted April 18, 2006 I have never used this GUI, PGADMIN III. try it....http://www.pgadmin.org/ Link to comment Share on other sites More sharing options...
aspnetguy Posted April 18, 2006 Share Posted April 18, 2006 I have never used this GUI, PGADMIN III. try it....http://www.pgadmin.org/<{POST_SNAPBACK}> 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 More sharing options...
justsomeguy Posted April 20, 2006 Share Posted April 20, 2006 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 More sharing options...
aspnetguy Posted April 20, 2006 Share Posted April 20, 2006 Apparently now the 'M' is middleware, and the 'P' is postgres. I thought it was Linux/Apache/MySQL/PHP.I have always seen it as Linux/Apache/MySQL/PHP lol Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now