sidorares/node-mysql2
Node Mysql2
This project is a MySQL database driver for Node.js that establishes network connections and executes SQL queries using a native communication protocol. It functions as an asynchronous SQL client, providing a promise-based query interface and support for async/await patterns to manage non-blocking database operations.
The library includes a full MySQL protocol implementation, serving as a toolkit for building custom database servers, proxies, or clients. It also operates as a connection pool manager and an injection prevention tool, utilizing prepared statements and parameterized queries to secure database interactions.
The project covers a broad range of database integration capabilities, including atomic transaction coordination, binary log streaming, and tabular data streaming for bulk imports. It manages resource lifecycles through automated connection cleanup and provides various authentication mechanisms, such as password hash authentication and secure handshake negotiation.
Connectivity is further supported via SSL encryption, network traffic compression, and the ability to route traffic through custom duplex stream transports.
Features
- MySQL Connectors - Provides a specialized Node.js driver for establishing secure network connections and executing queries on MySQL databases.
- MySQL Integrations - Establishes network connections to a MySQL database to execute queries and manage data storage in Node.js.
- Node.js Connectors - Implements a native MySQL database driver specifically for the Node.js runtime environment.
- Connection Pools - Manages a cache of reusable MySQL connections to reduce latency and improve application performance.
- Protocol Packet Parsers - Implements the MySQL wire protocol to decode raw binary network streams into structured data packets.
- Connection Pool Managers - Manages groups of database connections with support for cluster routing and graceful shutdown procedures.
- Database Query Execution - Executes SQL queries and retrieves data using the native MySQL communication protocol.
- Promise-Wrapped Querying - Provides a promise-wrapped interface for database queries to enable asynchronous control flow using async/await.
- MySQL Connection Poolers - Provides a dedicated manager for reusable MySQL database connections to optimize session establishment and reduce latency.
- Prepared Statements - Supports parameterized queries to increase execution speed and protect the database from injection attacks.
- Promise-Based SQL Clients - Provides a database interface with promise-based query execution and async/await support.
- SQL Query Execution - Sends SQL statements to a database and processes returned results using asynchronous JavaScript patterns.
- Connection Pooling - Reduces latency and overhead by reusing existing network connections for multiple database requests.
- MySQL Protocol Implementations - Provides a full implementation of the MySQL network protocol for building custom proxies or servers.
- Async-Await Flow Control - Implements async and await syntax to simplify the logic of asynchronous database control flows.
- Query Parameterization - Implements prepared statements to separate query logic from data, preventing SQL injection attacks.
- SQL Injection Prevention - Secures database interactions against malicious input using prepared statements and parameterized queries.
- Binary Log Streaming Tools - Interfaces with the binary log protocol to replicate data changes and track database events in real-time.
- Atomic Transaction Coordinators - Coordinates sequences of operations through start, commit, and rollback commands to ensure atomic changes.
- Read-Write Splitting - Coordinates multiple connection pools across different servers to implement load balancing and read/write splitting.
- MySQL Clustering Systems - Distributes database workloads across multiple servers to implement load balancing and read-write splitting.
- Query Execution Engines - Processes database queries and converts returned results into specific data types for application use.
- SQL Placeholder Bindings - Maps query parameters to object keys and converts them into positional placeholders for secure execution.
- Disposable Resource Management - Uses explicit disposal symbols to automatically release network sockets and clear memory when connections go out of scope.
- Scope-Based Resource Cleanup - Automatically releases database connections and pools when they go out of scope using explicit resource management.
- SQL Injection Prevention Tools - Prevents SQL injection attacks through the use of prepared statements and parameterized queries.
- Tabular Data Import - Streams local tabular data into the database using a readable stream factory for efficient bulk imports.
- Connection Lifecycle Managers - Tracks the state of active network sockets and uses disposal symbols to release system resources.
- Pool Clustering - Supports grouping multiple independent connection pools to distribute queries across different database nodes for load balancing.
- Database Session Management - Manages the establishment, termination, and resetting of individual sessions with the database server.
- Protocol Negotiation - Exchanges initialization packets with clients to negotiate protocol versions and feature flags.
- Server Instance Listeners - Allows starting a server instance that listens on a port or unix socket to accept incoming database connections.
- Handshake Protocols - Performs secure handshakes using the server's preferred authentication method and configurable encryption contexts.
- Database Connection Encryption - Secures the communication channel between the application and the database server using SSL/TLS encryption.
- Feature Flag Negotiations - Exchanges initialization packets and feature flags to determine authentication and compression settings during the handshake.
- Input Sanitization - Escapes values and identifiers to treat user input as data rather than executable code, preventing injection.
- Database Protocol Proxies - Enables building server interfaces and routing traffic through custom transports using the MySQL protocol.
- Databases - Fast MySQL driver with compatibility.
