SQL API
SQL API consists of a library of function calls as an application programming interface (API) for the DBMS.
基本操作示例:
App to DBMS:
CONNECT(db, user, pswd)
SEND("update empoyees set..")
EXECUTE()
STATUS_CHECK()
DBMS to App:
OK
App to DBMS:
DISCONNECT()
Application or Database | SQL API |
---|---|
MySQL | MySQL C API |
PostgreSQL | psycopg2 |
IBM DB2 | ibm_db |
SQL Server | dblib API |
Database access for MS Windows | ODBC |
Oracle | O |