MySql vs PostgreSQL

[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

 

[gabriele renzi]

il Thu, 20 Nov 2003 21:05:25 +0900, "Jesper Olsen"
<[email protected]> ha scritto::

I think the point is that Pg is a bigger scale server.
MySQL lacks many SQL features, sometimes by choice, and should be
faster.
Pg is a full featured ordbms. Look at both and decide which one may
fit your need.

 

[Tom Copeland]

FWIW, RubyForge runs on PostgreSQL, and I've been quite pleased with its
performance so far...

Yours,

Tom

 

[Samuel Kvarnbrink]

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:

 

[Jesper Olsen]

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: