Database Drivers
Libraries that connect Python to a specific database.
This is an overview — pick a sub-topic below.
Sub-topics (10)
sqlite3
The built-in driver for SQLite, a full SQL database in a single file.
psycopg and asyncpg
PostgreSQL drivers: psycopg 3 (sync + async, the standard) and asyncpg (very fast async).
PyMySQL and mysqlclient
MySQL/MariaDB drivers — pure Python (PyMySQL) or C-based and faster (mysqlclient).
cx_Oracle / python-oracledb and pyodbc
Oracle Database driver (python-oracledb, successor of cx_Oracle) and ODBC access to SQL Server and others (pyodbc).
PyMongo and Motor
MongoDB drivers: PyMongo (sync) and Motor (async).
redis-py
Client for Redis — in-memory key-value store used for caching, queues, rate limits and pub/sub.
Cassandra, Neo4j, Elasticsearch and OpenSearch Clients
Drivers for wide-column (cassandra-driver), graph (neo4j), and search engines (elasticsearch-py, opensearch-py).
DuckDB
An in-process analytical SQL database — query CSV, Parquet and pandas DataFrames at high speed.
InfluxDB, TimescaleDB and ClickHouse Clients
Clients for time-series and analytical databases.
Supabase and Firebase Admin SDKs
Python clients for hosted backends: Supabase (Postgres + auth + storage) and Firebase (Firestore, auth, messaging).
Spotted a mistake or want to add detail? Suggest an improvement — Content Contributors' edits are reviewed by editors before they go live.
Discussion (0)
Sign in or join free to ask questions and discuss this topic.