Frontend filters & backend SQL - A chat with Eric Duong, Sam Winslow, James Greenhill, and Buddy Williams
Blog post from PostHog
The document is a technical discussion among PostHog's engineering team, focusing on the complexities and challenges of handling filters and properties within their Insight page's front-end and back-end systems. The conversation explores the multiple layers of filtering, including action filters and property filters, and the intricacies of maintaining consistency and efficiency across different insights like trends, funnels, and sessions. The team discusses the current reliance on search parameters for tracking filters and considers the potential benefits of moving filter state management to the back-end to improve performance and user experience. Additionally, they delve into the details of how SQL queries are constructed, executed, and debugged, highlighting the trade-offs between using raw SQL for flexibility and the challenges it presents in terms of code readability and maintenance. The engineers also touch upon the potential for refactoring the system to enhance modularity and scalability, while acknowledging the difficulties and potential risks involved in such an undertaking.
No tracked trend matches for this post yet.
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.