Better documentation on database systems? (sqlite VS postgre)

[Ezwen]

When setting up the bridge for the first time, I find it not easy to choose between sqlite and postgre for the database system to use. While the documentation only mentions postgre, one can discover in the example configuration that sqlite is also possible (even though postgre is the default in said file), which I think creates confusion.

I would find it useful to have even a short bit of text in the documentation about the two possibilities, and with some insights on how to pick one of the two, and even − if relevant − with a explicit statement on which one is "officially" recommended (whether because it is more efficient or because it is simply more maintainted/tested).

Thanks for your work! The bridge is really fantastic.

[sumnerevans]

At Beeper, we are running all of the bridges using SQLite via Litestream. Both postgres and sqlite are supported and should always work.