cometkim/mysql2es

Port of node-mysql2 that ensures ESM compatibilty.

MySQL2 ES

MySQL client for Node.js with focus on performance. Supports prepared statements, non-utf8 encodings, binary log protocol, compression, ssl much more.

About this fork

This is fork of node-mysql2, ported for ESM-first project compatibility.

And there are more modifications:

• Use promisified interface by default
• Replace dependencies with native features as possible
  • long -> native BigInt
  • bluebird -> native Promise
• Replace dependencies with better implementations
  • lru.min -> flru
• Embed old dependencies that are only provide CommonJS.
  • aws-ssl-profiles -> mysql2es/aws-ssl-profiles

Use this package as a drop-in replacement for the existing mysql2/promise.

Table of Contents

• History and Why MySQL2
• Installation
• Documentation
• Acknowledgements
• Contributing

History and Why MySQL2

MySQL2 project is a continuation of MySQL-Native. Protocol parser code was rewritten from scratch and api changed to match popular Node MySQL. MySQL2 team is working together with Node MySQL team to factor out shared code and move it under mysqljs organization.

MySQL2 is mostly API compatible with Node MySQL and supports majority of features. MySQL2 also offers these additional features:

• Faster / Better Performance
• Prepared Statements
• MySQL Binary Log Protocol
• MySQL Server
• Extended support for Encoding and Collation
• Promise Wrapper
• Compression
• SSL and Authentication Switch
• Custom Streams
• Pooling

Installation

MySQL2 is free from native bindings and can be installed on Linux, Mac OS or Windows without any issues.

npm install --save mysql2

If you are using TypeScript, you will need to install @types/node.

npm install --save-dev @types/node

For TypeScript documentation and examples, see here.

Documentation

• Quickstart
  • First Query, Using Prepared Statements, Using Connection Pools and more.
• Documentation
• Examples
• FAQ

Acknowledgements

• Internal protocol is written by @sidorares MySQL-Native.
• Constants, SQL parameters interpolation, Pooling, ConnectionConfig class taken from Node MySQL.
• SSL upgrade code based on @TooTallNate code.
• Secure connection / compressed connection api flags compatible to MariaSQL client.
• Contributors.

Contributing

Want to improve something in MySQL2? Please check Contributing.md for detailed instruction on how to get started.

To contribute in MySQL2 Documentation, please visit the Website Contributing Guidelines for detailed instruction on how to get started.