@keyv/mysql
v2.0.2
Published
MySQL/MariaDB storage adapter for Keyv
Downloads
1,729
Maintainers
Readme
@keyv/mysql
MySQL/MariaDB storage adapter for Keyv
MySQL/MariaDB storage adapter for Keyv.
Install
npm install --save keyv @keyv/mysql
Usage
import Keyv from 'keyv';
import KeyvMysql from '@keyv/mysql';
const keyv = new Keyv(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
.
e.g:
import Keyv from 'keyv';
import KeyvMysql from '@keyv/mysql';
const keyv = new Keyv(new KeyvMysql('mysql://user:pass@localhost:3306/dbname'), {
table: 'cache',
keySize: 255
});
SSL
import Keyv from 'keyv';
import KeyvMysql from '@keyv/mysql';
import fs from 'fs';
const options = {
ssl: {
rejectUnauthorized: false,
ca: fs.readFileSync(path.join(__dirname, '/certs/ca.pem')).toString(),
key: fs.readFileSync(path.join(__dirname, '/certs/client-key.pem')).toString(),
cert: fs.readFileSync(path.join(__dirname, '/certs/client-cert.pem')).toString(),
},
};
const keyvMysql = new KeyvMysql('mysql://user:pass@localhost:3306/dbname', options);
const keyv = new Keyv({ store: keyvMysql });