Cross platform database
by Colossai Studios · in Torque Game Engine · 03/14/2005 (1:43 am) · 2 replies
I'm porting a game from the Jupiter engine to Torque. The Jupiter version is windows only, and it use a Access database accessed through ADO. Since Torque is cross platform, I'd like to make use of that.
I'm presuming ADO doesn't work on Mac and Linux (correct?). So which database format should be used and which access techniques?
thanks
I'm presuming ADO doesn't work on Mac and Linux (correct?). So which database format should be used and which access techniques?
thanks
About the author
#2
If you are using the DB to store game state information, or such and are working on a single player game or small multiplayer game, SQLite is by far your best choice, because you can integrate that right into the engine fairly easily and it provides very little overhead.
If you need a massive transactional (means more than one operation at a time can happen) database, you may wish to integrate the mysql drivers into your torque project.
If you want to create a simple login server, you can use a php script and httpobjects alongside a mysql database, so the game queries the webpage, which talks to the mysql database, which authenticates the user and passes the information back up along the chain to the game.
Like I said it all depends on what you want to do, me personally I'm sticking with SQLite integration, for 99% of my projects it's not onyl sufficient, it's a perfect fit.
03/14/2005 (6:39 am)
That all depends on what you want to do, personally for the most generic support, I would simply incorporate ODBC drivers into your Torque Project and then the database type becomes essentially irrelevant.If you are using the DB to store game state information, or such and are working on a single player game or small multiplayer game, SQLite is by far your best choice, because you can integrate that right into the engine fairly easily and it provides very little overhead.
If you need a massive transactional (means more than one operation at a time can happen) database, you may wish to integrate the mysql drivers into your torque project.
If you want to create a simple login server, you can use a php script and httpobjects alongside a mysql database, so the game queries the webpage, which talks to the mysql database, which authenticates the user and passes the information back up along the chain to the game.
Like I said it all depends on what you want to do, me personally I'm sticking with SQLite integration, for 99% of my projects it's not onyl sufficient, it's a perfect fit.
Associate Melv May
There's probably lots more information on the forums as well.
- Melv.