QuestDB for Time Series Data

[robi]

https://questdb.io
QuestDB is the fastest open source time series database.

Built for performance

• SIMD-optimized analytics
• list itemRow- and column-based access
• Vectorized query execution
• Tiny memory footprint
• C++ and zero-GC Java

Optimized for time series

• Relational model for time series
• Data stored in chronological order
• Time partitioned
• Immediate consistency
• Fast InfluxDB line protocol

Implemented with SQL
*Time series and relational joins
*Postgres compatibility
*Aggregations and downsampling
*Unlimited sub-queries
*Built-in SQL optimizer

Interact with QuestDB using the Postgres layer and any tool that connects to it.
Interactive console to import data (drag and drop) and start querying right away.

[robi]

Is @staff looking into this for Multi Cloudron stats?

[girish]

@robi We use Whisper for stats (via graphite) - https://graphite.readthedocs.io/en/latest/whisper.html

[robi]

@girish I see, which seems like a fine choice for a single server, however QuestDB is better suited for multi server aggregation and immediate consistency from multiple sources.