Quick Start Guide

The Raijin Database Engine is designed to fill the gap between SQL and document databases. In this short introductory guide, we will show you how you can use Raijin to solve a major headache: schema rigidity.

We assume you are already familiar with SQL and have used an RDBMS product in the past, although this is not a requirement.

Installing Raijin

The first step is to grab either the RPM or the DEB package from the Downloads page.

To install the Raijin Database Engine on Ubuntu, Debian, or one of its derivatives, run the following as root:

$ sudo dpkg -i raijin-server_5.3.6735_amd64.deb

On RedHat, CentOS, or other RPM-based GNU/Linux distributions, use the following command:

$ sudo rpm -ivh raijin-server-5.3.6735.x86_64.rpm

There are no additional packages to install and configure. Once Raijin is installed, you can start the service:

$ sudo service raijin-server start

Once Raijin is installed and running, open http://localhost:2500 in your web browser, and you should see the Raijin user interface.

For this quick start, the default configuration is sufficient. However, for customizing the configuration, please refer to Configuration parameters.

The server needs to be restarted for any configuration changes to take effect.

Running simple queries

You can use the Raijin web-based user interface to start experimenting with Raijin.

Creating a database

To create a database named testdb, try:


Clicking Execute Query should return OK, as shown below.

Raijin user interface

Creating tables

Next, go ahead and create a table in your new database:

CREATE TABLE testdb.tbl(a BOOL, b INT);

And populate it with some data:

INSERT INTO testdb.tbl(a, b) VALUES (true, 1);

Both of these commands should return OK.

Retrieving data

Now that your database contains some data, you can retrieve it by executing a SELECT query:

SELECT * FROM testdb.tbl;

Raijin will return the result in JSON format:


Once you’re ready from your testing, you can delete the database used in this exercise: