Jump to content

[SOLVED] MYSQL Comparison


phrozenflame

Recommended Posts

I finally delved into the world of databasing, as always I start comparing what is available and I run across this.  Again, I am obsessed with standards compliant, I believe compliant on anything related to web design that can follow some sort of standard, I try to follow.  About mysql, I do some searches and I find this.
[a href=\"http://www.geocities.com/mailsoftware42/db/\" target=\"_blank\"]http://www.geocities.com/mailsoftware42/db/[/a]
now keep in mind it only compares open source, so it doesn't do the other databases.
But this is what I have a problem with I want advice on.
I don't like MaxDB, Firebird,  Ingres
I just don't like the way they look, but on Mysql, and Postgresql, I had a few problems here I wanted advice on
it seems to be a throwdown, there is one thing I am confused about I will get to that, but when I look through it I see.
Mysql supports more platforms
Mysql has a possibility of High speed, while postgresql doesn't
Mysql seems to have a higher ability for stability
mysql security features seem to be higher
Mysql has more programming interfaces
more storage engines
Load balancing
The thing that turned me off to mysql and hte main thing bothering me is the
SQL STANDARDS COMPLIANCE
The post gre sql is higher on that that mysql.  Isn't that a bad thing, or compared does that mean nothing, I am really confuseda bout this, should I sacrifice some compliancy, for the benefit of extra functionality.
Edit- also would MySql be acid compliant.
Link to comment
https://forums.phpfreaks.com/topic/32252-solved-mysql-comparison/
Share on other sites

Yes mysql has some features that stray from standard SQL, but so do allot of other databases. Postgres IMO is a better DB, but thats just my opinion and mysql is allot better now since V5.

[quote]should I sacrifice some compliancy, for the benefit of extra functionality[/quote]

Up to you. LIMIT is a pretty nice feature and is not part of SQL.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.