pg-protocol

What is pg-protocol?

The pg-protocol npm package is a low-level library for parsing and serializing the PostgreSQL wire protocol. It is typically used as part of the PostgreSQL client libraries to handle communication with PostgreSQL servers.

What are pg-protocol's main functionalities?

Parsing PostgreSQL messages

This feature allows you to parse messages received from a PostgreSQL server. The `Parser` class emits a 'message' event whenever it successfully parses a message from the provided buffer.

const { Parser } = require('pg-protocol');
const parser = new Parser();
parser.on('message', msg => {
  console.log('Received message:', msg);
});
const buffer = Buffer.from('some binary data from PostgreSQL server');
parser.parse(buffer);

Serializing PostgreSQL messages

This feature allows you to serialize messages to be sent to a PostgreSQL server. The `serialize` function takes a message type and the message content, and returns a buffer that can be sent over the wire.

const { serialize } = require('pg-protocol');
const buffer = serialize('query', 'SELECT * FROM users');
console.log('Serialized buffer:', buffer);

Other packages similar to pg-protocol

pg

The `pg` package is a popular PostgreSQL client for Node.js. It provides a higher-level API for interacting with PostgreSQL databases, including connection pooling, query building, and transaction management. Unlike `pg-protocol`, which focuses on low-level protocol handling, `pg` abstracts away the details of the wire protocol and provides a more user-friendly interface.

pg-promise

The `pg-promise` package is another PostgreSQL client for Node.js that focuses on using promises for asynchronous operations. It provides a rich set of features for query building, transaction management, and connection pooling. Similar to `pg`, it abstracts away the low-level protocol details handled by `pg-protocol` and offers a more convenient API for developers.

node-postgres

The `node-postgres` package, also known as `pg`, is a comprehensive PostgreSQL client for Node.js. It includes support for connection pooling, query streaming, and prepared statements. Like `pg` and `pg-promise`, it provides a higher-level API compared to `pg-protocol`, making it easier to work with PostgreSQL databases without dealing with the wire protocol directly.

README

The README file is missing

Changelog

v1.2.0

• return field metadata on result object: access via result.fields[i].name/dataTypeID