Re: [Bug-gnupedia] Architecture Questions

[Hook]

> Tom Chance <address@hidden> writes:
>
> > We just know its advantages and general workings, not its minutae
> > setup and code, as yet lol.  So if anyone here knows sufficient
> > Perl, DBI and CGI stuff...
>
> What exactly are the advantages of using a MySQL database? I'm not
> extremely familiar with it, but I don't see why human readable files
> (in XML or SGML or whatever) aren't a Good Thing.

For anything other than small collections of files, it's almost always
faster to find information using a properly constructed database.  Human
readable files holding the content are indeed A Good Thing (tm), however,
the meta information (author, title, subject etc) are probably better stored
in a database for ease of access, ease of updating, simple multi-user
access, searching etc.

MySQL is (1) free, (2) a reasonably good database, (3) damned fast and (4)
limited in some important ways.  As a start, it's got a lot going for it.

Paul