mysql node

configure-mariadb.js

const mariadb = require('mariadb');
const pool = mariadb.createPool({
     host: 'mydb.com', 
     user:'myUser', 
     password: 'myPassword',
     connectionLimit: 5
});

configure-mysql.js

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db'
});

get-route.js

app.get("/crew", (req, res) => {
  const query = "select name, job from crewmates";
  connection.query(query, (error, results, fields) => {
    if (error) throw error;
    console.log("Résultat", results);
    res.json(results);
  });
});

post.js

app.post("/crew", (req, res) => {
  const query = "INSERT INTO crewmates SET ?";
  const value = { name: req.body.name, job: req.body.job };
  connection.query(query, value, (error, results, fields) => {
    if (error) throw error;
    console.log("Résultat de l'insert", results);
    res.sendStatus(200);
  });
});

post.txt

POST http://localhost:3000/crew
Content-Type: application/json

{"name": "sprirou", "job": "impostor"}