phrozenflame Posted December 30, 2006 Share Posted December 30, 2006 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, IngresI just don't like the way they look, but on Mysql, and Postgresql, I had a few problems here I wanted advice onit 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 platformsMysql has a possibility of High speed, while postgresql doesn'tMysql seems to have a higher ability for stabilitymysql security features seem to be higherMysql has more programming interfacesmore storage enginesLoad balancingThe thing that turned me off to mysql and hte main thing bothering me is the SQL STANDARDS COMPLIANCEThe 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 More sharing options...
trq Posted December 30, 2006 Share Posted December 30, 2006 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. Link to comment https://forums.phpfreaks.com/topic/32252-solved-mysql-comparison/#findComment-149684 Share on other sites More sharing options...
phrozenflame Posted December 30, 2006 Author Share Posted December 30, 2006 Ok thanks :) Link to comment https://forums.phpfreaks.com/topic/32252-solved-mysql-comparison/#findComment-149685 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.