Planet Scale data retrieval - Node.js on Windows

planet-scale-data-node-js.js

const express = require('express')
const app = express()
const port = 3000

const fs = require('fs');
const mysql   = require('mysql');

app.get('/', (req, res) => {
  res.send('Hello World!')
})

var sql = 'select * from users';

app.get('/users', (req, res) => {
  connection.query(sql, function (err, rows, fields) {
    if (err) throw err

    res.send(rows)
  })
})

app.listen(port, () => {
  console.log(`Example app listening at http://localhost:${port}`)
})

const connection = mysql.createConnection({
    host: 'hostNameHere',
    user: 'userNameHere',
    password: 'passwordHere',
    database: 'dbHere',
    ssl: {
        ca: fs.readFileSync('C:\\temp\\cacert.pem')
    }
  });