121. In-depth: ClickHouse vs Redshift (posthog.com)
We've written extensively comparing ClickHouse to other analytical databases, including Google BigQuery , Elastic , and Apache Druid . Most of…
122. The most popular PostHog alternatives, compared (posthog.com)
As an all-in-one platform, PostHog replaces a lot of legacy tools. PostHog is great if you: Need quantitative and qualitative insights into user…
123. Introducing HouseWatch: An open-source toolkit for ClickHouse (posthog.com)
We are big fans of ClickHouse. We rely on it heavily to store and retrieve the massive amount of data we process every day. In doing this at scale for…
124. Introducing HogQL: Direct SQL access for PostHog (posthog.com)
Today, we're releasing a major new feature as a public beta: the ability to directly query your PostHog data using SQL . We call this HogQL because…
125. What we built at our sun-kissed Aruba hackathon (posthog.com)
Every year, Team PostHog congregates for our annual all-company offsite . In previous years we've been to Italy, Portugal and Iceland. This year, we…
126. In-depth: ClickHouse vs BigQuery (posthog.com)
Both BigQuery and ClickHouse are databases designed to handle lots of data (like loads of data), but they have distinct philosophies and use cases…
127. In-depth: ClickHouse vs Elasticsearch (posthog.com)
Elasticsearch and ClickHouse are both open-source frameworks with advantages over conventional databases like PostgreSQL for performing tasks over…
128. HogMail #22: Why do companies over-hire?" (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
129. Our simpler goal: Help engineers to be better at product (posthog.com)
One of the things I've learned at PostHog is the simpler a strategy, the more likely it's right. We simplified our strategy recently. This post…
130. In-depth: ClickHouse vs Snowflake (posthog.com)
Two years ago, Snowflake versus ClickHouse was a straightforward comparison. Back then, Snowflake was fully managed, expensive, and broadly featured…
131. HogMail #21: Avoiding the "Product Death Cycle" (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
132. Sunsetting Kubernetes support for PostHog (posthog.com)
We no longer support paid, open-source deployments and it is no longer possible to buy licenses for self-hosted versions - we instead recommend…
133. Why 'Product Engineer' is the most fun role I've had in tech (posthog.com)
In my career so far (admittedly not that long, though no one mistakes me for a college kid any longer, womp womp) I've done a little bit of a lot…
134. HogMail #20: Why do startups fail? (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
135. The best Google Optimize alternatives for apps and websites (posthog.com)
Google recently confirmed the sunsetting Google Optimize, its A/B testing platform. In a statement on its website, Google said: "Google Optimize and…
136. Array 1.43.0: Massive performance improvements! (posthog.com)
Want to know more about what we're up to? Subscribe to our new newsletter , which we send once every two weeks! Need to update a self-hosted instance…
137. In-depth: ClickHouse vs Druid (posthog.com)
Contrary to what the names might suggest, ClickHouse isn’t an TikTok influencer house and Druid isn’t (just) a D&D character class – they're both…
138. HogMail #19: Which meetings should you kill? (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
139. CEO diary: The things I learned in 2022 (posthog.com)
It's always helpful to look back on the year just gone, and 2022 was an exceptionally good year for PostHog. Here's my personal perspective on how it…
140. The essential tools used by product engineers (posthog.com)
Like every role, product engineers have a set of essential tools for their work. Their need to gather insights, ideate, and deploy solutions…
141. HogMail #18: What can SaaS learn from the New York Times? (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
142. What is a product engineer (and why they're awesome) (posthog.com)
Startups see their path to success as building a product many people want and pay for. Out of this need came the role of product engineer. They are a…
143. Array 1.42.0: Get beta features via our roadmap! (posthog.com)
Want to know more about what we're up to? Subscribe to our new newsletter , which we send once every two weeks! 1.42.0 update guide for self-hosted…
144. HogMail #17: The personal traits that can't be taught (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
145. How PostHog built an app server (from MVP to billions of events) (posthog.com)
PostHog's mission is to increase the number of successful products in the world. To achieve it, we're building a comprehensive suite of dev tools…
146. HogMail #16 (posthog.com)
Welcome to HogMail, our newsletter featuring the best of the PostHog blog, tutorials, product guides, and curated articles on building great products…
147. How we’re improving performance by combining persons and events (posthog.com)
In a previous product update we announced a beta for a substantial change to the way we handle persons and events on PostHog. Today, after gathering…
148. Array 1.41.0: Improving performance by up to 400% (posthog.com)
Want to know more about what we're up to? Subscribe to our new newsletter , which we send once every two weeks! 1.41.0 update guide for self-hosted…
149. What is SSO and why you should enable it for PostHog (posthog.com)
Existing at an intersection of convenience and security, single sign-on (SSO) authentication is used and appreciated by both IT teams and everyday…
150. In-depth: ClickHouse vs PostgreSQL (posthog.com)
Honestly, it is a bit ridiculous to compare Postgres and ClickHouse. The two database solutions are as similar as grapes and grapefruit. ClickHouse…