[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Getting started with Postgres or MySQL



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/31/07 12:29, Danesh Daroui wrote:
> David Baron wrote:
[snip]
> MySQL is definitely best choice. If you have not still installed
> latest version of MySQL do it as following:

Well, if you *insist* on starting a war, so be it.

MySQL is a toy piece of garbage that lets you insert corrupt data
without so much as a peep.  Every other RDBMS known to man rejects
out-of-range data.  BUT, you say, MySQL5 allows you to set
STRICT_TRANS_TABLES and STRICT_ALL_TABLES.  Sure, but they can be
disabled on a per-process basis, which *still* allows you to insert
bad data.
http://dev.mysql.com/doc/refman/5.0/en/constraint-invalid-data.html


PostgreSQL *might* be a bit harder to set up, but I doubt it.
Reading the docs and using the CLI, it's always been easy for me to
set things up.

$ su postfix
$ initdb --username=$THE_OWNER --pgdata=$TARGET_DIR
$ exit
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFwOVUS9HxQb37XmcRAu1tAJ0XhMNDQIK9X+9TKAwx3OjorDmH9QCfep8l
vUFK8sGIreIJdQhxRQzThto=
=Auhn
-----END PGP SIGNATURE-----



Reply to: