SQLite as backend

[prusnak]

It would be amazing if moksha supported SQLite as backend for smaller instances.

If this is out of scope, feel free to close.

[ngutech21]

Thanks for the suggestion. There is already a trait for abstracting the database: https://github.com/ngutech21/moksha/blob/master/moksha-mint/src/database/mod.rs that is based on sqlx (https://github.com/launchbadge/sqlx) Since sqlx supports sqlite I think we could add this as a second option. Most of the queries should be very similar and could be copied over to the sqlx implementation of the Database trait.

But what would be the motivation using sqlite instead of postgres. I am providing a docker-compose file and helm charts for running it in k8s. So this should be fairly simple to setup. The only usecase I can think of for not using postgres would be integrating moksha-mint somewhere, like in a lightning-node where you it would be difficult to add a standalone db.