DB-API 2.0

Back to DuckDB Data Engineering Glossary

DB-API 2.0 is a standardized Python interface for accessing relational databases. It defines a set of methods and behaviors that database adapters should implement, allowing Python programmers to write code that can work with different database systems without major modifications. This specification includes guidelines for connecting to databases, executing SQL queries, and handling result sets. By adhering to DB-API 2.0, database libraries ensure compatibility and interoperability across various database management systems, making it easier for developers to switch between databases or work with multiple databases in a single project. Popular database adapters like psycopg2 for PostgreSQL and sqlite3 for SQLite follow this specification, providing a consistent experience for Python developers working with relational data.