@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

/@keyvhq/mysql/

    Package Sidebar

    Install

    npm i @keyvhq/mysql

    Homepage

    keyv.js.org

    Weekly Downloads

    58

    Version

    2.1.1

    License

    MIT

    Unpacked Size

    5.28 kB

    Total Files

    5

    Last publish

    Collaborators

    • kikobeats
    • jytesh