21 October, 2006

miscellany: some more brainstorming on the various dbs idea

So either I can try to dl SQLite on the server, or I can do some goony crap like have every insert/create/set query be stored in a log file. Have the log file on the game client end translated into MySQL compatible queries. Have the log file on the web server end translated into SQLite compatible queries. Compare the remote and local logs, grab queries if necessary, and then process on whichever machine needs to be updated.

Or, have any db queries be made locally on the game client, then open a connection to a remote MySQL database, and run queries there, too. At least the website db will be current with the local SQLite db. Then only the local db will need to be synchronized.

Either way, will need to make sure queries will run on either SQLite or MySQL. It's reading time again.

0 Comments:

Post a Comment

<< Home