39

Extras

Charmander edited this page 2024-05-16 06:00:05 +00:00

Table of Contents

• Components
• Extensions
• API wrappers
• Database interfaces
• SQL template tags
• Query builders
• Other

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

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.