felixge/node-mysql
Node Mysql
This project is a pure JavaScript database driver for Node.js that implements the native MySQL binary protocol. It serves as a comprehensive connector for managing persistent network links to MySQL servers, enabling applications to execute queries, manage transactions, and handle complex data operations without requiring external middleware.
The driver distinguishes itself through its integrated support for connection pooling and distributed database routing. It maintains managed sets of reusable network sockets to optimize resource usage under high request volumes, while simultaneously providing automated clustering capabilities to distribute traffic across multiple server nodes. These features are complemented by built-in security mechanisms, including template-based query sanitization and identifier escaping, which protect against injection vulnerabilities by automatically handling input formatting.
Beyond core connectivity, the library provides extensive support for memory-efficient data handling through stream-based result processing, allowing large datasets to be consumed row by row. It also includes robust observability and lifecycle management tools, such as communication tracing, connection health verification, and event-based monitoring for session states. The driver further supports advanced database interactions, including multi-statement execution, stored procedure handling, and secure data transmission via encrypted protocols.
Features
- MySQL Connectors - Implements the native MySQL binary protocol to enable Node.js applications to execute queries and manage database connections.
- Node.js Connectors - Connects Node.js applications to MySQL servers to execute queries, manage transactions, and handle data retrieval through a native protocol.
- Connection Establishment - Establishes persistent network links to database servers using host details and authentication credentials to ensure reliable data access.
- Connection Pools - Maintains a set of reusable database connections to optimize resource usage and handle high request volumes in web applications.
- Parameterized SQL Templates - Prevents injection vulnerabilities by automatically escaping and binding user-provided values into SQL templates before transmission to the server.
- Binary Protocols - Communicates directly with the database server using its binary wire protocol to eliminate the need for external middleware.
- Database Connection Managers - Maintains a managed set of reusable network sockets to optimize resource usage and handle high volumes of concurrent database requests.
- Database Transaction Wrappers - Provides mechanisms for wrapping multiple database queries within a single transaction session to ensure atomicity and data consistency.
- Connection Pool Managers - Maintains a collection of reusable database connections with configurable limits and queuing behavior to optimize resource usage.
- Database Wire Protocol Implementations - Communicates directly with the database server using its binary wire protocol without requiring external client libraries or middleware.
- Placeholder-Based SQL Templates - Constructs secure query strings by injecting values into placeholders and applying automatic escaping to prevent injection.
- Connection Pooling - Maintains a managed set of reusable network sockets to minimize the overhead of repeatedly establishing new database connections.
- Relational Database Connectors - Establishes persistent network connections to relational databases for reliable data exchange and transaction management.
- SQL Query Execution - Executes SQL statements and retrieves structured results including metadata like affected row counts and generated IDs.
- Input Sanitization - Cleans and validates user-provided data to prevent SQL injection attacks through automatic escaping and placeholder substitution.
- SQL Injection Prevention - Sanitizes user inputs and escapes query identifiers to ensure database commands are executed safely and protected against malicious injection attacks.
- Cluster Connectivity - Distributes incoming database requests across multiple server nodes and automatically removes unresponsive nodes from the rotation.
- Asynchronous Callbacks - Processes database operations using non-blocking callbacks to handle concurrent requests without stalling the main application thread.
- Connection Health Maintenance - Performs automatic validation of database connections to ensure they remain active and responsive.
- Distributed Databases - Distributes database requests across multiple server nodes to improve performance and ensure high availability through automated connection clustering.
- Result Streaming - Provides memory-efficient incremental retrieval of database rows to handle large datasets without exhausting system memory.
- Row-Based Result Streaming - Exposes query results as readable streams to allow memory-efficient handling of large datasets by processing rows as they arrive.
- SQL Query Builders - Provides utilities for constructing and sanitizing SQL queries to prevent injection vulnerabilities.
- Batch Statement Execution - Executes multiple SQL commands within a single request to process complex data operations efficiently.
- Stored Procedures - Executes pre-defined database routines and processes multiple returned result sets using a consistent interface.
- Connection Termination - Closes a connection to the database by finishing pending queries gracefully or by immediately destroying the underlying socket.
- Connection Lifecycle Managers - Opens and gracefully closes database sessions, ensuring all pending operations complete before terminating the network link to the server.
- Identifier Escaping - Sanitizes database, table, and column names to ensure they are treated as literal identifiers and prevent injection.
- SSL/TLS Connection Security - Implements secure transport layers using SSL or TLS to encrypt database traffic between clients and servers.
- Cluster Load Balancing - Distributes database traffic across multiple server nodes by monitoring connection health and routing queries based on configurable selection strategies.
- Database Drivers - Provides a driver for interacting with relational databases.
