starred/pocket-id-pocket-id-2
1
0
Fork 0
mirror of https://github.com/pocket-id/pocket-id.git synced 2025-12-11 07:32:57 +03:00
Code Issues 116 Packages Projects Releases 10 Wiki Activity

[PR #79] feat: add support for Postgres database provider #965

New Issue
Closed
opened 2025-10-09 17:00:40 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2025-10-09 17:00:40 +03:00
Owner
Copy Link

Original Pull Request: https://github.com/pocket-id/pocket-id/pull/79

State: closed
Merged: Yes

With this PR it is now possible to use Postgres instead of Sqlite as the database provider.

The following environment variables were added that allows the admin to configure the database provider:

Variable Default Value Description
DB_PROVIDER sqlite The database provider you want to use. Currently sqlite and postgres are supported.
SQLITE_DB_PATH data/pocket-id.db The path to the SQLite database. This gets ignored if you didn't set DB_PROVIDER to sqlite.
POSTGRES_CONNECTION_STRING - The connection string to your Postgres database. This gets ignored if you didn't set DB_PROVIDER to postgres. A connection string can look like this: postgresql://user:password@host:5432/pocket-id.

This PR can be tested with the stonith404/pocket-id:postgres-development Docker image.

**Original Pull Request:** https://github.com/pocket-id/pocket-id/pull/79 **State:** closed **Merged:** Yes --- With this PR it is now possible to use Postgres instead of Sqlite as the database provider. The following environment variables were added that allows the admin to configure the database provider: | Variable | Default Value | Description | | ---------------------- | ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `DB_PROVIDER` | `sqlite` | The database provider you want to use. Currently `sqlite` and `postgres` are supported. | | `SQLITE_DB_PATH` | `data/pocket-id.db` | The path to the SQLite database. This gets ignored if you didn't set `DB_PROVIDER` to `sqlite`. | | `POSTGRES_CONNECTION_STRING` | `-` | The connection string to your Postgres database. This gets ignored if you didn't set `DB_PROVIDER` to `postgres`. A connection string can look like this: `postgresql://user:password@host:5432/pocket-id`. | This PR can be tested with the `stonith404/pocket-id:postgres-development` Docker image.
OVERLORD added the pull-request label 2025-10-09 17:00:41 +03:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
breaking
bug
documentation
feature
needs more upvotes
open to pull requests
pull-request
Mirrored from GitHub Pull Request
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/pocket-id-pocket-id-2#965
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?