Persistant data storage
by Jason Yarnell · in Technical Issues · 04/06/2006 (11:09 am) · 3 replies
Hello all,
For our upcoming game I want to have a persistent world. I remember from my T1 Mod days that my roommate had to keep track of everything in a .cs flat file. It worked, but has always seemed "fragile" and slow to me.
Have any of you had experience with utilizing a database with Torque? I'm on a very low budget (i.e. free is really, really good) so I was targeting MySQL as a database for it, but I am not sure if it will work on our Windows Server (none of us have Linux experience).
So, to summarize:
Are there any inherent difficulties with Torque interfacing with a database?
Will MySQL be a good choice for this?
Are there other database tools that are free or near free that would work if MySQL isn't possible?
For our upcoming game I want to have a persistent world. I remember from my T1 Mod days that my roommate had to keep track of everything in a .cs flat file. It worked, but has always seemed "fragile" and slow to me.
Have any of you had experience with utilizing a database with Torque? I'm on a very low budget (i.e. free is really, really good) so I was targeting MySQL as a database for it, but I am not sure if it will work on our Windows Server (none of us have Linux experience).
So, to summarize:
Are there any inherent difficulties with Torque interfacing with a database?
Will MySQL be a good choice for this?
Are there other database tools that are free or near free that would work if MySQL isn't possible?
About the author
#2
04/06/2006 (11:41 am)
Thanks for the response! 
#3
1) no, appears to be pretty straight forward and there are already some resources provided that do all this work for you :)
2)sure will work fine
3)there are others like PostgreSQL but general for small applications MySQL is fine.
As for tools there is a free version of Toad(i know for oracle, might have a free one for mysql as well).
04/06/2006 (2:54 pm)
Hit the resource section of this site there are already examples of torque integration with odbc and with mysql I believe.1) no, appears to be pretty straight forward and there are already some resources provided that do all this work for you :)
2)sure will work fine
3)there are others like PostgreSQL but general for small applications MySQL is fine.
As for tools there is a free version of Toad(i know for oracle, might have a free one for mysql as well).
Torque Owner Thomas \"Man of Ice\" Lund
2) Yes
3) Depends on your needs. If you dont need a "real" database engine, then look at some of the low end solutions. SQLite is such a beast.