SQLite support

[joschi]

Given the single user nature of Hollo, it would be great if it could use SQLite for storing its data instead of PostgreSQL.

Together with storing assets in the local filesystem instead of S3 (see #10 / #59), it would allow running Hollo without any other supporting daemons such as MinIO and PostgreSQL with very little hardware resources.

[FartherQuant]

For SQLite issues, you can try modifying the configuration of the drizzle.config.ts and the declarations. I have successfully migrated the database to pglite.

[dahlia]

Hmm… PGlite seems a viable alternative to SQLite.