In the context of databases, a driver (or database driver) is a piece of software that acts as an intermediary between an application and a database. It translates the application's requests for database access into a protocol that the database understands, and then translates the database's responses back to the application.
Most drivers are either built directly on (the official C library) or re-implement the protocol natively. libpq provides:
| Driver | Time (ms) | CPU Usage | Memory | |--------|-----------|-----------|--------| | psycopg2 (sync) | 890 | 18% | 32 MB | | psycopg3 (async) | 720 | 15% | 28 MB | | pgx (Go) | 410 | 12% | 18 MB | | node-postgres | 950 | 22% | 48 MB | driver postgresql
Test environment: PostgreSQL 15, 4 vCPU, 8 GB RAM. Lower is better.
A typical PostgreSQL driver consists of three layers: In the context of databases, a driver (or
PostgreSQL, often simply called Postgres, is one of the world's most advanced and reliable open-source object-relational database systems. For any application to communicate with a PostgreSQL database, it requires a —a software component that acts as a bridge, translating application code into a language the database understands.
Understanding PostgreSQL Drivers: The Essential Guide for Developers libpq provides: | Driver | Time (ms) |
This guide explores the most common PostgreSQL drivers, how they work, and how to choose the right one for your project. What is a PostgreSQL Driver?