Setup one S3 bucket for storing the SQLite db

[alisomay]

I have worked with SQLite for simple dbs in prod. I think it worked really good!

There is this system which is easy to setup: https://litestream.io/ It replicates the .db file into a bucket and it is very painless. Eases the tests and also easier to work locally. Nice when you'd like to retrieve prod db and inspect etc.

I'd propose it for this project. Let me know your thoughts. @ozankasikci

[ozankasikci]

This seems interesting! I'm already eager to try 😋

Is there any example use that you can provide @alisomay ?

[alisomay]

Sure I can provide a PR, we just need a bucket and we can get going in no time. If the community does not like it we can easily convert it to postgres since we'll not be bothering with migrations initially.

[berkantsoytas]

First of all, it is a well-known fact that SQLite databases are lightweight, portable, and easy to use. Backing up our database using an S3 bucket will indeed make things easier for our tests and local development work. Additionally, it provides a practical method for inspecting and analyzing the live database. I completely agree with your proposal as I believe the target audience is suitable for this setup but still postgres says come to me a bit :)

[alisomay]

Currently blocked by

• 8