Node-Postgres Client (pg)

pg (node-postgres) is a robust and non-blocking PostgreSQL client for Node.js, providing both a pure JavaScript implementation and optional native `libpq` bindings, both exposing the exact same API. Currently at version 8.20.0, the library maintains an active development pace with regular updates and bug fixes, indicated by its consistent major version releases and community support. Key features include efficient connection pooling, extensible data-type coercion between JavaScript and PostgreSQL types, support for parameterized queries to prevent SQL injection, named statements with query plan caching, and asynchronous notifications via `LISTEN/NOTIFY`. It also facilitates bulk data operations using `COPY TO/COPY FROM`. Its design prioritizes being a light abstraction layer, encouraging users to leverage companion modules for higher-level ORM or query building needs.