Todo App with MariaDB Connector/R2DBC

Clone the Repository

The Todo example application is available from the MariaDB Corporation repository on GitHub. It contains the API code in Java and other languages, and the React.js front-end web application that connects to the API.

To download the Todo application, clone the repository from GitHub:

$ git clone https://github.com/mariadb-corporation/dev-example-todo.git

This creates a dev-example-todo directory on your file system.

Provision Database Service

Todo requires a back-end database service using the InnoDB storage engine. The application is compatible with Single Node Transactions and Replicated Transactions topologies of MariaDB SkySQL. For the purposes of demonstration, this guide uses the Single Node Transactions topology on MariaDB SkySQL.

For additional information, see "Launch".

Create the Database Schema

Todo uses an InnoDB table to store the todo entries.

Use the MariaDB Client to connect to the database service and initialize the schema:

1. Connect to your database service.

2. Use CREATE DATABASE to create a database for the application:

   CREATE DATABASE todo;
   

3. Use CREATE TABLE to create a table to store the todo entries:

   CREATE TABLE todo.tasks (
     id INT PRIMARY KEY AUTO_INCREMENT,
     description VARCHAR(500) NOT NULL,
     completed BOOLEAN NOT NULL DEFAULT 0
   ) ENGINE = InnoDB;
   

This creates a todo.tasks table for use by the Todo application with MariaDB SkySQL as a database back-end.

Configure the Back-end Application Service

To connect to your MariaDB SkySQL database service, the application must be configured to use the appropriate credentials.

1. Create properties file at src/main/resources/db.properties and populate it with the login credentials for your MariaDB SkySQL service:

   host          = example.skysql.net
   username      = db_user
   password      = db_password
   database      = todo
   port          = 5001
   clientSslCert = classpath:static/skysql_chain.pem
   

2. Create a directory for static files:

   $ mkdir src/main/resources/static
   

3. Copy your SkySQL CA file into the static directory:

   $ cp /path/to/skysql_chain.pem src/main/resources/static
   

Build the Back-end Application Service

To build the Java back-end application service:

$ mvn package

Start the Back-end Application Service

Once you have the back-end application service configured and installed, you can start the service:

$ mvn spring-boot:run