Skip to content

v0.3.0

Choose a tag to compare

@jordanful jordanful released this 05 Feb 10:45
· 15 commits to master since this release

Switch from PostgreSQL to SQLite

This release simplifies deployment by removing the PostgreSQL dependency entirely. Prisma 6's native SQLite Json field support makes this possible.

Changes

  • Prisma 5 → 6: Upgraded to Prisma 6.2+ for native SQLite Json field support
  • SQLite provider: Switched database from PostgreSQL to SQLite (file:/app/data/chapter.db)
  • Simplified Docker: Removed postgres service — deployment is now 5 services instead of 6
  • Smaller image: Removed OpenSSL dependency from server Docker image
  • Bug workaround: Explicit tags: [] on UserBook creation to avoid Prisma #26571

Migration

Existing PostgreSQL data is not automatically migrated. For fresh installs, docker compose up -d works out of the box. The entrypoint uses prisma db push to create the SQLite schema on first run.

Breaking Changes

  • DATABASE_URL now expects a SQLite connection string (file:./path/to/db) instead of a PostgreSQL URL
  • The postgres Docker service has been removed from both production and development compose files