This section describes the architecture of QuestDB, how it stores and queries data, and introduces features and capabilities specific to QuestDB.

As a start, we suggest you read about the storage model and about the . To make the most of QuestDB, you should also get familiar with our SQL extensions which allow to make the most of time series capabilities with an efficient non-verbose syntax. You will also find the concept interesting to store and retrieve repetitive strings efficiently.

Get started

In this section you will learn how to connect to QuestDB using popular tools and languages. Importing and/or inserting data are both covered in the page. Finally, you can check the query data page in order to run your queries.

Third-party tools

• instructions for connecting QuestDB as a datasource for building visualizations and dashboards
• Kafka guide for ingesting data from topics into QuestDB by means of Kafka Connect
• guide for collecting system metrics, specifying QuestDB as an output and visualizing the results

This section contains resources for managing QuestDB instances and has dedicated pages for the following topics:

• Deployment details with information for running locally, on Kubernetes or the AWS AMI
• strategy to delete old data and save disk space
• Health monitoring endpoint for determining the status of the instance

Reference

• Postgres

• CLI

The configuration page shows all the properties that can be used to customize QuestDB.

• Date time
• Numeric
• Row generator
• Timestamp generator

• Datatypes
• ALTER TABLE ALTER COLUMN ADD INDEX
• ALTER TABLE DROP PARTITION
• CASE
• COPY
• EXCEPT INTERSECT
• DROP
• INSERT
• LATEST BY
• ORDER BY
• SAMPLE BY
• SHOW
• UNION
• WITH

We are happy to help with any question you may have, particularly to help you optimize the performance of your application. Feel free to reach out using the following channels:

• Join the Community Slack
• or send us an email at