Apache Superset is a modern, open source BI platform that can talk to just about any SQL speaking database. While many BI tools opted for the technical strategy of building highly native connector libraries to support each database, the Superset project decided to bet on the SQLAlchemy ORM and the Python DB-API 2.0 spec to support many databases without much custom code.
I provide an overview of these ideas in this blog post (https://preset.io/blog/building-database-connector/) but I’d like to go much, much deeper in this conference talk and hopefully convince more database creators out there to bet on these same platforms and specs. To really drive the point home, I will also live code and add in support for a new database in Superset “on stage”.
Speaker: Srini Kadamati – Preset.io
