Essentially, PostgreSQL and MySQL are built for different tasks. MySQL is best suited for simple Web queries for dynamic Web sites. It is ideal to being the database underlying simple Web sites, as shown by its success in the LAMP stack (Linux, Apache, MySQL, PHP). PostgreSQL is designed for more complicated missions like those traditionally serviced by the enterprise databases. Those scenarios leverage its advanced features like a rich transaction model with triggers, stored procedures, and views. It is also ideal for driving Java Enterprise Edition (AKA J2EE) Web sites that use Enterprise Java Beans.