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.

Sign up for GitHub

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

Jump to bottom

Support Multitenanted schemas #84

Open
guilherme-andrade opened this issue Jan 21, 2021 · 1 comment
Open

Support Multitenanted schemas #84

guilherme-andrade opened this issue Jan 21, 2021 · 1 comment
Labels
help wanted

Comments

@guilherme-andrade
Copy link

guilherme-andrade commented Jan 21, 2021 •
edited
Loading

Que inserts and reads jobs in the public schema by default (see this example in the source), but que-web does not mention the schema in queries. This conflicts with multi-tenancy rack middleware like apartment.

Would it be problematic to specify the DB schema in all SQL queries?
@guilherme-andrade guilherme-andrade changed the title Support Multitenanted schemas by adding public. to all SQL queries to que_jobs Support Multitenanted schemas Jan 21, 2021
@statianzo
Copy link
Owner

Que inserts and reads jobs in the public schema by default (see this example in the source), but que-web does not mention the schema in queries. This conflicts with multi-tenancy rack middleware like apartment.

Would it be problematic to specify the DB schema in all SQL queries?

If que writes to public I think adding the schema in que-web makes sense.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
help wanted
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@statianzo @guilherme-andrade