QuestDB
Data
time-series database
SHOW HN2020
271points
93comments
#161of 3,028 in 2020
Top 6%of 2020 by points
How HN took it
CuriousMostly questions and neutral comments
6 positive, 41 neutral or asking, 1 mixed, 14 critical, out of 62 comments about the project. Thread score -0.25.
Performance: 1 for, 9 againstDesign: 3 for, 4 againstIdea: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Impressive performance on simple queries.
From 2 comments
I abused LEFT JOIN to create a query that produces 224,964,999,650,251 rows. Only 3.68ms execution time, now that's impressive!
calibas on HNVery impressive, i think building your own (performant) database from scratch is one of the most impressive software engineering feats. Can you let me know a little bit of how an…
strikelaserclaw on HN
Objections
Many common queries take tens of seconds to minutes; WHERE and GROUP BY paths are not yet optimised.
From 4 comments
Great demo! I'm curios why the following query doesn't finish in tens of seconds: ``` select sum(passenger_count) from trips where passenger_count=1 ``` The same query is…
valyala on HNFYI, this query took 81 seconds: select count(*) from trips where fare_amount > 0 Presumably this is Hacker News load?
gubby on HN`select distinct pickup_latitude, count(*) from trips` takes 241.37s. But some of the more top level queries are quite fast.
lykr0n on HNSELECT vendor_id, cab_type, avg(fare_amount) from trips; This takes ~86 seconds. Ran it multiple times. SIMD is one of the ingredients for better query performance, but NOT THE…
keshavmr on HN
Back button is hijacked by the demo page.
From 2 comments
How nice of you to hijack the back-button (to return to HN after some sample queries) despite that being how myself & others found this in the first place. I was really liking…
LordOfWolves on HNI don't know anything about this database, but this link did break the browser <back> button. Perhaps you can look into fixing that in a future release.
woodgrainz on HN
Few aggregation functions compared to ClickHouse.
From 1 comment
It looks very proming, congrats. I use ClickHouse in production and I'd love to see how this project evolves. My main disappointment is the amount of aggregation functions:…
pachico on HN
Requests
Add GROUP BY and EXPLAIN support.
From 1 comment
Very cool. Major props for putting this out there and accepting arbitrary queries. Couple comments / questions: - Correct that there’s no GROUP BY support? - EXPLAIN or similar…
twoodfin on HN
Support out-of-order inserts.
From 1 comment
That's a very cool demo, good job! I have a few questions if you don't mind. - Could you share the specs of the hardware powering the demo? - For IoT-type usage, one common…
maltalex on HN
Add geo support and compression.
From 2 comments
Any plans for geo support? Looks like you have lat/lon stored as two independent doubles, which does not lend itself well to any sort of geo operations.
Bedon292 on HNThat's a very cool demo, good job! I have a few questions if you don't mind. - Could you share the specs of the hardware powering the demo? - For IoT-type usage, one common…
maltalex on HN
Questions
How does it compare to ClickHouse, TimescaleDB, Druid or Pinot?
From 3 comments
Cool project :) How would you compare QuestDB against TimescaleDB?
tpayet on HNAny comparisons to Druid or Pinot?
patelh on HNAuthor here. A few weeks ago, we wrote about how we implemented SIMD instructions to aggregate a billion rows in milliseconds [1] thanks in great part to Agner Fog’s VCL library…
bluestreak on HN
What are the hardware specs and minimum RAM?
From 2 comments
A peek into the hardware specs behind this: CPU, memory, storage, network would be nice.
yumraj on HNI was looking for dev/production specs for QuestDB the other day and didn't see them in the docs. Being that it's in Java, which can be quite memory-hungry, what's the minimum…
lux on HN
Alternatives named
ClickHouse
From 2 comments
How timely! I've done a deep dive into column store databases for the past couple of weeks. Reading through the Quest docs, I'd give it the following characteristics. Are these…
sa46 on HNGreat demo! I'm curios why the following query doesn't finish in tens of seconds: ``` select sum(passenger_count) from trips where passenger_count=1 ``` The same query is…
valyala on HN
TimescaleDB
From 2 comments
How timely! I've done a deep dive into column store databases for the past couple of weeks. Reading through the Quest docs, I'd give it the following characteristics. Are these…
sa46 on HNThat's a very cool demo, good job! I have a few questions if you don't mind. - Could you share the specs of the hardware powering the demo? - For IoT-type usage, one common…
maltalex on HN
VictoriaMetrics
From 1 comment
This seems very similar to Victoria Metrics. Victoria Metrics is very much based on the design of Clickhouse and currently shows best of class performance numbers for time series…
gregwebs on HN
Athena
From 1 comment
Athena has been benchmaked here with similar dataset (1.1B vs our 1.6Bn): https://tech.marksblogg.com/benchmarks.html
bluestreak on HN