View previous topic :: View next topic |
Author |
Message |
Lady Z
Joined: 13 Sep 2008 Posts: 7
|
Posted: Sat Sep 13, 2008 23:43 Post subject: Which one should I use MySQL or SQLite ? |
|
|
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 |
|
Back to top |
|
|
TroveLord
Joined: 22 Nov 2006 Posts: 136 Location: Italy
|
Posted: Sun Sep 14, 2008 11:47 Post subject: |
|
|
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. |
|
Back to top |
|
|
Lady Z
Joined: 13 Sep 2008 Posts: 7
|
Posted: Sun Sep 14, 2008 16:25 Post subject: |
|
|
Thanks!!
Kathy |
|
Back to top |
|
|
Gryphyn
Joined: 20 Jan 2005 Posts: 431
|
Posted: Mon Sep 15, 2008 0:28 Post subject: |
|
|
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) |
|
Back to top |
|
|
Fireboar
Joined: 17 Feb 2008 Posts: 323
|
Posted: Fri Sep 19, 2008 16:39 Post subject: |
|
|
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. |
|
Back to top |
|
|
|