This repo contains the prerequisites and demo scripts for a demo on SQL/NoSQL storage in Ballerina.

• Install Ballerina 1.1.0

• Install an IDE Plugin for Ballerina (e.g., VSCode Ballerina Plugin or IntelliJ IDEA plugin)

• Prerequisites for the relational database samples - H2 or MySQL DB

  • H2 - No installation required since a file-based DB is used. The H2 JDBC driver is already shipped with the Ballerina distribution.

  • MySQL (Optional)

    • Install MySQL DB on your local machine or use an existing DB server.

    • Create a database named demodb using a DB Client.

    • Copy the MySQL JDBC driver to the <ballerina-home>/bre/lib directory on your local machine.

      Note: You can find the <ballerina-home> location using the following command:

      $ ballerina home

  • Install a DB Visualizer tool (Optional)

• Prerequisites for the NoSQL database samples

  • Install MongoDB Community Edition

  • Install a DB Visualizer tool (Optional) - e.g., MongoDB Compass Community Edition