Extras (original) (raw)

node-postgres is by design pretty light on abstractions. These are some handy modules the community’s been using over the years to complete the picture:

Components

Standalone PostgreSQL packages.

• brianc/node-pg-native - Simple interface abstraction on top of libpq.
• brianc/node-pg-types - Parsing for PostgreSQL serialized formats.
• datalanche/node-pg-format - Safely and easily create dynamic SQL queries with this Node implementation of PostgreSQL format().
• LinusU/pg-error-constants - Error constants for more robust query error handling.
• pg-password-util - Password hashing for PostgreSQL user password operations, avoiding transmission and logging of plaintext passwords in queries.
• vitaly-t/connection-string - Alternative connection string parser implementing superset of MongoDB connection string spec.

Extensions

• brianc/node-pg-cursor - Query cursor extension for node-postgres.
• brianc/node-pg-copy-streams - COPY FROM/COPY TO for node-postgres. Stream from one database to another, and stuff.
• brianc/node-pg-query-stream - Query results from node-postgres as a readable (object) stream.
• emilbayes/pg-ipc - IPC over PostgreSQL LISTEN/NOTIFY/UNLISTEN exposed as an EventEmitter.
• kibae/pg-logical-replication - PostgreSQL logical replication client.
• recursivefunk/pg-gen - Paginate through large result sets with cursors.

API wrappers

• holdfenytolvaj/pogi
• joeandaverde/tinypg - Simpler interface, named parameter support, queries from files, transaction management, events and hooks.
• langpavel/node-pg-async
• sehrope/node-pg-db - Simpler interface, named parameter support, transaction management and event hooks.
• Suor/pg-bricks - A higher-level wrapper around node-postgres to handle connection settings, SQL generation, transactions and ease data access.
• vitaly-t/pg-promise

RxJS:

• haoliangyu/pg-reactive
• jadbox/pg-rxjs

Transactions:

• iceddev/pg-transact

Database interfaces

• grncdr/node-any-db - Thin and less-opinionated database abstraction layer for Node.
• MassiveJS - A simple relational data access tool that has full JSONB document support for PostgreSQL.

SQL template tags

• 131/sql-template
• felixfbecker/node-sql-template-strings - Supports multiple database drivers and named prepared statements.
• sequencework/sql - Tag with convenient querying functions.
• XeCycle/pg-template-tag

Query builders

• brianc/node-sql
• CSNW/sql-bricks
• hiddentao/squel

Other

• acarl/pg-restify - Creates a generic REST API for a PostgreSQL database using restify.
• archfirst/joinjs - A simple library to map the results of complex joins to nested JavaScript objects (alternative to full-blown ORMs).
• brandon-d-mckay/krauter - An Express router that lets queries act as request handlers.
• nuodata/nuodata-db-api - REST API for a PostgreSQL database.
• ozum/pg-generator - Template-based scaffolding for PostgreSQL. Command line utility which generates files for each table and schema of a PostgreSQL database.
• ozum/pg-structure - Node library to get structure of a PostgreSQL database automatically as a detailed object.
• vitaly-t/pg-minify - Minifies PostgreSQL scripts.