Live data from Hacker News

Optimizing ClickHouse: Tactics that worked for us

highlight.io

1–10 of 26 posts

Re: Optimizing ClickHouse: Tactics that worked for us

#2
We've been using highlight for our bootstrapped member management platform[1] and I gotta say I'm super impressed with the session replay feature, it's really helpful for understanding user behavior at a fraction of the price of competitors.

I remember wanting to use Heap's session replay only to release they want hundreds of dollars per _month_, my last bill with highlight was $2.38 I recall.

That's all to say that I'm glad Highlight is figuring out how to scale while still offering their features to the small players of the world.

[1] https://embolt.app

Re: Optimizing ClickHouse: Tactics that worked for us

#3
post #2

We've been using highlight for our bootstrapped member management platform[1] and I gotta say I'm super impressed with the session replay feature, it's really helpful for understanding user behavior at a fraction of the price of competitors. I remember wanting to use Heap's session replay only to release they want hundreds of dollars per _month_, my last bill with highlight was $2.38 I recall. That's all to say that…

Highlight.io cofounder here. Thanks for the shout out. Glad to hear you like the product; continue to share feedback as you use it!

Re: Optimizing ClickHouse: Tactics that worked for us

#4
post #2

We've been using highlight for our bootstrapped member management platform[1] and I gotta say I'm super impressed with the session replay feature, it's really helpful for understanding user behavior at a fraction of the price of competitors. I remember wanting to use Heap's session replay only to release they want hundreds of dollars per _month_, my last bill with highlight was $2.38 I recall. That's all to say that…

Very nice and very inspirational for someone bootstrapping a startup.

The pages clearly defined what you are building and how to use it.

The explanation of platform fees makes sense, though it could more clear if the pricing examples are only based on those fees or are account limits to number of members or dues.

You might want to check your terms of service, they do not list a jurisdiction and have the placeholder [jurisdiction] instead.

Best of luck with it!

Re: Optimizing ClickHouse: Tactics that worked for us

#6
clickhouse-local is pretty slick as well. You can operate directly on text files as if they were tables. I made my own toy text file database thing and thought I was cool because I could outrun similar programs like q, textql, sqlite, etc. But clickhouse-local had me by a factor of 10 easy in every kind of query with every type of data. Those guys know stuff.

Re: Optimizing ClickHouse: Tactics that worked for us

#7
post #6

clickhouse-local is pretty slick as well. You can operate directly on text files as if they were tables. I made my own toy text file database thing and thought I was cool because I could outrun similar programs like q, textql, sqlite, etc. But clickhouse-local had me by a factor of 10 easy in every kind of query with every type of data. Those guys know stuff.

Have heard good things about local. Clickhouse more broadly is an awesome project and they're always on standby to help our eng team team as well.

Re: Optimizing ClickHouse: Tactics that worked for us

#8

> We opted to use the ClickHouse Kafka Connect Sink that implements batched writes and exactly-once semantics achieved through ClickHouse Keeper. Just a heads up, You've got repeated line there

Put up a fix, thanks: https://github.com/highlight/highlight/pull/8571

Re: Optimizing ClickHouse: Tactics that worked for us

#10
post #9

> We opted to use the ClickHouse Kafka Connect Sink that implements batched writes and exactly-once semantics achieved through ClickHouse Keeper. Just a heads up, You've got repeated line there

Might have been a joke on "exactly once" ;)

I see what you did there.
Post reply on HN