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


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx



Relevant Pages

  • Re: lost mysql root password
    ... On Friday 03 March 2006 02:20 pm, Matt Price wrote: ... Now I'm back to configuring some programs that use mysql, ... | hash 1 ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: [PHP] php cli and mysql
    ... James Tu wrote: ... Why is the CLI looking for it at /var/myslq/mysql.sock? ... Do I change the mysql settings so that mysql.sock is at ... To unsubscribe, visit: http://www.php.net/unsub.php ...
    (php.general)
  • Re: Getting started with Postgres or MySQL
    ... statement has begun executing. ... MySQL with the MyISAM data store is *exactly* what you describe. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • RE: File not found error
    ... after downloading, issuing a mv or rm command does not ... error: File not found by glob: MySql* ... Check out the new Yahoo! ... unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)
  • Re: SQL Questions (MySQL or PostgreSQL?)
    ... just rounds up what anyone would tell about it. ... >> i would like to suggest PostgreSQL if your objective is learning SQL. ... > What is the difference between PostgreSQL and MySQL? ... To unsubscribe, ...
    (freebsd-questions)