Repository files navigation

This repository uses theofficial MariaDB Docker image to demonstrate how to manage semi-structured, viaJavaScript Objection Notation (JSON), within aMariaDB database.

This README will walk you through the steps for getting a MariaDB database up and running, using aDocker container, and automatically create adatabase, table and pre-load the table with data.

This sample requires that you have the following installed:

• Docker

The following provides for getting started using JSON with MariaDB (via a MariaDB database instance within a Docker container).

1. Pull down this respository by either downloading it directly or usegit (through CLI or a client) to retrieve the code usinggit clone:

   $ git clone https://github.com/mariadb-developers/mariadb-json-quickstart.git

2. Navigate to the root of this sample, and execute thedocker-compose up command to rundocker-compose.yml:

   $ docker-compose up -d

   Note: Thedocker-compose up command will use thedocker-compose.yml file to spin up a new Docker container (using the official MariaDB Docker image) andexecute SQL to create a new database (places), tables (locations), and load it with sample data.

3. Use thedocker CLI command to use themariadb command-line client, included in the Docker container, to connect and query your MariaDB database.

   $ dockerexec -it mdb_json mariadb -u root -pPassword123!

   which will load the MariaDB command-line client, which will enable to start executing SQL using MariaDB JSON functionality.

   

• Official MariaDB JSON documentation
• Getting Started with JSON and MariaDB (blog post)

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:

• developers@mariadb.com
• MariaDB Twitter