Breakout Session
summary
Prestogres implements the PostgreSQL protocol so BI tools speak Postgres while queries run on Presto, rewriting SQL inside pgpool-II + PL/Python and creating faked system catalogs and temp types on the fly. It connects Chartio and other ODBC/JDBC clients, proves the gateway approach works, and exposes limits: no true transactions, limited prepared-statement/extended-query support, and headaches around temporary tables and type mapping. Code is open source and demonstrated end-to-end.
AI-written summary · about
chapters (17)
- 0:00Intro
- 0:11About Sadayuki
- 1:55Problems
- 6:25Architecture
- 8:45connectors
- 14:12Problem
- 15:42PressOS
- 17:55Foreign Data
- 19:23System Catalogs
- 20:22Solution
- 21:32Review
- 27:33Demo
- 30:54Multiple Select Statements
- 31:51Cursors
- 32:19Error Handling
- 33:02Fake Builtin Functions
- 34:26Future Work
related talks
22mIntroduction to Presto: The SQL Engine for Data Platform Teams
46mPresto - Today and Beyond - The Open Source SQL Engine for Querying all Data Lakes
22mPresto for Your Fast, Open SQL Lakehouse
49mPostgreSQL - the database-sister of Python
47mPostgres & Beyond
51mScaling Postgres to the next level at OpenAI
51mWhen Postgres Can't, You Can!
34mAnalytics and AI with PostgreSQL - Mission Possible!