Oke So I have the following problem. I want to make a plugin, But I totally screwed up the design to patch it back to SQL. So my question is what like you server owners/plugin devs the most? So I can know if I just reset my design and start over .
It really depends on the amount and what kind of data that is stored. If you have a lot of data that needs to be stored than I prefer an actual database, but if it is small amount of data, then sqlite/json files work fine.
It also depends if you expect that data to be editable outside of the game. If it needs to be editable, then going for something human readable like json is advised.
But why go through all this trouble when it’s just caused by the database server not being able to do its one job?
H2DB can run in both client/server, file-backed, or in-memory modes. It’s not perfect by any means, but you could use it as a test backend for a ‘quick’ mode while your CI tests both H2 and the proper engine.