Getting Started With the Node.js Connector
The MariaDB Node.js Connector is available through the Node.js repositories. You can install it using npm:
$ npm install mariadb
Using ECMAScript, prior to 2017:
const mariadb = require('mariadb'); const pool = mariadb.createPool({ host: 'mydb.com', user:'myUser', password: 'myPassword', connectionLimit: 5 }); pool.getConnection() .then(conn => { conn.query("SELECT 1 as val") .then((rows) => { console.log(rows); //[ {val: 1}, meta: ... ] return conn.query("INSERT INTO myTable value (?, ?)", [1, "mariadb"]); }) .then((res) => { console.log(res); // { affectedRows: 1, insertId: 1, warningStatus: 0 } conn.end(); }) .catch(err => { //handle error conn.end(); }) }).catch(err => { //not connected });
Using ECMAScript 2017:
const mariadb = require('mariadb'); const pool = mariadb.createPool({ host: 'mydb.com', user:'myUser', password: 'myPassword', connectionLimit: 5 }); async function asyncFunction() { let conn; try { conn = await pool.getConnection(); const rows = await conn.query("SELECT 1 as val"); console.log(rows); //[ {val: 1}, meta: ... ] const res = await conn.query("INSERT INTO myTable value (?, ?)", [1, "mariadb"]); console.log(res); // { affectedRows: 1, insertId: 1, warningStatus: 0 } } catch (err) { throw err; } finally { if (conn) return conn.end(); } }
The MariaDB Connector can use different APIs on the back-end: Promise and Callback. The default API is Promise. The callback API is provided for compatibility with the mysql and mysql2 APIs.
Resources
Sponsored by MariaDB