Better SQL ????

m1ke · 12-13-2001, 03:05 AM

I Would like to know who SQL is better MySql or PostqreSql?

Quote:

One OS to Rule them all, One OS to find them, One Os to bring them All and in the Darkness bind them , In the land of Micro$oft where the shadows lie

carmeng · 12-13-2001, 03:35 AM

I don't know PostqreSql. In fact I've never heard the name before. But what would you like to do with it? I can recommend Interbase. It's free and was awarded 2nd place (after Oracle) for the best database.

m1ke · 12-13-2001, 04:15 AM

Sorry the name of the second SQL is PostgrelSql or something like that (I haven't the name in front of me).
Please if anyone has seen any of the above, I would appriciate his(her) opinion about them

Dave Campbell · 12-13-2001, 05:54 AM

Postgress is becoming more prevelant since Redhat adopted it as it's DB of choice however it's still not as widely used as Mysql:

Mysql is certainly not as powerful or feature rich as Postgress however it's easier to get support

To sumise:

Postgress: Better feature, more scalable- but not widely adopted
Mysql: Not truly scalable, few features - but widely adopted:

Both are excellent (free) products but if you want a bit more punch and will pay sybase is the way to go (and alot less expensive than oracle)

theFuzzyOne · 12-13-2001, 08:14 PM

i agree... we use postgresql and it was easy to install and setup. integration to our website with php was easy too.

jeremy · 12-13-2001, 10:26 PM

I would like to reiterate what was already said. Both are VERY good. As you may know this site uses MySQL.

PostgreSQL is mostly SQL92 compliant. It has views, is ACID compliant and has triggers. It is VERY fast on selects, but because of the way it indexes is a little slower on INSERTS. It seems to be a little more resource intense and is a little harder to learn.

MySQL is just now starting to support things like transactions (You need a special table type - InnoDB) but is much easier to learn/install/tweak in my opinion. It is super fast but will not scale as well.

So really, as in most cases, neither are better - they both have their strengths and weaknesses.

--jeremy

m1ke · 12-14-2001, 05:51 AM

Thanks guys for the infos you gave me

Bert · 12-14-2001, 09:32 AM

I've found that unfortunately, the backend listener in postgres is easily broken!

Postgres lasted about 4 days of intensive use before the backend started complaining, shutting down mid-request and requiring the postmaster to be restarted before every use.

Rebuilding doesn't work either, so I'm going to try MySQL next.
These things are set to test us.