DB-API x database module

104 views Asked by At

What is a DB-API (Python) and what is a database module and how do they interact ?

I have a TCC project and I need to understand the difference and the purpose of these terms. I thought DB-API was, for example, a driver like psycopg2 but psycopg2 is a driver and has another purpose. If I'm wrong, correct me.

1

There are 1 answers

0
AKX On BEST ANSWER

DB-API is a specification that SQL database modules written in Python adhere to.

  • psycopg2 is a DB-API compliant module for PostgreSQL,
  • mysqlclient is a DB-API compliant module for MySQL,
  • cx_Oracle is a DB-API compliant module for Oracle,

etc.