Make backend storage a database

[aidanhorton]

This should probably be investigated a little bit before we commit to doing this - as if we move to SQLite, I'm fairly sure that only supports local repositories, so we may struggle to make that cloud-based or synced in future - therefore we should probably investigate what technologies should be used, and decide if we are going to attempt networking in future - as if we are not going to attempt that, either SQLite, or the current storage system would work fine!

[sebheron]

Approved. This would be one of the main things I'd want to get done this release, I struggle considerably with databases, I've got a module on it next term but for now your guidance would be perf 👍 .

[sebheron]

How much work d'you think this'd be? I was just weighing up things we could move to the next release and I know I said "This would be one of the main things I'd want to get done this release" 😆, but it doesn't really change much on the front-end and we could always do it in a future release. So unless you're working on it atm, I'm going to move it out of the release for now.

[aidanhorton]

Yeah sounds good - we can always add backwards compatibility relatively easily, and it seems really stable how it is at the moment so happy for this to be postponed!