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

Usage of sqlx migration with postgres #26

Closed
xanderio opened this issue Nov 17, 2022 · 1 comment
Closed

Usage of sqlx migration with postgres #26

xanderio opened this issue Nov 17, 2022 · 1 comment
Assignees
Labels
help wanted Extra attention is needed

Comments

@xanderio
Copy link

It is currently not possible to use apalis on the same postgres database as the main application.

This is do to the sqlx Migrator currently not support multiple applications using the same database. As the postgres migrations are already using a separate schema, it would be quite nice to be able to setup apalis in the same database as the main application it self.

I currently see two options:

  1. Users have to copy our migrations into there sqlx migration folder.
  2. We don't use the sqlx migrator for postgres until sqlx supports mutliple applications in the same database.

This isn't a problem for sqlite or mysql as either of these support postgresql like schemas.

See: launchbadge/sqlx#1698

@geofmureithi geofmureithi self-assigned this Dec 8, 2022
@geofmureithi geofmureithi added the help wanted Extra attention is needed label Dec 8, 2022
@geofmureithi
Copy link
Owner

This can be solved with an approach similar to #81

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants