Databases
Managed QuestDB on your own cluster
Time-series in SQL: sensor readings, market ticks and events by the billion, ingested over ILP and read through any Postgres client.
Created inside a project, beside the apps that use it. Each project gets its own instance, storage and credentials.
A recent addition. It installs today, and the console marks it as new until it has run on a customer's cluster.
01What it does
QuestDB, run for you
QuestDB on the vendor's own chart.
A time-series database you query in SQL, for the data that arrives by the million and is asked about by time. Ingestion goes over the InfluxDB line protocol; reads go through the PostgreSQL wire protocol, so the Postgres driver you already have is the client, and the built-in web console is there for ad-hoc questions.
Partitions are memory-mapped and ingestion buffers in memory, so the size decides how much recent data stays fast. Time-series data only ever grows, which is why the disk is chosen once, at creation.
02Options
What you choose
What the console asks when you create it, in the catalog's own numbers. Anything marked chosen once cannot change without creating a new instance.
- Sizes
- small 1Gi, medium 4Gi, large 8Gi of memory
- Storage
- 20Gi by default, chosen once
- Hostname
- The web console (9000) can be published on a domain
- Public port
- The Postgres wire port (8812) can be opened on a public cluster
- Pause
- No; pause the project instead
03Binding
What your app receives
Bind it to an app and these arrive as environment variables. The values are generated once into a secret and reach the app from there, rather than as something you copy.
- QUESTDB_HOST
- QUESTDB_PORT
- QUESTDB_HTTP_PORT
- QUESTDB_ILP_PORT
- QUESTDB_USERNAME
- QUESTDB_PASSWORD
- QUESTDB_URL
04Adding it
Add QuestDB to a project
The same four steps as every service in the catalog.
- 01Open a project and go to Services.
- 02Pick it from the catalog and choose its options. Only the size is required; everything else has a default.
- 03Create it. Anyport installs it into the project's namespace, generates its credentials into a secret there, and tracks its health.
- 04Bind it to an app. The connection details arrive as environment variables, and rotating the credential never means editing an app.