turbodbc: Turbocharged Database Access for Data Scientists
summary
Turbodbc provides a Python DB-API 2.0–compatible client that uses standard ODBC drivers to fetch column-oriented results directly into NumPy arrays and Apache Arrow tables via binary-transfer APIs. The talk explains the data flow from ODBC driver to in-memory arrays, shows implementation and integration choices (including code), and presents benchmarks across several databases demonstrating significant speedups for bulk column loads compared with native Python drivers.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 2:20Traditional access problems
- 10:07Key features
- 17:54Performance benefits
- 25:21Implementation and use cases
- 31:13Future developments
related talks
31mODBC takes an Arrow to the knee: ADBC
01h 04mWhere We’re Going, We Don’t Need Rows: Columnar Data Connectivity with Apache Arrow ADBC
41mFaster SQL with pandas and Apache Arrow
39mPython and SQL: Better Together, Powered by DuckDB
30mDuckDB: Bringing analytical SQL directly to your Python shell
33mArrow in Flight - New Developments in Data Connectivity
35mPractical Applications of Apache Arrow
37mHyperrest: A new Apache Arrow API For High Performance Data...