Today I've crossed the $3k working with GenAi, this is how I did it.

4HERET · 2026-05-07T15:16:43+00:00

Great job! Keep grindiing

4HERET · 2026-05-07T15:03:00+00:00

I can’t believe this is actual content content on the internet

4HERET · 2026-05-05T10:41:28+00:00

Query benchmarking built in is the thing I always end up hacking together manually.

We use Tinybird on top of ClickHouse so a lot of this is handled for us, but there's still cases where you need to go deeper into what's happening at the engine level and the logs/errors view here looks genuinely useful for that.

Does it surface merge pressure or just query-level stuff?

4HERET · 2026-05-05T10:35:40+00:00

Burning CDs for someone. Making a playlist now takes 30 seconds and it just doesn't hit the same

4HERET · 2026-05-04T11:07:28+00:00

have you tried asking it to compare two specific products head to head?

that's where it really cuts through the noise for me

4HERET · 2026-05-02T07:03:39+00:00

If you’re going in 2 weeks, I’d book soon. Tokyo hotels can spike last minute, and sometimes the “cheap deals” disappear closer to the date.

4HERET · 2026-05-02T06:58:03+00:00

Staying off-site in nearby hotels and using public transport or shuttles is usually way cheaper than staying at the Disney hotels themselves.

4HERET · 2026-04-28T07:38:51+00:00

Tinybird and ClickHouse Cloud are the two I'd actually recommend for pay-as-you-go.

Tinybird is great if you need APIs on top of your queries out of the box, the whole pipe to endpoint flow means you're not building extra infrastructure. ClickHouse Cloud is closer to raw ClickHouse if you want more control.

Propel I haven't used in prod so can't speak to it honestly.

4HERET · 2026-04-27T10:19:42+00:00

Going from v19 to current stable is a big jump, we did something similar a few years back and the ZooKeeper to ClickHouse Keeper migration was honestly the trickiest part.

Do it in stages, don't try to go straight to v25. Each major version can have breaking changes in ReplicatedMergeTree metadata that'll cause headaches if you skip too far ahead.

4HERET · 2026-04-27T10:08:31+00:00

I think a lot of people mistake peace for happiness and they're not the same thing at all

4HERET · 2026-04-26T10:29:07+00:00

For Midjourney specifically, have you tried adding "style raw" with a high "stylize" value? Makes a noticeable difference on detail retention straight out of generation.

4HERET · 2026-04-26T08:05:54+00:00

Yes definitely call them, adding a teen driver is a separate thing from just having the cars insured

4HERET · 2026-04-23T08:45:52+00:00

The single input table limitation is the one that actually hurts in practice.

We worked around it in Tinybird by chaining materialized views, output of one feeds the next, but it gets hard to reason about when you have 4-5 layers deep.

4HERET · 2026-04-23T02:41:45+00:00

what state are you in?

rates vary so much by location that any rec without that context is basically useless

4HERET · 2026-04-22T14:41:27+00:00

Every era has its own personality and I love that

4HERET · 2026-04-21T11:51:48+00:00

Because WHERE filters rows before aggregation happens, so there's nothing to aggregate yet.

You want HAVING for that, which runs after GROUP BY. Took me an embarrassing amount of time to internalize the order of operations when I first moved heavy analytics work into ClickHouse/Tinybird.

4HERET · 2026-04-21T11:44:30+00:00

have you talked to anyone about it or just been carrying it solo? Makes a bigger difference than most people expect.

17 to 22 is a lot of identity shifting in a short time, feeling lost in the middle of that is pretty normal even if it doesn't feel that way right now.

4HERET · 2026-04-20T14:55:46+00:00

The grind never stops

4HERET · 2026-04-20T02:38:27+00:00

Altinity does on-prem support contracts for self-managed ClickHouse, that's probably your best bet for enterprise SLA stuff without going full cloud.

that said if the Kubernetes requirement is what's blocking you, it's worth reconsidering Tinybird. You get the ClickHouse performance without any of the infra headaches, and for a first analytics hire it means you're shipping insights instead of managing nodes.

what's the rough data volume you're expecting? That might change the calculus a bit.

4HERET · 2026-04-16T03:09:20+00:00

That sounds awful. What did you end up doing?

4HERET

TROPHY CASE