On the subject of `which database', I am a big fan of MySQL. It's reliable,
fast, stable and simple (ish).
However, you have to really understand the implications of designing
database schema(s?) without referential integrity, without transactions,
without foreign keys, without subselects etc BEFORE you start designing
for MySQL. If you design a schema that would work with <insert typical
rdbms here> and expect it to work with MySQL, you *will* be disappointed.
MySQL shines and rocks if used properly, but don't use it as a hammer.
If you are a normal database head, or expect to be hiring normal database
heads of reasonable, typical sql competency, then at try out postgresql.
At the very least, you should be able to keep your SQL fairly vendor
neutral, at least for the first few months.
Just my two coppers.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!