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.

[TheNoim]

Or libsql. The awesome thing about libsql would be https://github.com/tursodatabase/libsql/blob/main/docs/USER_GUIDE.md

[oelna]

I very much support this. Providing native SQLite support would make it so that many more people could host their own instances on cheaper or pre-existing hosting plans. I also love the idea of easy backups of the database and compatibility with many DB tools and libraries.

[TheNoim]

I very much support this. Providing native SQLite support would make it so that many more people could host their own instances on cheaper or pre-existing hosting plans. I also love the idea of easy backups of the database and compatibility with many DB tools and libraries.

One road blocker at the moment probably is drizzle-team/drizzle-orm#2469