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.
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.
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.
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.
FWIW, RubyForge runs on PostgreSQL, and I’ve been quite pleased with its
performance so far…
Yours,
Tom
···
On Thu, 2003-11-20 at 07:05, Jesper Olsen wrote:
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.
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:
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.
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:
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.
