I wonder how well SQLite would just handle this whole thing.
Seriously.
Compile a bunch of prepared statements at load time to take the parsing and execution planning out of it, keep it all in memory... On the surface it seems like it would work.
And of course, saving the entire game state would be as simple as just flushing the DB to disk.
Seriously.
Compile a bunch of prepared statements at load time to take the parsing and execution planning out of it, keep it all in memory... On the surface it seems like it would work.
And of course, saving the entire game state would be as simple as just flushing the DB to disk.