PGx

Pgx is a PostgreSQL driver and toolkit for the Go programming language. It is developed as part of the pgx project and maintained by the Go community, with core contributors including Jack Christensen (jackc). Pgx provides both a native Go API for PostgreSQL and a database/sql driver, allowing code to talk to PostgreSQL either directly via the pgx interface or through the standard Go sql.DB abstraction.

Pgx is designed for performance and feature completeness. It implements the PostgreSQL wire protocol with support for the text and binary data formats, extended query protocol, and prepared statements. It also includes a built-in connection pool (pgxpool) and optional replication protocol support via a separate replication interface. Additional features include COPY in and out, LISTEN/NOTIFY, and comprehensive type support for PostgreSQL types such as JSON/JSONB, hstore, arrays, and time/date types.

Pgx can be used in two ways: as a native library using its own API (pgx) for maximum control and performance, or via the database/sql interface through the pgx driver for broader compatibility with existing code. The pgxpool package offers configurable connection pooling tuned for PostgreSQL workloads.

History and status: pgx has evolved through several major versions, with v5 representing a recent, actively maintained line. It is widely used in Go projects that require low-latency access to PostgreSQL and advanced PostgreSQL features. Documentation and examples are available on the project's repository and website.

See also: PostgreSQL, Go, database/sql.