Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow SQLite database #49

Open
alensiljak opened this issue Feb 12, 2025 · 1 comment
Open

Allow SQLite database #49

alensiljak opened this issue Feb 12, 2025 · 1 comment

Comments

@alensiljak
Copy link
Contributor

Just a question if it would be possible to support SQLite instead of PostgreSQL. For individual installations and development this may simplify things.
Is there any particular reason to use Postgres?
Are there any difficulties foreseen in using SQLite?

@pu-re
Copy link
Contributor

pu-re commented Feb 12, 2025

SQLite would work fine too and might be more convenient to use. However, I'm more familiar with PostgreSQL, so I used that in the base version.

HendricksJudy added a commit to HendricksJudy/open-health that referenced this issue Feb 13, 2025
Related to OpenHealthForAll#49

Add support for SQLite as an alternative to PostgreSQL.

* **docker-compose.yaml**
  - Add a new service for SQLite.
  - Update the `app` service to use SQLite if specified.
  - Add a volume for SQLite data.

* **prisma/schema.prisma**
  - Update the `datasource db` block to support both PostgreSQL and SQLite.

* **src/lib/prisma.ts**
  - Update the `createPrismaClient` function to support both PostgreSQL and SQLite.

* **.env.example**
  - Add an example `DATABASE_URL` for SQLite.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants