QuestDB is a relational column-oriented database designed for real-time analytics on time series and event data. It uses the SQL language with some extensions for time series. This documentation will help you to get familiar with QuestDB.
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 designated timestamp. 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 symbol concept interesting to store and retrieve repetitive strings efficiently.
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 insert data page. Finally, you can check the query data page in order to run your queries.
This section contains the reference documentation for the following categories:
The configuration page shows all the properties that can be used to customize QuestDB.
- ALTER TABLE ADD COLUMN
- ALTER TABLE ALTER COLUMN ADD INDEX
- ALTER TABLE DROP COLUMN
- ALTER TABLE DROP PARTITION
- CREATE TABLE
- EXCEPT INTERSECT
- GROUP BY
- LATEST BY
- ORDER BY
- SAMPLE BY
We are happy to help with any question you may have, particularly to help you optimise the performance of your application. Feel free to reach out using the following channels: