@keyvhq/mysql
TypeScript icon, indicating that this package has built-in type declarations

2.1.1 • Public • Published

@keyvhq/mysql keyv

MySQL/MariaDB storage adapter for Keyv.

Install

npm install --save @keyvhq/core @keyvhq/mysql

Usage

const KeyvMysql = require('@keyvhq/redis')
const Keyv = require('@keyvhq/core')

const keyv = new Keyv({
  store: new KeyvMysql('mysql://user:pass@localhost:3306/dbname')
})

You can specify a custom table with the table option and the primary key size with keySize:

const KeyvMysql = require('@keyvhq/redis')
const Keyv = require('@keyvhq/core')

const keyv = new Keyv({
  store: new KeyvMysql('mysql://user:pass@localhost:3306/dbname', {
    table: 'cache',
    keySize: 255
  })
})

Note: Some MySQL/MariaDB installations won't allow a key size longer than 767 bytes. If you get an error on table creation try reducing keySize to 191 or lower.

License

@keyvhq/mysql © Luke Childs, released under the MIT License.
Maintained by Microlink with help from contributors.

microlink.io · GitHub microlinkhq · Twitter @microlinkhq

Package Sidebar

Install

npm i @keyvhq/mysql

Homepage

keyv.js.org

Weekly Downloads

56

Version

2.1.1

License

MIT

Unpacked Size

5.28 kB

Total Files

5

Last publish

Collaborators

  • kikobeats
  • jytesh