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 Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/ 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). Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008007 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. Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008421 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. Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008428 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. Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008437 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. Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008573 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? Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008714 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. Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008721 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. Link to comment https://forums.phpfreaks.com/topic/191177-e-commerce-shopping-cart/#findComment-1008882 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.