mysql2-cache

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

Installation

1npm install mysql2-cache --save

Sample Usage

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

Cache queries

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

Debugging easy

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

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

API

You may use all MySQL2 methods plus:

async q(sql, params = [], cache = false, ttl = undefined)

async insert(table, row)

async update(table, row, where = false)

async delete(table, row, where = false)

stat()

cacheFlush(sql, params)

cacheFlushAll()

cacheStat()

Getting help

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!

Contributing

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.

Getting Started

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:

1npm install

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

1npm test