Re: free database for java

Mr. X. wrote on 12.03.2008 19:29:
Thanks ...
Where can I find more opinions, that Postgres is the best free db ?
Is there any compare-table of free DBs, that list all of the DBs' cons. & pros ?

Simply compare
http://sql-info.de/mysql/gotchas.html
to
http://sql-info.de/postgresql/postgres-gotchas.html

although I have to admit that a lot of the MySQL gotchas aren't valid any more.
But there are still too many nasty habits that I personally feel should not be in a relational database system.

Check out this thread on the PG mailing list:
http://www.nabble.com/postgre-vs-MySQL-td15976517.html

The PG people aren't too religous about this topic and they have a fair judgement of MySQL (naturally they will think PG to be better than MySQL, but still they aren't bashing MySQL)

Note that probably more people think that MySQL is better than Postgres, but then more people think Windows is better than Linux as well :)

.

Relevant Pages

  • Re: DB newbie needs suggestions for bsd-based {db + frontend} ports
    ... It's a matter of documentation. ... >>MySQL PHP) in mind, so most documentation you'll find regarding PHP and ... >>something like Postgres, which really is overkill for your situation anyway. ... > I run both MySQL and PostgreSQL databases (PG for my core business stuff, ...
    (comp.unix.bsd.freebsd.misc)
  • Re: PostgreSQL or MySQL ?
    ... PostgreSQL or MySQL ... I have often been writing queries in Postgres that I ... any deviations from the SQL standards. ... in several languages - all in the standard configuration. ...
    (comp.databases)
  • Re: [PHP] Very Large text file parsing
    ... Both of these support importing csv files (use \copy as Martin mentioned for postgres). ... Mysql has this: http://dev.mysql.com/doc/refman/4.1/en/load-data.html ... If you're supporting more than those two, can't really say whether others support this type of feature:) ... As for MySQL, if the table that you are inserting to has any indexes at all, then each time your insert/update completes MySQL will re-index the table. ...
    (php.general)
  • Re: PostgreSQL or MySQL ?
    ... PostgreSQL or MySQL ... I have often been writing queries in Postgres that I ... The documentation for MySQL covers all versions at once. ... Postgres gives you meaningful error messages most of the time. ...
    (comp.databases)
  • RE: [SLE] Relational Databases with SuSE 9.1
    ... >> Do you need a degree in data management to use Postgres of MySQL? ... > a decent form that will do but i can find nowt in the Linux world to ... I always considered DBase a tool for PC's when there were not other databases really availble. ... I've had relatively little trouble with MySQL, PostgreSQL, DB2 and Oracle and the front end tools that support them. ...
    (SuSE)