jonm / SillyMUD

SillyMUD, a derivative of DikuMud
Other
8 stars 5 forks source link

RFC: migrate from file-based persistence to a database #110

Open jonm opened 1 year ago

jonm commented 1 year ago

It seems as though some of the open bugs (e.g. #59, and I definitely cleaned up some other formatting errors in my initial efforts to get things running again) come from improperly writing (editing?) the files with something that doesn't match the (implied) schema. I think moving to some form of database would help prevent these issues (and, to be honest, probably bring good things like transactional integrity and possibly better performance).

My current thinking is to gradually migrate some--or all?--file-based storage to SQLite. It is public domain software, so we should be license-compatible by using it. Since they are simple files, distributing the databases should be just as easy as distributing the existing files.

Thoughts? If I get sufficient time and motivation, I'll just do it, but I figured I'd gather some input. 😄