How much is blinko dependent on PostgreSQL? (hoping to use SQLite)

[wsw70]

I see that prisma is used as the database framework, which could allow the use of SQLite (for a home installation), except if there are specific PostgreSQL usage.

Is this the case?

[dosubot[bot]]

blinko is tightly coupled to PostgreSQL. The Prisma schema explicitly sets the provider to PostgreSQL and uses Postgres-specific types like @db.Timestamptz(6) and @db.VarChar, which are not supported by SQLite. The migration SQL files also use PostgreSQL-only features such as SERIAL for auto-incrementing IDs and TIMESTAMPTZ for timestamps with time zone, making the schema and migrations incompatible with SQLite out of the box. Switching to SQLite would require significant manual changes to the schema and migration files to remove these Postgres-specific features and adapt to SQLite's capabilities. There are no code-level raw queries that block SQLite, but the schema and migration layer is strictly Postgres-only right now.
See schema.prisma
See migration example

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}