— Warren S. firstname.lastname@example.org wrote:
Is there any reason to avoid using postgresql for
small web apps?
None at all, IMO.
That is, is it’s
overhead so large that the lighter MySQL will work
substantially better for small apps on
I find PostgreSQL to be quite nimble. It’s my MySQL
process that seems to inexplicably use CPU cycles,
even when it’s not busy.
Or are they very similar in
performance and configuration?
I find PostgreSQL performs as well as, and probably
better. I also find it easier to configure and even
compile from source. PostgreSQL is even easier to
admin, since auto-vacuuming has been integrated into
I’ve used MySQL but postgresql has its appeals and
I’m wondering if I need to keep MySQL
around at all.
Well, unfortunately there are many apps out there that
are coded only for MySQL (like Wordpress)…
On the other hand, Postgresql claims that “Windows
does not support Unicode” and you can’t
have Unicode fields on postgresql on Windows. This
is a big mistake. See:
What do you mean “a big mistake”? By Microsoft? Or
Rails mailing list
Yahoo! FareChase: Search multiple travel sites in one click.