README.md

rqlite-java

This is a basic Java client library for rqlite. rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. Significant development and testing remains, and pull requests are welcome.

Quick start

// Declare variables.
ExecuteResults results = null;
QueryResults rows = null;

// Get a connection to a rqlite node.
Rqlite rqlite = RqliteFactory.connect("http", "localhost", 4001);

// Create a table.
results = rqlite.Execute("CREATE TABLE foo (id integer not null primary key, name text)");
System.out.println(results.toString());

// Insert a record.
results = rqlite.Execute("INSERT INTO foo(name) VALUES(\"fiona\")");
System.out.println(results.toString());

// Query all records in the table.
rows = rqlite.Query("SELECT * FROM foo", Rqlite.ReadConsistencyLevel.WEAK);
System.out.println(rows.toString());