@keyvhq/mysql
@keyvhq/mysql
npm i @keyvhq/mysql
@keyvhq/mysql

@keyvhq/mysql

Simple key-value storage with support for multiple backends.

by microlinkhq

1.6.27 (see all)License:MITTypeScript:Built-In
npm i @keyvhq/mysql
Readme

@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')
})

keyv.on('error', handleConnectionError)

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

No alternatives found
No tutorials found
Add a tutorial
No dependencies found

Rate & Review

100
No reviews found
Be the first to rate