Ninjakreborn Posted May 1, 2006 Share Posted May 1, 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.[b]Edit- also would MySql be acid compliant.[/b] Quote Link to comment https://forums.phpfreaks.com/topic/8810-mysql-comparison/ Share on other sites More sharing options...
fenway Posted May 1, 2006 Share Posted May 1, 2006 Don't get too hung up on the standards; how often are you switching DBs? Besides, MySQL 5 has a "strict mode" which is quite, well, strict about standards adherence, and let's you decide how much you want. In general, MySQL's approach has been speed, and letting the DBA decide what to do with "border-line" data. As for ACID compliance, InnoDB is the way to go. Quote Link to comment https://forums.phpfreaks.com/topic/8810-mysql-comparison/#findComment-32370 Share on other sites More sharing options...
Ninjakreborn Posted May 1, 2006 Author Share Posted May 1, 2006 alright thanks. Quote Link to comment https://forums.phpfreaks.com/topic/8810-mysql-comparison/#findComment-32373 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.