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

Re: [school-discuss] EduML/EML/ and others



> and he uses standard, free software (Perl, php, html, mysql).

I used to use MySQL lots.  I have since realized that
postgresql is frequently a better choice.

It has ACID (see http://OpenACS.org/why-not-mysql.html for
a good explanation for this).

Referential integrity checking (value in column n of a row
must be the primary key of another table or the entry is
rejected), subselects, views, triggers, internal functions
in numerous languages.  Lots of features it has greatly
simplify things for me and cause a lot less work then using
MySQL.  When I was learning SQL I had no clue why these
features really mattered, just minor inconveniences...
I've changed my mind since.  The O'Reilly book on it and one
other is available on the web to boot, as well as some half
decent documentation.

The postgres people also spend their time developing the
software, and it gets better and faster with every release.
I have trouble believing the MySQL people can possibly have
the time to work on development, they are so busy with
lawsuits...

(MySQL may have some of these in recent releases as well.)

Just my experiences, perhaps it doesn't matter to you.

-- 
---------------|
Daniel Dent    |
ddent@vc.bc.ca |
---------------|

char number_of_bugs; // *No-one* needs more than 256 bugs. Don't be silly.