⚡️ fast node-mysql compatible mysql driver for node.js
JavaScript Other
Latest commit 69317cf Mar 25, 2017 @sidorares committed on GitHub Merge pull request #529 from sidorares/greenkeeper-husky-0.13.3
husky@0.13.3 breaks build 🚨

README.md

Node MySQL 2

NPM Version NPM Downloads Node.js Version Linux Build Windows Build License

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

NPM NPM

Table of contents

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 mysqljs/mysql. MySQL2 team is working together with mysqljs/mysql team to factor out shared code and move it under mysqljs organisation.

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

Installation

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

npm install --save mysql2

First Query

// get the client
var mysql = require('mysql2');

// create the connection to database
var connection = mysql.createConnection({host:'localhost', user: 'root', database: 'test'});

// simple query
connection.query('SELECT * FROM `table` WHERE `name` = "Page" AND `age` > 45', function (err, results, fields) {
  console.log(results); // results contains rows returned by server
  console.log(fields); // fields contains extra meta data about results, if available
});

// with placeholder
connection.query('SELECT * FROM `table` WHERE `name` = ? AND `age` > ?', ['Page', 45], function (err, results) {
  console.log(results);
});

Using Prepared Statements

With MySQL2 you also get the prepared statements. With prepared statements MySQL doesn't have to prepare plan for same query everytime, this results in better performance. If you don't know why they are important, please check these discussions

MySQL provides execute helper which will prepare and query the statement. You can also manually prepare / unprepare statement with prepare / unprepare methods.

// get the client
var mysql = require('mysql2');

// create the connection to database
var connection = mysql.createConnection({host:'localhost', user: 'root', database: 'test'});

// execute will internally call prepare and query
connection.execute('SELECT * FROM `table` WHERE `name` = ? AND `age` > ?', ['Rick C-137', 53], function (err, results, fields) {
  console.log(results); // results contains rows returned by server
  console.log(fields); // fields contains extra meta data about results, if available

  // If you execute same statement again, it will be picked form a LRU cache
  // which will save query preparation time and give better performance
});

Using Promise Wrapper

MySQL2 also support Promise API. Which works very well with ES7 async await.

// get the client
let mysql = require('mysql2/promise');

// create the connection
let connection = await mysql.createConnection({host:'localhost', user: 'root', database: 'test'});

// query database
let [rows, fields] = await connection.execute('SELECT * FROM `table` WHERE `name` = ? AND `age` > ?', ['Morty', 14]);

MySQL2 use default Promise object available in scope. But you can choose which Promise implementation you want to use

// get the client
let mysql = require('mysql2/promise');

// get the promise implementation, we will use bluebird
let bluebird = require('bluebird');

// create the connection, specify bluebird as Promise
let connection = await mysql.createConnection({host:'localhost', user: 'root', database: 'test', Promise: bluebird});

// query database
let [rows, fields] = await connection.execute('SELECT * FROM `table` WHERE `name` = ? AND `age` > ?', ['Morty', 14]);

API and Configuration

MySQL2 is mostly API compatible with Node MySQL. You should check their API documentation to see all available API options.

If you find any incompatibility with Node MySQL, Please report via Issue tracker. We will fix reported incompatibility on priority basis.

Documentation

You can find more detailed documentation here. You should also check various code examples to understand advanced concepts.

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 node-mysql2. Please check Contributing.md for detailed instruction on how to get started.