[Weak request] SQLite support

[aantron]

I'm working on a service where it would be beneficial to use SQLite for the database.

This is just a weak request/vote — I understand you may have other priorities.

[joseferben]

Thanks for the issue!

I assume you mean SQLite backends for the services, since you can use Sihl.Database.{query, transaction} to query SQLite. (I haven't tested it but https://github.com/paurkedal/ocaml-caqti supports it). We don't use Sihl with SQLite at the moment, but were considering doing that for testing. We could implement SQLite backends instead of in-memory ones like planned here https://github.com/oxidizing/sihl/issues/229, but it is not high prio.