MySQL is great for small queries and small databases. It's quite a fast db engine that supports almost all of the Structured Query Language. It was originally designed to be quick, small, and flexible, which is exactly where it excels.
PostgreSQL is the descendant of Ingres, which was one of the original Relation Database Management Systems, way back. PostgreSQL is powerful, fast, robust, and extremely full featured. It supports a complete implementation of SQL. Most web-based apps will do fine MySQL, since most web-based apps are simply querying existing data sets, not creating or adding to them. I don't believe that MySQL has support for record locking (I may be wrong) and it definitely doesn't handle table joins or secondary indexing very well, and it doesn't support transactions at all (supposedly they were grafting support for transactions on, but it will be a graft, not native support!). PostgreSQL has all of this. Obviously though, you'll pay a price for more features, usually in terms of speed or other perfomance indicators. You should check out the MySQL and PostgreSQL FAQs. I know one of them points to a comparisson list between the two, and figure out which one suits your needs. HTH, ***************************************************************** To unsubscribe from this list, send mail to [EMAIL PROTECTED] with the text 'unsubscribe gnhlug' in the message body. *****************************************************************
