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)