File IO Overwrites Entire DB Every Time

[JimTheCactus]

Along that same line of thought I need to improve his current mode of saving data. Right now any time you do anything that changes his save data he writes the whole database to the file. This is both bad for Chachamaru’s SSD and for Gummy’s speed. I’m tempted to re-implement this feature as a journaling system and then simply have him reconcile his journal when he does a full load.

[JimTheCactus]

Strictly speaking, if this was accessed more often it'd be a critical issue. In practice, however, gummy writes to this database only a few times a day, tops, because of usage patterns. This probably isn't worth the time to implement as it's a pretty significant change in architecture.

[JimTheCactus]

Rather than trying to roll my own on this, I probably should switch to PERL DBi and MySQL. It's not my favorite solution, but it will scale nicely.