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.
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.
You can use the Raijin web-based user interface to start experimenting with Raijin.
To create a database named
CREATE DATABASE testdb;
Clicking Execute Query should return OK, as shown below.
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.
Now that your database contains some data, you can retrieve it by executing a
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:
DROP DATABASE testdb;