4 ms·

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.

• yiyus 5y ago
  Jd is not open source.
• kokizzu2 5y ago
  clickhouse '__')
  • swasheck 5y ago
    i really dislike clickhouse for anything less than rudimentary analysis, but appreciate that it’s fast for that.
    • nimrody 5y ago
      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.
      • swasheck 5y ago
        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.
        • pritambaral 5y ago
          ClickHouse recently landed Window Functions in GA.
• ZeroCool2u 5y ago
  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.
  • LoriP 5y ago
    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...)
  • mritchie712 5y ago
    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
• vmchale 5y ago
  Nothing matches kdb's speed except GPU-accelerated DBs: https://tech.marksblogg.com/benchmarks.html https://tech.marksblogg.com/benchmarks.html