Re: eCommerce with PHP and MySQL

Even though I love mySQL I cannot recommend it for an eCommerce solution. While mySQL is great in many respects, it has some major lacks. Worst of all is lack of transactions which means that an order, for instance, can be partially finished due to a breakdown. Other serious lacks are referential integrity and stored procedures which one may argue is not a problem if you do your software right the first time (even though lack of referential integrity and not being able to put a manaul procedure in a transaction is a dangerous combination). In terms of performance though, mySQL is great it is very fast and seem very reliable. I love PHP but if one is determined on running NT Servers, ASP should be considered. ASP has a superiour integration with MS Backoffice such as MS Transaction Server and MS SQL 7. I would put it this way: If costs and flexibility is the major issue (it is for me), I would go for PHP and mySQL (Oracle if only flexibility). If software costs is not a major issue and you are sure you want to lock yourself to a windows platform, ASP should really be considered. I Hope this helps Best regards / Med venlig hilsen Soeren Dalby Dalby Data email@dalbydata.dk www.dalbydata.dk ... Tom Carter wrote in message ... >Hi guys, > >Sorry if this is an old hat question, but I figured its best to speak to >those who know best ;o) > >We're planning to implement a series of eConmerce solutions using PHP with >a db backend. Initially our thoughts were to use MySQL as this is what we >have (successfully) used before for other (non eCommerce) projects. Are >there advantages to using other DB systems (extra features etc.)? > >Also, and I appreciate this is not really a PHP question so please humour >me, how easy (and how would one) is it to integrate automated credit >card/transaction proccessing with the PHP solution (obviosuly securely ;o) >) > >Thanks once again, > >Tom Carter >Web Programmer >roundcorners.com > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net >