Which one should I use MySQL or SQLite ?

[Lady Z]

I am redoing and upgrading my stand alone server which currently uses NWNX2 and would like to know which is the better option:

MySQL or SQLite

Thanks,

Lady Z

[TroveLord]

It's a matter of taste, if you're in a early development stage I'd recommend to try both. I personally tried SQLite for a while and then moved to MySQL, mostly because I use the Mowes webserver which includes PHP, MySQL and Apache, so you can build an admin console from there if you're skilled with PHP.

[Lady Z]

Thanks!!

Kathy

[Gryphyn]

SQLServer is also available (for NWNX2)
You'll find this less tiresome constructing, and quoting, SQL statements.

Cheers
Gryphyn

PS. SQLServer Express editions are free (2005 and 2008 both work)

[Fireboar]

If you're using Windows, or only need basic SQL functions, use SQLite. If you're using Linux, or have a very big database or one that's complicated and may need altering later, use MySQL, which can ALTER tables and can handle much more data.