Hacker News new | ask | show | jobs
by flohofwoe 732 days ago
We actually used SQLite in a couple of singleplayer RPGs (the Drakensang games).

The initial world state was baked into tables in an SQLite database file, and savegames were just mutated SQLite files (we kept a record of created, mutated and deleted database rows, and periodically flushed those changes into SQLite).

It worked well, but was overkill because we didn't actually make use of any advanced SQL features (just simple search over an object-id column). It would have been easier to cut SQL out of the loop and just write a simple table-based persistency system.