SQLite for self-hosting

Having an option to use SQLite for self-hosting could simplify the setup and maintaining process.

On the other hand, having to implement/test the backend for both Postgres and SQLite will be error-prone and could slow down development.

Any ideas?