mysqljs/mysql
Mysql
This project is a MySQL database driver and client for Node.js. It provides a JavaScript implementation of the MySQL protocol to facilitate connecting to, querying, and managing data within MySQL databases.
The driver includes a connection pool manager to maintain a cache of reusable database connections, reducing the overhead of frequent network handshakes. It also supports row-by-row result streaming to process large datasets without loading entire result sets into memory.
Core capabilities cover SQL query execution, the management of database transactions, and the coordination of multiple database hosts. The project includes tools for SQL injection prevention through the sanitization of query inputs and the escaping of identifiers and values. Additionally, it handles data type casting between the database and JavaScript and provides utilities for server monitoring, such as heartbeat pings and statistics retrieval.
Features
- MySQL Connectors - Provides a specialized driver to establish network connections to MySQL servers.
- Node.js Database Integration - Provides a full JavaScript implementation of the MySQL protocol for Node.js applications.
- Connection Establishment - Opens communication channels to database servers using host and credential details.
- Connection Pools - Implements a connection pool manager to maintain a cache of reusable database connections.
- Connection Pool Managers - Maintains a cache of reusable connections to reduce the overhead of frequent network handshakes.
- SQL Query Execution - Sends SQL statements to the database and processes results through callbacks or options.
- Database Connections - Manages the lifecycle of database connections, including graceful shutdown and destruction.
- Database Transactions - Wraps multiple commands in atomic transactions using begin, commit, and rollback functions.
- Binary Protocol Implementations - Implements the binary MySQL communication protocol using native Node.js buffers and sockets.
- Result Streaming - Processes database packets as a stream to handle large result sets without memory exhaustion.
- SQL Query Interfaces - Provides an interface for executing raw SQL commands and processing results via callbacks or streaming.
- Socket Networking - Handles asynchronous request and response cycles by reading and writing raw binary packets over TCP sockets.
- SQL Injection Prevention - Secures database queries against SQL injection through input sanitization and identifier escaping.
- Data Type Casting - Provides a configurable transformation layer to map MySQL binary data types to JavaScript objects.
- Database Host Distribution - Distributes connection requests across multiple database hosts using strategies like Round-Robin or Random.
- Connection and Session Management - Tracks active session and thread identity on a per-socket basis to manage user switching and transaction scopes.
- Database Drivers - MySQL client for Node.js.
- Baze de date - MySQL client for Node.js.
- Database Connectors - Implements the MySQL protocol for Node.js.
