Comparison with Other APIs#

Equivalent concepts between ADBC and other APIs#

Concept/API

ADBC

database/sql (Golang)

DBAPI 2.0 (PEP 249)

Flight SQL

JDBC

ODBC

Shared connection state

AdbcDatabase

DB

Database connection

AdbcConnection

Conn

Connection

FlightSqlClient

Connection

SQLHANDLE (connection)

Query state

AdbcStatement

Cursor

Statement

SQLHANDLE (statement)

Prepared statement handle

AdbcStatement

Stmt

Cursor

PreparedStatement

PreparedStatement

SQLHANDLE (statement)

Result set

ArrowArrayStream

*Rows

Cursor

FlightInfo

ResultSet

SQLHANDLE (statement)