July 2023 Summaries

Null values posed challenges during the development of HogQL, a tool providing direct SQL access to data, as they resulted in inaccurate results and customer confusion due to ClickHouse's strict handling of nulls, where any expression containing a null value becomes null. Existing solutions for handling nulls in PostHog were inadequate for HogQL's capabilities, as they required users to manually handle nulls, leading to a cumbersome user experience. To address this, the developers implemented several solutions: modifying how the concat function works to be null-tolerant by converting null values to strings, introducing nullish coalescing to simplify expressions, and adding a nullable property on all fields to enable special null handling without disrupting ClickHouse's optimization processes. These changes improved the user experience by abstracting complex SQL modifications away from users, making direct SQL access more user-friendly while preserving the power and flexibility of HogQL.

PostHog is presented as a compelling alternative to Google Analytics, especially in light of dissatisfaction with Google Analytics 4. It offers a user-friendly setup, similar to its predecessor, and enhances functionality with features like custom event capture, session replays, and A/B testing. PostHog's analytics framework aligns closely with Google Analytics but uses different terminology, such as "insights" for reports and "persons" for audiences. Users can customize dashboards and insights to suit their needs, leveraging templates and filters to analyze data effectively. PostHog's event-based approach allows for detailed user tracking through properties and cohorts, while its action-based system mirrors Google Analytics' goals and conversions. Additionally, PostHog supports session replays, enabling users to visualize user behavior on their site, and offers integrations with platforms like Segment and BigQuery for data import and export. It provides a generous free tier, allowing up to 1 million events and 5,000 session recordings per month.