QuestDB alternatives and similar libraries
Based on the "Database" category.
Alternatively, view QuestDB alternatives based on common mentions on social networks and blogs.
-
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io) -
-
-
Lettuce
Advanced Java Redis client for thread-safe sync, async, and reactive usage. Supports Cluster, Sentinel, Pipelining, and codecs. -
-
-
OpenDJ
OpenDJ is an LDAPv3 compliant directory service, which has been developed for the Java platform, providing a high performance, highly available, and secure store for the identities managed by your organization. Its easy installation process, combined with the power of the Java platform makes OpenDJ the simplest, fastest directory to deploy and manage. -
-
Spring Data JPA MongoDB Expressions
Use the MongoDB query language to query your relational database, typically from frontend. -
WorkOS - The modern identity platform for B2B SaaS
Do you think we are missing an alternative of QuestDB or a related project?
README
English | [简体中文](./i18n/README.zh-cn.md) | [繁體中文](./i18n/README.zh-hk.md) | [العربية](./i18n/README.ar-dz.md)
QuestDB
QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports.
QuestDB implements ANSI SQL with native extensions for time-oriented language features. These extensions make it simple to correlate data from multiple sources using relational and time series joins. QuestDB achieves high performance from a column-oriented storage model, massively-parallelized vector execution, SIMD instructions, and various low-latency techniques. The entire codebase was built from the ground up in Java and C++, with no dependencies, and is 100% free from garbage collection.
Try QuestDB
We provide a live demo provisioned with the latest QuestDB release and sample datasets:
- 10 years of NYC taxi trips with 1.6 billion rows
- live trading data from a cryptocurrency exchange
- geolocations of 250k unique ships over time
Install QuestDB
To run QuestDB, Docker can be used to get started quickly:
docker run -p 9000:9000 -p 9009:9009 -p 8812:8812 questdb/questdb
macOS users can use Homebrew:
brew install questdb
brew services start questdb
questdb start // To start questdb
questdb stop // To stop questdb
The QuestDB downloads page provides direct downloads for binaries and has details for other installation and deployment methods.
Connect to QuestDB
You can interact with QuestDB using the following interfaces:
- Web Console listening on port
9000 - REST API on port
9000 - PostgreSQL wire protocol on
port
8812 - InfluxDB line protocol for
high-throughput ingestion on port
9009
How QuestDB compares to other open source TSDBs
Here are high-cardinality
Time Series Benchmark Suite
results using the cpu-only use case with 6 workers on an AMD Ryzen 3970X:
The following table shows query execution time of a billion rows run on a
c5.metal instance using 16 of the 96 threads available:
| Query | Runtime |
|---|---|
SELECT sum(double) FROM 1bn |
0.061 secs |
SELECT tag, sum(double) FROM 1bn |
0.179 secs |
SELECT tag, sum(double) FROM 1bn WHERE timestamp in '2019' |
0.05 secs |
Resources
📚 Read the docs
- QuestDB documentation: understand how to run and configure QuestDB.
- Tutorials: learn what's possible with QuestDB step by step.
- Product roadmap: check out our plan for upcoming releases.
❓ Get support
- Community Slack: join technical discussions, ask questions, and meet other users!
- GitHub issues: report bugs or issues with QuestDB.
- GitHub discussions: propose new features or show what you've built.
- Stack Overflow: look for common troubleshooting solutions.
🚢 Deploy QuestDB
Contribute
We are always happy to have contributions to the project whether it is source code, documentation, bug reports, feature requests or feedback. To get started with contributing:
- Have a look through GitHub issues labeled "Good first issue".
- Read the contribution guide.
- For details on building QuestDB, see the build instructions.
- Create a fork of QuestDB and submit a pull request with your proposed changes.
✨ As a sign of our gratitude, we also send QuestDB swag to our contributors. Claim your swag here.
A big thanks goes to the following wonderful people who have contributed to QuestDB: (emoji key):
<!-- ALL-CONTRIBUTORS-LIST:START - Do not remove or modify this section --> <!-- prettier-ignore-start --> <!-- markdownlint-disable --> clickingbuttons💻 🤔 📓 ideoma💻 📓 ⚠️ tonytamwk💻 📓 sirinath🤔 igor-suhorukov💻 🤔 mick2004💻 📦 rawkode💻 🚇 solidnerd💻 🚇 solanav💻 📖 shantanoo-desai📝 💡 alexprut💻 🚧 lbowman💻 ⚠️ chankeypathak📝 upsidedownsmile💻 Nagriar💻 piotrrzysko💻 ⚠️ mpsq💻 siddheshlatkar💻 Yitaek✅ 💡 gabor-boros✅ 💡 kovid-r✅ 💡 TimBo93🐛 📓 zikani03💻 jaugsburger💻 🚧 TheTanc📆 🖋 🤔 davidgs🐛 🖋 kaishin💻 💡 bluestreak01💻 🚧 ⚠️ patrickSpaceSurfer💻 🚧 ⚠️ chenrui333🚇 bsmth📖 🖋 Ugbot💬 📓 📢 lepolac💻 🔧 tiagostutz📓 🐛 📆 Lyncee59🤔 💻 rrjanbiah🐛 sarunas-stasaitis🐛 RiccardoGiro🐛 duggar🐛 postol🐛 petrjahoda🐛 t00🐛 snenkov📓 🐛 🤔 marregui💻 🤔 🎨 bratseth💻 🤔 📓 welly87🤔 fuzzthink🤔 📓 nexthack💻 g-metan🐛 tim2skew🐛 📓 ospqsp🐛 SuperFluffy🐛 nu11ptr🐛 comunidadio🐛 mugendi🤔 🐛 📖 paulwoods222🐛 mingodad🤔 🐛 📖 houarizegai📖 jjsaunier🐛 zanek🤔 📆 Geekaylee📓 🤔 lg31415🐛 📆 null-dev🐛 📆 ultd🤔 📆 ericsun2🤔 🐛 📆 giovannibonetti📓 🐛 📆 wavded📓 🐛 puzpuzpuz📖 💻 📓 rstreics💻 🚇 📖 mariusgheorghies💻 🚇 📖 pswu11🖋 🤔 🎨 insmac💻 🤔 🎨 eugenels💻 🤔 🚧 bziobrowski💻 📆 Zapfmeister💻 📓 mkaruza💻 DylanDKnight📓 🐛 enolal826💻 glasstiger💻 argshook💻 🤔 🎨 🐛 amunra💻 📖 🐛 GothamsJoker💻 kocko💻 jerrinot💻 🤔 🐛 rberrelleza💻 Cobalt-27💻 eschultz💻 XinyiQiao💻 terasum📖 PlamenHristov💻 tris0laris📝 🤔 HeZean💻 🐛 iridess💻 📖 selmanfarukyilmaz🐛 donet5🤔 🐛 Zahlii🐛 salsasepp🐛 EmmettM🐛 ⚠️ robd003🤔 AllenEdison🐛 CSharpDummy🐛 shimondoodkin🐛 🤔 huuhait🐛 🤔 alexey-milovidov🐛 suconghou🐛
<!-- markdownlint-restore --> <!-- prettier-ignore-end -->
<!-- ALL-CONTRIBUTORS-LIST:END -->
This project follows the all-contributors specification. Contributions of any kind welcome!