search

oae / kaizoku

Self-hosted manga downloader
https://kaizoku.app
MIT License
578 stars 34 forks source link

Feature Suggestion: SQLite option instead of Postgres #13

Closed Kussie closed 2 years ago

Kussie commented 2 years ago

It would be great if we had the option to use SQLite instead of Postgres. Personally i dislike having to run a full featured RDBMS, makes it easier to backup individual projects and such as well.

oae commented 2 years ago

Prisma with SQLite doesn't support some data types that are being used. So I am not currently planning on adding support for it.

Kussie commented 2 years ago

Do you have an example out of curiosity? The Prisma docs don't make any mention of any such limitations that are currently being used? The only thing it doesn't support is JSON types, which according to the schema and migrations isn't being used anyway.

oae commented 2 years ago

It doesn't support array types

https://github.com/oae/kaizoku/blob/9da4606dcca47a800a4488780d052c74dcd153a2/prisma/schema.prisma#L48-L58

It also doesn't support transactions.

https://github.com/oae/kaizoku/blob/b150575b7f1d869bd214ee4be707b1dec892c046/src/server/queue/checkChapters.ts#L36-L50