brianc/node-postgres

Features

• PostgreSQL Connectors - Provides a specialized Node.js driver for establishing secure connections and executing queries on PostgreSQL instances.
• Binary Protocol Implementations - Implements the PostgreSQL frontend/backend binary wire protocol to translate data streams into JavaScript objects.
• Wire Protocol Serializers - Converts JavaScript objects and SQL strings into the binary format required by the PostgreSQL server.
• Connection Establishment - Handles the initial handshake, authentication, and session initialization with the database server.
• Connection Pools - Implements a connection pool to maintain and reuse database connections, reducing network overhead.
• PostgreSQL Pool Managers - Manages a reusable cache of PostgreSQL connections to reduce network overhead.
• Database Connectivity - Establishes the primary connectivity link between Node.js applications and PostgreSQL database services.
• SQL Query Execution - Provides an interface for the execution and management of SQL queries against a PostgreSQL database.
• Database Query Execution - Executes SQL commands against the database and manages the return of connections to the pool.
• Database Query Interfaces - Provides a direct interface for executing parameterized read and write operations against PostgreSQL.
• Large Dataset Streaming - Retrieves large datasets incrementally using database cursors to prevent application memory overflow.
• Protocol Parsers - Translates raw binary streams from the PostgreSQL wire protocol into structured JavaScript objects.
• Node.js Database Integration - Provides a native Node.js integration for connecting and executing queries against PostgreSQL databases.
• SASL Implementations - Implements secure client-server handshaking using SASL/SCRAM and channel binding.
• Query Parameterization - Uses parameterized queries to separate data from SQL commands, protecting against injection attacks.
• Bulk Data Ingestion - Provides high-performance utilities for importing and exporting large datasets using streaming commands.
• Custom Type Converters - Supports the conversion of specialized database types, such as JSONB and UUIDs, into JavaScript objects.
• Cursor-Based Pagination - Uses cursors to retrieve subsets of rows from massive datasets, ensuring performance and memory stability.
• Data Type Coercion - Maps PostgreSQL-specific data types to JavaScript objects through a customizable coercion system.
• Data Type Mappings - Bridges the type system between PostgreSQL native formats and JavaScript objects through customizable mapping.
• Database Change Listeners - Monitors and reacts to data modifications and events triggered within the database.
• Cursor-Based Result Streamers - Retrieves large datasets incrementally using cursors and readable streams to avoid memory exhaustion.
• Database Event Listeners - Allows applications to listen for asynchronous PostgreSQL notifications to trigger real-time events.
• Prepared Statements - Manages named prepared statements on the server to optimize performance and enhance security.
• Result Streaming - Supports incremental retrieval of large datasets using database cursors to minimize memory consumption.
• Keyspace Event Notifications - Provides mechanisms to subscribe to server-side database events and notifications in real time.
• Secure Communication Protocols - Implements encrypted and authenticated communication protocols to secure data in transit to PostgreSQL.
• Access Authentication - Implements secure client-server handshaking using SASL/SCRAM authentication protocols.
• Identifier Escaping - Escapes SQL identifiers and literals to protect against injection attacks in dynamic queries.
• Secure Connection Handlers - Establishes encrypted communication channels using TLS with support for certificate validation.
• SQL Injection Prevention - Protects against SQL injection by safely formatting dynamic queries and using parameterized values.
• Database Notification Listeners - Functions as an event listener for subscribing to asynchronous PostgreSQL server-side notifications.
• Database Drivers - PostgreSQL client for Node.js.
• Databases - PostgreSQL client.
• Database Drivers - Node.js database driver.

Star history