multi-db-manager

Simple manager for multiple databases as one

Usage no npm install needed!

<script type="module">
  import multiDbManager from 'https://cdn.skypack.dev/multi-db-manager';
</script>

README

MultiDB Manager

Install with

$ npm i multi-db-manager

Manage your databases multiple at once! Make one query and get result from all databases

How to use?

const MultiDB = require('multi-db-manager');
const db = new MultiDB({
    provider: 'mysql',
    databases: [
        { host: '127.0.0.1', username: 'root', password: '', database: 'chinook' },
        { host: 'some-host', username: 'some-username', password: 'some-password', database: 'some-db' }
    ]
});

// Now use it!
let rows = await db.query(sql, params);
// Example:
let rows = await db.query('SELECT * FROM users WHERE id = ?', [ 1 ]);

// To insert query use
await db.insert("INSERT INTO users (id, nickname, password) VALUES (?, 'Luminate_', '12345678')", 'users', [ 1 ]);

MIT License