Why we rebuilt our data warehouse on DuckDB over ClickHouse
PostHog's original data warehouse had a single goal: delay the moment a company needs to hire their first data engineer. It did that job for a 2…
12 of 800 posts
PostHog's original data warehouse had a single goal: delay the moment a company needs to hire their first data engineer. It did that job for a 2…
A scout is a small agent (don't overthink that word) that looks at, wrangles, and makes sense of any data available in PostHog. It's a core component…
PostHog collects an enormous amount of data about your product ( analytics, session replay, web analytics, error tracking, experiments ) and…
There's a future version of you who isn't boxed into one job function. Someone who has an idea in the morning and the means to ship it the same…
Picture this: your company's social media team excitedly informs you that stonks are up this month. You can see the screenshots. They're green. Holy…
For my birthday this year I got a Pimoroni Presto, a little developer gadget with a 240×240 touchscreen and not much else. I also got an…
The problems with AI agents and apps often don't show up in normal monitoring tools: The code works, the API calls succeed, but the outputs are off…
Today, we're releasing the PostHog Slack app into beta. We built it for those times when a colleague flags an annoying UI quirk, or a customer…
DuckDB has often been called the "SQLite of OLAP". Is it an apt comparison? DuckDB and SQLite are databases with similar design principles. Both are…
We've made some apples to oranges comparisons over the years. None have been so diametrically opposing than Postgres and DuckDB. However, that also…
A few weeks ago at a team offsite in Lisbon, we pointed an AI agent at our query engine, fed it slow queries from production, and let it run overnight…
A lot of "LLM observability" content out there is written for teams running production AI at scale: enterprise governance, fancy eval pipelines…