From: Samuel Kvarnbrink Date: 2003-11-21T04:42:18+09:00 Subject: Re: MySql vs PostgreSQL Both MySQL and PostgreSQL are very fast, in general. In my experience, however, PostgreSQL performs better on more complex queries and under heavy load. PostgreSQL is also extremely robust and secure, but recently MySQL has been catching up a lot. The main reason why I use PostgreSQL, however, is not the performance (it's more like a bonus to me) but the SQL implementation. For example, PostgreSQL has views, sequences, schemas, mvcc (a.k.a. "better-than-row-level locking") and a sophisticated rule system, which all are very useful features. Also, you can use Ruby as a procedural language inside the DB if you install PL/Ruby - very cool :) Which database engine that is best for you really depends on your needs. If you only use your DB for trivial tasks, MySQL could very well be the best choice for you. However, if you want a more powerful DB, I can really recommend PostgreSQL. I'm still kind of amazed that you can get such a powerful tool for free :) cheers //samuel 2003-11-20 kl. 13.05 skrev Jesper Olsen: > sorry, forgot the subject! > > Jesper Olsen said: >> I am currently using ruby's mysql extention. >> Recently PostgreSql has become available to me also. >> >> PostgreSql is not part of the ruby distribution, but I notice that >> there is an extention available for it: >> >> http://www.postgresql.jp/interfaces/ruby/reference.html >> >> I think the Ruby API's are more or less the same? >> >> Maybe this not strictly a ruby question, but can anyone here comment >> on >> how MySQL and PostgreSQL compare? >> Is PostgreSQL in any way better than MySql - ie. faster or more >> stable. >> >> Cheers >> Jesper >> >> >> -- >> http://JesperOlsen.Net >> >> > > > -- > http://JesperOlsen.Net >