Hacker News new | ask | show | jobs
by TheTank 2183 days ago
Very accurate!

Regarding the theme of joins, I would just add that QuestDB also has a concept called SYMBOL which allows to store repetitive strings into a table as an integer in the background, while letting the user manipulate strings. This means that instead of storing something like 'sensor_id' and then looking up the corresponding 'sensor_name' using a join, you can manipulate 'sensor_name' directly and skip using joins.

1 comments

SYMBOL concept sounds like ClickHouse LowCardinality (or maybe implicit 'dictionary').