https://questdb.com/ GitHub: https://github.com/questdb/questdb QuestDB is an #open-source #database/timeseries . ## Pros - Much simpler queries for time series data, like selecting from a time interval - High data ingestion speed ## Cons - Optimized for analytical queries like aggregations, filtering and time-based sampling; It isn’t designed to handle frequent, fine‑grained transactional operations (OLTP) such as multi‑row updates or complex transactional consistency. - Lacks transactional features ## Partition On disk, it creates a directory for each partition. **Sample Query** ```sql CREATE TABLE STUFF( a long, b string, c timestamp ) timestamp(c) PARTITION BY YEAR; ``` You can even detach or attach a partition when they are not relevant. ```sql ALTER TABLE btc detach partition list '2012'; ``` On disk, the folder will be renamed to `2012.detached`. To attach it back, `mv 2012.detached 2012.attachable` ```sql ALTER TABLE btc attach partition list '2012'; ``` ## Reference - [Introduction to QuestDB](https://youtu.be/HwPiXl7NoBw) - [YouTube Code to the Moon: QuestDB 🛡️ The Time Traveler's Database (Open Source)](https://youtu.be/A8uMF64rbS8) - Clipping [[QuestDB]] - [What is a Non-relational Database?](https://questdb.com/glossary/non-relational-database/) - Clipping: [[What Is a Non-relational Database?]]