Lightweight multi-idiom database API for Node.js.
Install ManyDB:
yarn add manydb
// or
npm install manydbThen install the package for your desired database (choose one):
yarn add pg # PostgreSQL
yarn add mysql # MySQLIt is possible to use multiple different database types, but in most cases only one should be used in order to minimize dependencies.
To use ManyDB, create a database with a config object and connect to it. You can then run queries on the database like normal.
ManyDB currently supports MySQL and PostgreSQL.
import { createDb, POSTGRES } from manydb;
// Create and initialize database
const db = createDb({
type: POSTGRES,
user: 'myuser',
password: 'pass', // optional
host: 'localhost',
database: 'my_db'
});
// Connect to database
db.connect()
.then(() => {
// ...
})
.catch(err => {
// ...
});
// Query
db.query('SELECT * FROM products')
.then(result => {
// ...
})
.catch(err => {
// ...
});You can create a database using the provided createDb function.
Pass in a config object specifying the database details.
| Property | Description |
|---|---|
| type | Type of database to use. (It's recommended to use the provided type constants.) |
| user | Database user. |
| password | Password for user. |
| host | Database host domain. (usually localhost for development) |
| database | Database name. |
// Create and initialize database
const db = createDb({
type: POSTGRES,
user: 'myuser',
password: 'pass', // optional
host: 'localhost',
database: 'my_db'
});You have to connect to the database before using it. Doing this is as simple as:
// Connect
db.connect()
.then(() => {
// ...
})
.catch(err => {
// ...
});
// Disconnect (only if needed)
db.disconnect()
.then(() => {
// ...
})
.catch(err => {
// ...
});Query the database.
// Query
db.query('SELECT * FROM products')
.then(result => {
// ...
})
.catch(err => {
// ...
});
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent