sdairs

13 ms·

31.
by sdairs 1y ago
This is really nice
32.
by sdairs 1y ago
Yeah that's right. We create "patch parts" that contain the updates, and merge them along with the usual merge process.
33.
by sdairs 1y ago
To be honest, I just didn't think of it. But thanks for the suggestion, we'll give it a go!
34.
by sdairs 1y ago
I think we do allude this in the post, if my understanding is correct. AFAIK both ClickHouse and Postgres are using MVCC, so when an UPDATE is run, a new version of the data is written and the original data is not changed. In ClickHouse, we
35.
by sdairs 1y ago
If you're refering to the experimental ACID transactions, we didn't test them; I'll check what state they're in and see if its worth including yet, if not, we'll for sure come back to them later and do a similar tes
36.
by sdairs 1y ago
One of the post authors here; I just want to stress that the goal of the post was not at all to be "haha we're better than postgres" - we explicitly call out the caveats behind the results. Prior to July 2025 (ClickHouse v25.
37.
by sdairs 1y ago
Sadly, for the people who cheat, it is, indeed, worth it. :/
38.
by sdairs 1y ago
Is the proposition in the OP not pretty much what you're suggesting in your blog? They're currently not using the query builder syntax, instead its pretty much "improving on SQL as strings" with a bunch of the other ORM-
39.
by sdairs 1y ago
Without doubt, the majority of the market for OLAP today is still internal warehousing & BI. But the market for using OLAP behind features inside user-facing B2C/B2B apps has been kicking off for quite a few years now. Big consumer
40.
by sdairs 1y ago
It's an interesting proposition. There's a lot of good tooling for data engineering work on OLAP, but there's really not much out there for devs that need to integrate with them. Does it have anything to help a dev with query
41.
You can't UPDATE what you can't find: ClickHouse vs. PostgreSQL(clickhouse.com)
1 points by sdairs 1y ago|0 comments
42.
Building Fast UPDATEs for ClickHouse(clickhouse.com)
1 points by sdairs 1y ago|0 comments
43.
We built fast UPDATEs for ClickHouse – Part 2: SQL-style UPDATEs(clickhouse.com)
2 points by sdairs 1y ago|0 comments
44.
We built fast UPDATEs for ClickHouse – Part 2: SQL-style UPDATEs(clickhouse.com)
1 points by sdairs 1y ago|0 comments
45.
We built fast UPDATEs for ClickHouse – Part 1: Purpose-built engines(clickhouse.com)
2 points by sdairs 1y ago|0 comments
46.
ClickHouse Join Performance vs. Snowflake and Databricks(clickhouse.com)
3 points by sdairs 1y ago|0 comments
47.
by sdairs 2y ago
Interesting, that's not a problem I've come across before particularly - could you share more? Are you looking for setups for OSS ClickHouse or managed ClickHouse services that solve it? Both Tinybird & ClickHouse Cloud are ma
48.
by sdairs 2y ago
Very cool! Could you share the key difference between this and the previous pg_analytics, and motivation of making it a separate plugin?
49.
by sdairs 3y ago
The answer is to pay school teachers more, not demand everyone else be paid less.
50.
by sdairs 3y ago
Lots of interesting stuff happening with the GIL with PEP703 seemingly greenlit. https://discuss.python.org/t/a-steering-council-notice-about... Honestly it's fascinating that such a small smell can lead to such s
51.
by sdairs 3y ago
I don't disagree with you, and I believe you're probably teaching people many of the right things that will set them up to do well in the future. But...the tricky part about learning just concepts and not the skills is that they a
52.
by sdairs 3y ago
Hey, it's my blog - apologies! I am really bad at frontend and this was the first iteration of me trying to build my blog from scratch doing everything myself. It's definitely not perfect! Appreciate the feedback and I'll try
53.
by sdairs 3y ago
Author of the post here, I had no idea it got posted here and just noticed a huge traffic spike. So, hello! Something I got asked a lot in response to this post, or maybe berated for, is that there is a lot more to Data Engineering than SQL
54.
Adding JOIN support for parallel replicas on ClickHouse(tinybird.co)
11 points by sdairs 3y ago|0 comments
55.
Building a faster CI pipeline with Turborepo and pnpm(tinybird.co)
9 points by sdairs 3y ago|0 comments
56.
by sdairs 4y ago
It's a shame that ClickHouse Inc has not tried to solve the operational complexity of doing this. You might get some performance out of your queries, but at the cost of adding a bunch of new tools & infrastructure just so you can d
57.
by sdairs 4y ago
We do track the real $ cost of time & materials, but tbh I don't think it's anything too exciting. I'll see what we can share!
58.
by sdairs 4y ago
Sure :D I've worked on products across the spectrum, Enterprise software that releases twice a year, smaller stuff that ships once a month, and now a SaaS that releases many times a day. I don't have the data to compare, but I gen
59.
by sdairs 4y ago
Hey, Al from Tinybird here (co-author of the post). We've made up to 20 production releases per day some days. It's transparent to our users, they aren't even aware the upgrade is happening, there's no upgrade button to
60.
by sdairs 4y ago
This is awesome! We did something similar for our internal logging at Tinybird (which itself is built on ClickHouse) and I recently turned into it a (very simplified) Starter Kit that others can fork and use in their projects. https:/

More ›