Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by anonu | Hacker News Reader

Full thread

anonu·

Jd has been around for a while. Buy is it production ready?

I'm still looking for an open source replacement to kdb, that matches kdb's speed and featureset.

View on HN

Nothing matches kdb's speed except GPU-accelerated DBs: https://tech.marksblogg.com/benchmarks.html

Jd is not open source.

Yeah, KDB is... Not super fun. I've been looking at TimeScaleDB recently, because it's just a PostgreSQL plug-in it seems nice and simple, but I haven't actually compared them directly yet.

If you want some intro info – and you may have found it already – the YouTube channel is a great place to start for TimescaleDB youtube.com/TimescaleDB (for tranparency: I work for Timescale...)

If you were looking at pg because you need:

- open source

- SQL based

- analytics data warehouse

Then check out Clickhouse. I've been really happy with it and it checks all those boxes.

ps - if you're interested in working with clickhouse and open source data tools, I'm hiring: mike@luabase.com

clickhouse '__')

i really dislike clickhouse for anything less than rudimentary analysis, but appreciate that it’s fast for that.

Can you give some tips on what do you mean by "less than rudimentary analysis"? Considering adopting Clickhouse and wondering whether we will encounter problems down the road.

the biggie for me was that analytic window functions are either non-existent or experimental and must be achieved with array function hacks.

it does have nice built-in skew and kurtosis functions, though.

ClickHouse recently landed Window Functions in GA.

Reply on news.ycombinator.com