Game Development Community

SqLite issues

by Ted Lilljegren · in Technical Issues · 02/18/2008 (1:29 pm) · 4 replies

Currently, i am using sqLite, but i have some worries using this:

sqLite is a object on the server, meaning that it cant be accessed from the master server(??), which is bad, since i want my data to be stored in a manner like battle.net on say diablo(i do not know how they do it, but i guess they store the data on the master server?). Is this correct?

mySql has exactly the same syntax? And has the advantage of being able to be interacted with through a web interface?

sqLite comes with a dll library, does that mean that windows only can host a server using sqLite?

Thanks for your time

#1
02/22/2008 (10:43 am)
I know for a fact that SQLite can host a server on Linux. I didn't set it up personally so I don't know the details but it's possible.
#2
02/22/2008 (12:03 pm)
Thanks, that clears one of my concerns. But what about data being stored on the master server?
#3
02/23/2008 (4:05 pm)
Http://www.garagegames.com/index.php?sec=mg&mod=resource&page=view&qid=4085

That looks pretty cool, but does not that mean that for each time you want to update the persistent data, you are gonna have to call said webserver, and update it there? Would that not be really slow?
#4
02/25/2008 (4:36 pm)
I suppose it depends on how much data you're transmitting. Write a web page that reads the database and builds a web page, it should take about that long to transmit the data over the internet.