logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Which one should I use MySQL or SQLite ?

 
Post new topic   Reply to topic    nwnx.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
Lady Z



Joined: 13 Sep 2008
Posts: 7

PostPosted: Sat Sep 13, 2008 23:43    Post subject: Which one should I use MySQL or SQLite ? Reply with quote

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
View user's profile Send private message
TroveLord



Joined: 22 Nov 2006
Posts: 136
Location: Italy

PostPosted: Sun Sep 14, 2008 11:47    Post subject: Reply with quote

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
View user's profile Send private message
Lady Z



Joined: 13 Sep 2008
Posts: 7

PostPosted: Sun Sep 14, 2008 16:25    Post subject: Reply with quote

Thanks!!

Kathy
Back to top
View user's profile Send private message
Gryphyn



Joined: 20 Jan 2005
Posts: 431

PostPosted: Mon Sep 15, 2008 0:28    Post subject: Reply with quote

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
View user's profile Send private message
Fireboar



Joined: 17 Feb 2008
Posts: 323

PostPosted: Fri Sep 19, 2008 16:39    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> General Discussion All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group