sidorares/node-mysql2

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.

Star history