Use postgresql database #45

Closed
opened 2026-02-04 16:23:22 +03:00 by OVERLORD · 5 comments
Owner

Originally created by @rzig on GitHub (Jul 15, 2018).

Hi! Would it be possible to add support for PostgreSQL? I'd like to use a database independent of the docker container.

Originally created by @rzig on GitHub (Jul 15, 2018). Hi! Would it be possible to add support for PostgreSQL? I'd like to use a database independent of the docker container.
OVERLORD added the enhancementlow priority labels 2026-02-04 16:23:22 +03:00
Author
Owner

@mprasil commented on GitHub (Jul 15, 2018):

It's definitely possible - diesel that's used as ORM layer does support Postgres, however it's not an easy task to do that. Having DB backed swap-able in place is not goal of diesel and hence you need some work around this.

Having said that I don't think we use SQL directly outside of the migrations code, so if someone is motivated enough to dive into the code to do that, patches would be welcome.

@mprasil commented on GitHub (Jul 15, 2018): It's definitely possible - diesel that's used as ORM layer does support Postgres, however it's not an easy task to do that. Having DB backed swap-able in place is not [goal of diesel](https://github.com/diesel-rs/diesel/issues/980#issuecomment-312849513) and hence you need some work around this. Having said that I don't think we use SQL directly outside of the migrations code, so if someone is motivated enough to dive into the code to do that, patches would be welcome.
Author
Owner

@mprasil commented on GitHub (Aug 10, 2018):

Note that we're using replace_into a lot. It appears, that this might not be supported with Postgres.

@mprasil commented on GitHub (Aug 10, 2018): Note that we're using [replace_into](https://docs.rs/diesel/1.2.2/diesel/fn.replace_into.html) a lot. It appears, that this might not be supported with Postgres.
Author
Owner

@jgrip commented on GitHub (Sep 27, 2018):

Upserts were added in 9.5, so this is supported on version 9.5 and up.
http://www.postgresqltutorial.com/postgresql-upsert/

Not looked at the bw_rs code to see how much work it would be yet.

@jgrip commented on GitHub (Sep 27, 2018): Upserts were added in 9.5, so this is supported on version 9.5 and up. http://www.postgresqltutorial.com/postgresql-upsert/ Not looked at the bw_rs code to see how much work it would be yet.
Author
Owner

@odarriba commented on GitHub (Nov 4, 2018):

It would be very helpful tonbe able to deploy bw_rs in Kubernetes and ease the backup of the files! Also running multiple nodes without direct file sharing

@odarriba commented on GitHub (Nov 4, 2018): It would be very helpful tonbe able to deploy bw_rs in Kubernetes and ease the backup of the files! Also running multiple nodes without direct file sharing
Author
Owner

@dani-garcia commented on GitHub (Nov 9, 2018):

To keep the issue tracker more focused, I'm closing this issue in favor of the meta issue at #246.

@dani-garcia commented on GitHub (Nov 9, 2018): To keep the issue tracker more focused, I'm closing this issue in favor of the meta issue at #246.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/vaultwarden#45