ded Posted February 6, 2010 Share Posted February 6, 2010 I am about to being coding my first e-commerce shopping cart. Should I be using MySQL or PostgreSQL? Which is actually better? I do all my sites using MySQL database. Should I be changing that idea as well? Regards, DED Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 6, 2010 Share Posted February 6, 2010 Which one is actually better in what? Assuming you mean performance, as far as I can tell they're really similar (if used properly). Quote Link to comment Share on other sites More sharing options...
bouba Posted February 7, 2010 Share Posted February 7, 2010 A database is just a data storage. Ideally you should design your application to work irrespective of the database in the back-end. You can achieve that by using PDO or if you wish app frameworks such as Zend or CodeIgniter or Yii. Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 A database is just a data storage. Ideally you should design your application to work irrespective of the database in the back-end. This isn't always the best approach. Using any kind of abstraction layer forces you to give up any DBMS specific features which might be beneficial. Also you can move some of the application logic to the database using triggers, stored procedures, events etc. In other words, when starting your work on an application decide it to be whether a DBMS independent, or to work with selected DBMS only but be optimised to its features. Quote Link to comment Share on other sites More sharing options...
ignace Posted February 7, 2010 Share Posted February 7, 2010 Plus PDO is not an abstraction layer rather a data-access layer which means it doesn't alter you SQL So your application to work irrespective of the database is not true. Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 7, 2010 Share Posted February 7, 2010 Plus PDO is not an abstraction layer rather a data-access layer which means it doesn't alter you SQL The assumption here is, that when coding with PDO, you use SQL that's compatible with all (or as many as possible) drivers. Quote Link to comment Share on other sites More sharing options...
ignace Posted February 8, 2010 Share Posted February 8, 2010 Is there actually a guide out there that lists all differences? Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 8, 2010 Share Posted February 8, 2010 You wush there was. Try to stick to ANSI SQL in the lowest version supported by all targeted engines. Quote Link to comment Share on other sites More sharing options...
ignace Posted February 8, 2010 Share Posted February 8, 2010 You wush there was. I sure do I thought I found one a while back but I forgot about it since I started using Zend_Db and Doctrine if I find it I'll post it. Quote Link to comment 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.