Raijin announces release of version 1.4

Raijin has announced the release of version 1.4 of its powerful, schemaless SQL-like database engine. This version introduces new functionality for managing users and views, among several fixes and performance improvements.

Read on for the highlights and check out the Raijin release notes for a complete list of the features and improvements.

Improved user management

This release builds on the previous one to provide better user management and auditing. With the SHOW USERS command, you can now retrieve a list of your Raijin users and their authentication type.

Creating and viewing users

-- Create a superuser
CREATE USER 'admin' IDENTIFIED WITH PASSWORD 'Str0ngpas$';
GRANT ALL PRIVILEGES ON *.* TO 'admin';

-- Create a user with read and write permissions on testdb
CREATE USER 'jsmith' IDENTIFIED WITH PASSWORD 'Str0ngpas$';
GRANT SELECT, INSERT ON testdb.* TO 'jsmith';

-- List users
SHOW USERS;

Result

{"name":"admin","identified_with":"PASSWORD"}
{"name":"jsmith","identified_with":"PASSWORD"}

Check out the Raijin User management documentation for more information and examples.

Support for listing views

The new SHOW VIEWS command returns a list of database views and their corresponding queries. It allows you to manage your views better, making it easier to audit and avoid duplicate and stale views.

Creating and listing views

USE testdb;

-- Create a table
CREATE TABLE events(
    Hostname VARCHAR(20),
    EventTime TIMESTAMP,
    EventType VARCHAR(10),
    Message TEXT
);

-- Create a view
CREATE VIEW error_logs AS
    SELECT * FROM events
    WHERE EventType = 'ERROR';

-- List views
SHOW VIEWS;

Result

{"view":"error_logs","definition":"SELECT * FROM events\n    WHERE EventType = 'ERROR'"}

Other important improvements

A few other notable improvements are:

Improved sorting algorithm, increasing the speed of ORDER BY operations.
Increased column name length limit - up to 255 characters for better naming conventions and to preserve source data structures.
More fine-grained partition management with ATTACH/DETACH/DROP operations. You can now target partitions by their directory.

Collect logs with NXLog

As a database engine, Raijin is geared towards semi-structured data, making it a perfect solution for log storage. Log data is notoriously unstructured, making it hard to store in rigid table structures like traditional SQL systems.

Raijin complements NXLog’s powerful log collection and centralization solutions. With NXLog Enterprise Edition’s Raijin integration, you can seamlessly and easily send logs from NXLog Enterprise Edition to a Raijin database instance. The two fit hand in glove, providing the methods of capturing, processing, and storing log data for a complete log management solution.