Is there any way to have multiple databases on questdb in single instance?

Community
1

i have single app that work for several customers, need to segregate database, because after a while data load increase highly.

i hear about install two questdb on containers and rename table for each customer, but neither suitable for me. Is there any other idea?

2

Hi, unfortunately QuestDB does not support multiple databases/schemas in a single instance.

The usual approach is to prefix the table names with the name of the schema, so each customer’s data will be stored in separate tables, and your app always have to use the prefix for table names.

The other option is, as you already mentioned it, having separate database instances per customer.

1 Like