statianzo / que-web

A web interface for the Que queue
BSD 3-Clause "New" or "Revised" License
88 stars 50 forks source link

Support Multitenanted schemas #84

Open guilherme-andrade opened 3 years ago

guilherme-andrade commented 3 years ago

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?

statianzo commented 3 years ago

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.