sonicbase

SonicBase is an in-memory database. It works well as an embedded or standalone database, but soars when you add multiple servers. It supports jdbc and offers rich SQL support. The dbms is linearly scalable and can hold billions of records. The database is cross-platform, supporting MacOS, Linux, Windows and Cygwin. For extreme performance, the database offers stored procedures. SonicBase supports cross-shard transactions and cross-shard joins. On a 32 node database we achieved 5.2 million batch inserts per second, 26 million batch identity reads per second and 68 million range-based lookups per second.

For the full documentation, follow this link

Tutorial - Standalone Deploy

In this tutorial we will walk you through the process of starting a standalone server and inserting into and reading from it.

Download The Software

Download the latest software from this site.

Unpack Package

Linux/Mac: Type "tar -xzf sonicbase-<version>.tgz" in the parent directory where you want the software to go. A directory named "sonicbase" will be created.

Windows: Unzip the file sonicbase-<version>.zip in the parent directory where you want the software to go. A directory named "sonicbase" will be created.

Start Admin Client

Change to the sonicbase/bin directory and type "./cli" for MacOS and Linux and "./cli.bat" for cygwin and "cli.bat" for Windows. This will start the SonicBase admin client.

Start Cluster

In the client, type: "start cluster" This will start the cluster on the local machine.

Create Database

In the client, type: "create database db" This will create the database named "db".

Create Table

In the client, type: "create table persons (name VARCHAR, age INTEGER, ssn VARCHAR, PRIMARY KEY (ssn))"

Insert Record

In the client, type: "insert into persons (name, age, ssn) VALUES ('bob', 22, '555-66-7777')"

Read Record

In the client, type: "select * from persons" You should see the inserted record displayed in the client.

Access From JDBC Driver

Include the SonicBase jdbc driver in your application. The jar is located in the "lib" directory of the install directory. It is named "sonicbase-jdbc-[version].jar". Or you can include the jar from the Maven Cental Repository.

If you are using maven, add the jdbc jar to your project pom.xml file. In the dependencies section add the following:

<dependency>
    <groupId>com.sonicbase</groupId>
    <artifactId>sonicbase-jdbc</artifactId>
    <version>[version]</version>
</dependency>

The jdbc version should match your SonicBase server version.

Create and run the following class:

package foo;

public class Tutorial {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.sonicbase.jdbcdriver.Driver");
        try (Connection conn = DriverManager.getConnection("jdbc:sonicbase:localhost:9010/db");
            PreparedStatement stmt = conn.prepareStatement("select * from persons");
            ResultSet rs = stmt.executeQuery()) {
            rs.next();
            System.out.println(rs.getString("name") + " " + rs.getInt("age") + " " + rs.getString("ssn"));
        }
    }
}

For a tutorial using a remote cluster follow this link

For documentation follow this link