Why QuestDB?
This pages provides a brief overview on:
Just want to build? Jump to thequick start guide.
Top QuestDB features
QuestDB is applied within cutting edge use cases around the world.
Developers are most enthusiastic about the following key features:
Massive ingestion handling & throughput
If you are running into throughput bottlenecks using an existing storage engineor time series database, QuestDB can help.
High performance deduplication & out-of-order indexing
High data cardinality will not lead toperformance degradation.
Hardware efficiency
Strong, cost-saving performance on very mninimal hardware, including sensors andRaspberry Pi.
SQL with time series extensions
Fast, SIMD-optimized SQL extensions to cruise through querying and analysis.
No obscure domain-specific languages required.
Greatest hits include:
SAMPLE BYsummarizes data into chunksbased on a specified time interval, from a year to a microsecondWHERE INto compress time rangesinto concise intervalsLATEST ONfor latest values withinmultiple series within a tableASOF JOINto associate timestamps betweena series based on proximity; no extra indices required
Benefits of QuestDB
To avoid ingestion bottlenecks, high performance data ingestion is essential.
But performance is only part of the story.
Efficiency measures how well a database performs relative to its availableresources.
QuestDB, on maximal hardware, significantly outperforms peers:
However, on less robust hardware the difference is even more pronounced, as seenin the following benchmark.
Even on hardware as light as a Raspberry Pi 5, QuestDB outperforms competitorson stronger hardware:
Beyond performance and efficiency, with a specializedtime-series database, you don't need to worryabout:
- out-of-order data
- duplicates
- exactly one semantics
- frequency of ingestion
- many other details you will find in demanding real-world scenarios
QuestDB provides simplified, hyper-fast data ingestion with tremendousefficiency and therefore value.
Write blazing-fast queries and create real-timeGrafana via familiar SQL:
SELECT
timestamp, symbol,
first(price) AS open,
last(price) AS close,
min(price),
max(price),
sum(amount) AS volume
FROM trades
WHERE timestamp > dateadd('d', -1, now())
SAMPLE BY 15m;
Intrigued? The best way to see whether QuestDB is right for you is to try itout.
ClickDemo this query in the snippet above to visit our demo instance andexperiment.
To bring your own data and learn more, keep reading!
Where to next?
You'll be inserting data and generating valuable queries in little time.
First, thequick start guide will get you running.
Choose from one of our premium ingest-only language clients:
Python
Python is a programming language that lets you work quickly and integrate systems more effectively.
From there, you can learn more about what's to offer.
- Ingestion overview want to see all availableingestion options? Checkout the overview.
- Query & SQL Overview learn how to queryQuestDB
- Web Console for quick SQL queries, charting and CSVupload/export functionality
- Grafana guide to visualize your data asbeautiful and functional charts.
- Capacity planning to optimize yourQuestDB deployment for production workloads.
Support
We are happy to help with any question you may have.
The team loves a good performance optimization challenge!
Feel free to reach out using the following channels: