sqlite database

[stephenjamieson]

I saw #344, would like to see something more lightweight like sqlite for small deployments.

[charb29]

@stephenjamieson Thanks for the feedback! You're absolutely right, SQLite can be a great fit for smaller deployments. Given that we're still in development and expect low traffic, it could definitely work as an optional backend.

That said, the goal of #344 is to introduce MySQL as the default for production use, since it offers better support for concurrency. I'm definitely open to supporting both MySQL and SQLite, possibly configurable with environment variables in the config file. This way users can choose based on their deployment needs.

Would you be interested in contributing or collaborating on a follow-up issue to add SQLite support? I think it would be a great addition.

[stephenjamieson]

I personally just wanted to get that idea out there because from my experience I see projects using SQLite tend to take off faster for the self-hosted crowd. I would be happy to contribute, however this field is not my strong suite.

[charb29]

That kind of feedback is very appreciated! Even just highlighting what you'd expect as a user helps shape the direction of the project, so you're already contributing in a very meaningful way.

I'll go ahead and create a follow-up issue to track SQLite support as an optional DB engine. If anything else comes in mind, feel free to drop a comment anytime!