This is the Java client library for rqlite. rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. The library is currently in active development. Significant development and testing remains, and pull requests are welcome.
// 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());