• Product
  • Pricing
  • Docs
  • Using PostHog
  • Community
  • Company
  • Login
  • Blog
  • Engineering

Engineering

AllInside PostHogProduct updatesGuidesStartupsOpen sourceCEO diaries

In-depth: ClickHouse vs PostgreSQL

Oct 28, 2022 by Mathew Pregasen

In-depth: ClickHouse vs PostgreSQL

Oct 28, 2022 by Mathew Pregasen
The best of PostHog. Delivered twice a month.
Recent Posts
The 2010s were marked by an explosion of tools focused on data. One of the biggest was session recording – a screen-recording-like service that tracked a user’s activity. Typically, session recording (SR) was popular with marketers and product…
Benchmarking the impact of session recording on performance
Aug 31, 2022 by Mathew Pregasen
When developing software, there's no shortage of work: building new features, fixing bugs, maintaining infrastructure, launching new systems, phasing deprecated solutions out, ensuring security, keeping track of dependencies… Whew. And that's before…
Automating a software company with GitHub Actions
Jul 5, 2022 by Michael Matloka
When PostHog was born in 2020, it was a simple Python application (Django + Celery) backed by a PostgreSQL datastore. Troubleshooting was easy, while the low barrier of entry meant fast adoption and more feedback on where to take the product. This…
How we’re making PostHog deployments easier
Mar 22, 2022 by Harry Waye, Guido Iaquinti
We want PostHog to become the first choice for product analytics at any scale. To do that, users should have a smooth experience exploring their product data - including not waiting minutes for queries to load. In this post, I’m going to break down…
The secrets of PostHog query performance
Mar 22, 2022 by Karl-Aksel Puulmann
In this world nothing is certain except death, taxes, and database migrations. As your product evolves, your schemas evolve too, and you need migrations to update them. However, not all migrations are made equal. Some are simple, others are complex…
Enabling zero downtime data migrations for self-hosted users
Mar 18, 2022 by Yakko Majuri
When PostHog was fresh out of YC last year, there were two things we focused on: (i) build and (ii) talk to customers. Hiring a product person felt like it would slow us down. Engineers on our team would speak to our users (also engineers) - surely…
I used to think you don't need product people. I was wrong.
Feb 18, 2022 by James Hawkins
Session Recording  is one of PostHog's core features, and one of the few completely  open source ression replay tools  available. It allows you to see how real users use your website, mouse clicks and all. It's really cool and addictive (give it a…
Solving the mystery of PostHog’s missing session recordings
Feb 11, 2022 by Rick Marron
I recently wrote a blog post for my personal site about the  lessons I'd learned from leading my first two projects as a Software Engineer at PostHog  . In it, I lay out a five-step approach for how I own projects.   One common theme that stood out…
How I learned to love feedback loops (and make better products)
Feb 4, 2022 by Neil Kakkar
Update (May 2022):  Plugins are now known as  apps ! The plugin server has become an integral part of PostHog, as it is responsible for event ingestion. However, it isn’t called “ingestion server” because it was originally designed to run plugins. So…
The state of plugins on PostHog
Nov 16, 2021 by Yakko Majuri
ClickHouse supports speeding up queries using materialized columns to create new columns on the fly from existing data. In this post, I’ll walk through a query optimization example that's well-suited to this rarely-used feature. Consider the…
How to speed up ClickHouse queries using materialized columns
Oct 26, 2021 by Karl-Aksel Puulmann
Frontend filters & backend SQL - A chat with Eric Duong, Sam Winslow, James Greenhill, and Buddy Williams
Jun 4, 2021
Let the pull requests come in! We're happy to announce that PostHog has joined  Hacktoberfest 2020 . For those who don't know, Hacktoberfest is an initiative led by DigitalOcean to promote open source projects and foster the overall open 
source…
PostHog Joins Hacktoberfest 2020
Oct 1, 2020
We ship whenever
Jul 23, 2020
Setting up super fast Cypress tests on GitHub Actions
Jun 10, 2020
  • Product

  • Overview
  • Pricing
  • Product analytics
  • Session recording
  • A/B testing
  • Feature flags
  • Apps
  • Customer stories
  • PostHog vs...
  • Docs

  • Quickstart guide
  • Self-hosting
  • Installing PostHog
  • Building an app
  • API
  • Webhooks
  • How PostHog works
  • Data privacy
  • Using PostHog

  • Product manual
  • Apps manuals
  • Tutorials
  • Community

  • Questions?
  • Product roadmap
  • Contributors
  • Partners
  • Newsletter
  • Merch
  • PostHog FM
  • PostHog on GitHub
  • Handbook

  • Getting started
  • Company
  • Strategy
  • How we work
  • Small teams
  • People & Ops
  • Engineering
  • Product
  • Design
  • Marketing
  • Customer success
  • Company

  • About
  • Team
  • Investors
  • Press
  • Blog
  • FAQ
  • Support
  • Careers
© 2022 PostHog, Inc.
  • Code of conduct
  • Privacy policy
  • Terms