From: Jesper Olsen <Jesper@...>
Date: 2003-11-21T16:58:43+09:00
Subject: Re: MySql vs PostgreSQL

Thanks to all who replied to this thread.

Ruby DBI looks sweet, but the version number (0.0.21) has scared me off so
far :-)

I think I will try it now though - then it should be easy to compare
things in practice...

Cheers
Jesper


Samuel Kvarnbrink said:
> 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