Raijin has announced the release of version 1.0 of its powerful schemaless SQL database engine, furthering its goal of "solving schema rigidity" in modern databases. Many new features have been added to this version 1.0 milestone release.
Let’s take a look at some of the headline features.
The power of SQL without the drawbacks
SQL has been the titan of database query languages for decades, and it is still ubiquitous the world over. But, increasingly, there are drawbacks with it as modern databases seek to solve modern challenges.
Raijin harnesses the power of SQL whilst lifting some of the constraints that bind it. It is the primary language to query Raijin databases, with additional powerful features from other query languages natively supported. But, unlike traditional SQL databases, you don’t have to normalize your data before you input it into Raijin.
Compressed data storage
Raijin can compress data stored in its tables, not only saving disk space but also increasing performance on modern CPUs. It uses JSON for information exchange, but the raw data is stored in a space-efficient binary format. With block-level data compression, your database will be more efficient than ever.
Fast and simple ingestion API
A simple REST API is exposed with Raijin, allowing JSON data to be easily ingested into your database. Insert data into your database at lightning speed, and migrate your existing data to Raijin easily and cheaply.
Secure database operation
The confidentiality of your data is important. Databases especially so, given they so often store business critical and important information. Raijin is secured with SSL and certificate-based authentication, ensuring that only those who should have access can get access.
Grafana and Apache Superset integration
Do you want to use Raijin to power your data visualization dashboards? No problem! Raijin easily integrates with Grafana and Apache Superset, allowing you to create spectacular real-time visualizations from your data.
Flexible table partitioning
Table partitioning can improve performance, security, and can better organize your database for future developments. You can break up your Raijin database into more manageable chunks (partitions) to speed up operations, and make data purging and backups easier. Implement your own custom data life-cycle management by creating partitions based on data attributes.
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 Enterprise Edition’s powerful log collection and centralization features. With NXLog’s Raijin integration, you can seamlessly and easily send logs from NXLog to a Raijin database instance. The two fit hand in glove, providing the methods of capturing, processing, and then storing log data for a complete log management solution.
For a full breakdown of the features and improvements, check out the Raijin release notes.
Congratulations to the Raijin team for hitting this important development milestone!