brianc/node-postgres
Node Postgres
This project is a Node.js client for PostgreSQL databases, providing a protocol parser to translate raw binary streams into JavaScript objects. It serves as a driver for executing queries, managing data, and integrating Node.js applications with PostgreSQL backends.
The library includes a connection pool manager to reduce network overhead by caching reusable connections and a result streamer that uses cursors to retrieve large datasets incrementally. It also functions as an event listener for subscribing to asynchronous server-side notifications to trigger real-time application events.
Broad capabilities cover secure database communication via SSL and SASL authentication, as well as data transformation through extensible type coercion. The system supports high-performance operations including bulk data transfers, prepared statements, and the execution of parameterized queries to protect against injection attacks.
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.
- 数据库 - PostgreSQL client.
- Database Drivers - Node.js database driver.
