✔ MySQL2 upgrade: cache queries, easy shortcuts, logging and debugging.

npm install mysql2-cache --save

const mysql = require('mysql2-cache')
const db = mysql.connect({
  host: 'localhost',
  user: 'root',
  database: 'test',
  password: 'root'
})
db.q('SELECT * FROM test_table').then(res => console.dir)

const mysql = require('mysql2-cache')
const db = mysql.connect({
  host: 'localhost',
  user: 'root',
  database: 'test',
  password: 'root'
})
db.q('SELECT * FROM test_table WHERE id=?', 1, true) // use cache with default ttl=300s
db.q('SELECT * FROM test_table WHERE id=?', 1, true, 300) // ttl in seconds

Pass DEBUG=mysql2-cache* environment variable to pretty debug.

  mysql2-cache:1 SELECT * FROM test_table WHERE age > ? [1] +0ms
  mysql2-cache:1 ┌─────────┬─────────┬─────┐
  mysql2-cache:1 │ (index) │  name   │ age │
  mysql2-cache:1 ├─────────┼─────────┼─────┤
  mysql2-cache:1 │    0    │ 'Alice' │ 90  │
  mysql2-cache:1 │    1    │  'Bob'  │ 42  │
  mysql2-cache:1 └─────────┴─────────┴─────┘
  mysql2-cache:1  +32ms

You may use all MySQL2 methods plus:

If you've found a bug in the library or would like new features added, go ahead and open issues or pull requests against this repo!

Bug fixes, docs, and library improvements are always welcome. Please refer to our Contributing Guide for detailed information on how you can contribute. If you're not familiar with the GitHub pull request/contribution process, this is a nice tutorial.

If you want to familiarize yourself with the project, you can start by forking the repository and cloning it in your local development environment. The project requires Node.js to be installed on your machine.

After cloning the repository, install the dependencies by running the following command in the directory of your cloned repository:

npm install

You can run the existing tests to see if everything is okay by executing:

npm test