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:
>
> [url]http://www.postgresql.jp/interfaces/ruby/reference.html[/url]
>
> 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
>
>
> --
> [url]http://JesperOlsen.Net[/url]
>
>

--
[url]http://JesperOlsen.Net[/url]

[gabriele renzi]

il Thu, 20 Nov 2003 21:05:25 +0900, "Jesper Olsen"
<Jesper@JesperOlsen.Net> 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]

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.

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:

> 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:
>>
>> [url]http://www.postgresql.jp/interfaces/ruby/reference.html[/url]
>>
>> 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
>>
>>
>> --
>> [url]http://JesperOlsen.Net[/url]
>>
>>

>
>
> --
> [url]http://JesperOlsen.Net[/url]
>

[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:

> 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:
>>>
>>> [url]http://www.postgresql.jp/interfaces/ruby/reference.html[/url]
>>>
>>> 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
>>>
>>>

--
[url]http://JesperOlsen.Net[/url]