Hacker News new | past | comments | ask | show | jobs | submit | tylerhannan's comments login

Do let us know if you have any questions...happy to answer.

(disclaimer: I work at ClickHouse and am super excited the PeerDB team is joining us)


ahhhh...space-filling curves.

With some of the recent work done with ClickHouse this has been an area I've had to learn about and, tbh, wish I had found this earlier.

Our CTO started using Morton curves for interesting purposes several months ago with initially piqued my interest and started me down the path.

https://reversedns.space/ (a map of the Internet) - Morton curve is used as a visualization tool;

https://adsb.exposed/ (a visualizer of air traffic) - Morton curve is used as a database index;

Our most recent release post dove into the usage of Hilbert curves in context of maintaining spatial locality for weather measurements

https://clickhouse.com/blog/clickhouse-release-24-06#hilbert...

Quite an interesting area of study and optimisation!


There is something about this that makes me so very happy.


Sadiq Khan shaking Count Binface's hand during the London mayoral results announcement is rather touching.

https://youtu.be/jkbX0DBhvKE?si=LAz-9-9JYM0N0EBy


He kind of did a service to Khan by beating the far right candidate.


A database is core to your infrastructure...finding out your database is going away is a horrifying situation. Finding out that the time you have to migrate is a few months. Agh.

As others will say, there are options. Rockset helpfully posts links to a bunch of comparisons on their website, and these alternatives include ClickHouse, Elasticsearch, Druid, etc.. https://rockset.com/real-time-analytics-comparison/

I'm inherently biased (as a member of the ClickHouse team). But do check ClickHouse out.

You can always come hang out in our Slack (clickhouse.com/slack) and, of course, the combination of hosted ClickHouse (clickhouse.com/cloud) and the open-source (github.com/clickhouse) may add a bit of comfort when your vendor up and disappears via acquisition.


To anyone else who may be confused like I was: Rockset will, in fact, "gradually transition current customers off Rockset". The OpenAI announcement linked above doesn't say so, but the Rockset announcement does:

https://rockset.com/blog/openai-acquires-rockset/

Month-to-month users been given until September 30, which is a very short amount of time for a major infrastructure transition. Enterprise users are given a vague "talk to your account manager" answer:

https://docs.rockset.com/documentation/docs/faq

In other words, the above isn't just FUD from a competitor, there legitimately are going to be a lot of frantic refugees in the coming months.


I’ve no skin in this particular game that I know of but this migration period is really, really short.


Especially if you’re in certain parts of Northern Europe where it’s common to take the whole of July off work.


Jesus having read the releases this comment should go up more given that I suspect a lot of shops will not have enough time to migrate.


I wanted one of these so much upon initial release.

I'd love the opportunity to actually try one in person but the last release was so hard to come by that it never quite happened.


It was pretty cool to watch this analysis play out internally to ClickHouse (note: I work at ClickHouse).

It was even cooler to see Vinay and Jianfie (authors) excitement to share the analysis, exploration, and detail.


Spelling fail...I'm sorry Jianfei!


lol.

I was waiting for that somewhere ;)


s/is a/was a/g

But more interesting, to me, is language adoption and familiarity by region.

I have a bookmarked dev.to article from 2020 that discussed programming language popularity by state - https://dev.to/eduecosystem/what-is-the-most-popular-program...

I'm uncertain if anyone has extrapolated that to more geographic regions. It would be interesting.


Definitely used in production ;) and at rather some scale.

It runs thousands of clusters, daily, both in CSP hosted offerings (including our own ClickHouse Cloud) and at customers running the OSS release.

Never accept any claims at face value and always test. But, in this case, it is quite battle-hardened (i.e. the Jepsen tests run 3x daily https://github.com/ClickHouse/ClickHouse/tree/master/tests/j...)

But yes, ZooKeeper is pretty amazing. We are building on the backs of giants.

I'd also argue the RAFT v. ZAB is an important production scale conversation. But, as the blog says, Zookeper is a better option when you require scalability with a read-heavy workload.


fundamentally, yep.

https://pradeepchhetri.xyz/clickhousekeeper/ talks about some experiments in exactly that vein.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: