porsager/postgres

Features

• PostgreSQL Connectors - Serves as a low-level PostgreSQL client library with support for failover hosts, rotating credentials, and custom sockets.
• SQL Query Builders - Provides a programmatic interface for constructing complex, dynamic SQL queries through a builder.
• PostgreSQL Bulk Importers - Exposes a high-performance bulk copy command as readable and writable streams for importing and exporting large datasets.
• Database Connection Managers - Provides a comprehensive system for managing connection pooling, failover hosts, and dynamic authentication.
• Connection Pool Managers - Manages database connection lifecycles with pooling, failover host support, and isolated session reservation.
• Logical Replication Ingestion - Implements the logical replication protocol to stream real-time database change notifications and row-level updates.
• Database Transaction Management - Implements transaction lifecycle control with automatic commit and rollback support for atomic database operations.
• Dynamic Fragments - Provides tools for building dynamic SQL statements by conditionally nesting fragments and generating column lists at runtime.
• Connection Pooling - Manages a set of reusable database connections with the ability to reserve isolated sessions for transactional consistency.
• Query Parameterization - Implements parameterized query execution using template literals to prevent SQL injection attacks.
• SQL Query Builders - Provides a query builder that uses tagged template literals to serialize parameters and compose SQL fragments.
• Transaction Management - Implements comprehensive transaction management with automatic commit, rollback, and savepoint support.
• Bulk Data Operations - Supports inserting or updating multiple rows in a single query by passing arrays of objects to the builder.
• Session Reservations - Provides the ability to reserve a single connection from the pool to ensure sequential queries run on the same session.
• Custom Data Types - Provides a system to map database identifiers to objects using custom serialization and parsing functions.
• Data Change Subscriptions - Supports real-time monitoring of database insert, update, and delete operations via logical replication.
• Custom Type Serializers - Enables mapping of database type identifiers to custom JavaScript functions for automated data parsing and encoding.
• Database Event Listeners - Includes a dedicated connection mechanism for listening to real-time database notifications with automatic reconnection.
• Dynamic Row Insertion - Provides the ability to add rows using objects or arrays without manually specifying individual column names.
• Large Dataset Streaming - Implements high-performance streaming of large datasets using the database copy command to optimize memory usage.
• Result Streaming - Enables memory-efficient processing of large result sets via row-by-row streaming and cursors.
• Real-time Data Synchronization - Facilitates real-time data synchronization using logical replication protocols and channel-based notifications.
• Replication Clients - Implements a logical replication client to monitor real-time database changes and event streams.
• Database Failover Management - Supports high availability by attempting connections to a list of hosts for failover and primary host restriction.
• Connection Managers - Supports flexible connection configuration via URL strings or option objects with environment variable fallbacks.
• Database Drivers - Node.js database driver.

Star history