RE: [cgiapp] What's the best "free" DB for a web-based app?

On Tue, 29 Nov 2005 20:09:26 -0500, Josh Danziger wrote:

Hi Josh

> arbitrary SQL statements on the database a breeze. I've heard
> arguments that postgresql is a better database platform; the claim
> is that postgres is more functional and runs faster (I don't know
> how this changed with MySQL 5).

Ask N programmers, get N+M opinions.

In my, admittedly simplistic, testing, Postgres 8.0 under Windows is 5 .. 10
times slower (repeat, slower) than MySQL 4.1 on the same box. Of course, there's
always a later version, which is always allegedly faster, bettter, whatever...

So use GNU/Linux.

--
Cheers
Ron Savage, ron@xxxxxxxxxxxxx on 30/11/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company


.

Relevant Pages

  • Re: Effect of MySQL being acquired by Sun Micro
    ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... I didn't know SQL support was added that late. ...
    (comp.lang.php)
  • Re: Python, xml, databases, ...
    ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
    (comp.lang.python)
  • Re: Effect of MySQL being acquired by Sun Micro
    ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... By the time Postgres became PostgreSQL, mSQL already had a strong foothold ...
    (comp.lang.php)
  • Re: pro- foreign key propaganda?
    ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
    (comp.databases.theory)
  • Re: Looking for a database
    ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
    (Fedora)