Orders

Orders is a web application that introduces you to the power, performance, and simplicity of MariaDB by simulating online eCommerce (ordering) traffic.

This application is made of two parts:

• Client
  • web UI that communicates with REST endpoints available through an API app (see below).
  • is a React.js project located in the client folder.
• API
  • uses the MariaDB Node.js Connector to connect to MariaDB.
  • is a Node.js project located in the api folder.

This README will walk you through the steps for getting the Orders web application up and running using MariaDB.

Table of Contents

1. Requirements
2. Getting started with MariaDB
3. Get the code
4. Create the database and table
5. Getting started
   1. Configure
   2. Build and run the API app
   3. Build and run the Client app
6. Requirements to run the app
7. Support and contribution
8. License

Requirements

This sample application requires the following to be installed/enabled on your machine:

• Node.js (v. 12+)
• NPM (v. 6+)
• MariaDB command-line client (optional), used to connect to MariaDB database instances.

1.) Getting Started with MariaDB

MariaDB is a community-developed, commercially supported relational database management system, and the database you'll be using for this application.

If you don't have a MariaDB database up and running you can find more information on how to download, install and start using a MariaDB database in the MariaDB Quickstart Guide.

2.) Get the code

Download this code directly or use git (through CLI or a client) to retrieve the code using git clone:

$ git clone https://github.com/mariadb-developers/orders-app-nodejs.git

3.) Create the database and table

Connect to your MariaDB database and execute the following:

$ mariadb --host host_address --port #### --user user_name -p**** < schema.sql

or executing the SQL within (schema.sql)(schema.sql) directly

CREATE DATABASE orders;

CREATE TABLE orders.orders (
  description varchar(25) 
) ENGINE=InnoDB;

4.) Configure, Build and Run the App

This application is made of two parts:

• Client
  • web UI that communicates with REST endpoints available through an API app (see below).
  • is a React.js project located in the client folder.
• API
  • uses the MariaDB Node.js Connector to connect to MariaDB.
  • is a Node.js project located in the api folder.

a.) Configure the app

Configure the MariaDB connection by adding an .env file to the Node.js project. Add the .env file here (the api folder).

Example implementation:

DB_HOST=<host_address>
DB_PORT=<port_number>
DB_USER=<username>
DB_PASS=<password>
DB_NAME=orders

Configuring db.js

The environmental variables from .env are used within the db.js for the MariaDB Node.js Connector configuration pool settings:

var mariadb = require('mariadb');
require('dotenv').config();

var pools = [
  mariadb.createPool({
    host: process.env.DB_HOST, 
    user: process.env.DB_USER, 
    password: process.env.DB_PASS,
    port: process.env.DB_PORT,
    database: process.env.DB_NAME,
    multipleStatements: true
  })
];

Configuring db.js for the MariaDB cloud database service SkySQL

MariaDB SkySQL requires SSL additions to connection. It's as easy as 1-2-3 (steps below).

var mariadb = require('mariadb');
require('dotenv').config();

// 1.) Access the Node File System package
const fs = require("fs");

// 2.) Retrieve the Certificate Authority chain file (wherever you placed it - notice it's just in the Node project root here)
const serverCert = [fs.readFileSync("skysql_chain.pem", "utf8")];

var pools = [
  mariadb.createPool({
    host: process.env.DB_HOST, 
    user: process.env.DB_USER, 
    password: process.env.DB_PASS,
    port: process.env.DB_PORT,
    database: process.env.DB_NAME,
    connectionLimit: 5,
    // 3.) Add an "ssl" property to the connection pool configuration, using the serverCert const defined above
    ssl: {
      ca: serverCert
    }
  })
];

b.) Build and run the app

To start and run the API application you need to execute the following commands within the api root folder.

1. Install the Node.js packages (dependendies) for the app.

$ npm install

2. Run the the app, which will expose API endpoints via http://localhost:8080.

$ npm start

c.) Build and run the UI (Client) app

Once the API project is running you can now communicate with the exposed endpoints directly (via HTTP requests) or with the application UI, which is contained with the client folder of this repo.

To start and run the API application you need to execute the following commands within the client root folder.

1. Install the Node.js packages (dependendies) for the app.

$ npm install

2. Run the the app, which will be available via a browser at http://localhost:3000.

$ npm start

Support and Contribution

Please feel free to submit PR's, issues or requests to this project project directly.

If you have any other questions, comments, or looking for more information on MariaDB please check out:

• MariaDB Developer Hub
• MariaDB Community Slack

Or reach out to us diretly via:

• [email protected]
• MariaDB Twitter

License