RE: [PHP-DB] eCommerce with PHP and MySQL

> 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.)? I haven't found MySQL's lack of transactions to make ecomm impossible. Afterall, there are table-level locks. This might seem like a big performance hit, but in reality, you're only needing to lock the invoice table small part of the time. FreeTrade, an ecomm toolkit I developed, uses MySQL and is the engine behind at least one high-traffic site, Restoration Hardware. <http://www.restorationhardware.com/>. If anyone wants to grab FreeTrade, it's got a BSD license: <http://www.working-dogs.com/freetrade/>. If I had to pick a feature that clients have asked for that MySQL doesn't do yet, it would be replication. I'm not convinced that RAID doesn't address the problem sufficiently, though. Leon