dbcooper: Turn any database into an R or Python package
summary
dbcooper converts a DBI connection into many small accessor functions so exploring a database feels like working with local tables. One call dbc_init generates prefixed functions like prefix_list, prefix_tbl, prefix_query and prefix_execute, and creates one autocomplete-friendly function per table. R builds on dbplyr, Python uses siuba, and public BigQuery sets (Google lists 239) become easy packages (example: New York Times COVID and stackbigquery). Queries translate to SQL and only collect when needed.
AI-written summary · about
chapters (7)
- 0:00Introduction to DB Cooper
- 2:37Limitations of traditional SQL
- 5:56How DB Cooper works
- 8:51DB Cooper in Python
- 9:47Live demonstration
- 12:15Building internal packages
- 15:36Key takeaways and conclusion
related talks
59mIntroduction to Python Database Programming
17mEasing the pain of connecting to databases
33mturbodbc: Turbocharged Database Access for Data Scientists
20mSiuba and duckdb: Analyzing Everything Everywhere All at Once
24mDeveloping DB Extensions in Python: Examples for SQLite, DuckDB & PostgreSQL
22mDuckDBT: Not a database or a dbt adapter but a secret third thing
59mEmbracing multi-lingual data science
31mExtending SQL Databases with Python