At ClickHouse, the company revisited the comparison between OLTP databases like Postgres and OLAP databases like themselves to help developers understand when to use each for an application. They demonstrated how to enrich an application built with Supabase using real-time analytics powered by ClickHouse and integrated using Foreign Data Wrappers (FDWs). The demo showed how users can query ClickHouse from a Supabase instance, integrate real-time analytics into the application without leaving the familiar Supabase ecosystem, and use FDWs to communicate through a single interface. To achieve this, they used Postgres as an OLTP database for transactional data and ClickHouse as an OLAP database for analytical queries. The company also discussed best practices when using FDWs with ClickHouse, including parameterized views and pushing query push-down. They concluded by explaining how to update analytics data in ClickHouse periodically, either by inserting rows into the table or pulling rows from a Supabase instance.