rqlite

rqlite is a lightweight, distributed DBMS built on top of [SQLite](https://www.sqlite.org/). rqlite uses the [Raft protocol](https://raft.github.io/) to achieve consensus across all the instances of the SQLite databases, ensuring that every change made to the system is made to a quorum of SQLite databases, or none at all. For a detailed description of much of the database functionality, consult the [SQLite entry] (https://dbdb.io/db/sqlite).

History

rqlite was originally a prototype application, showing how the Raft consensus algorithm could be applied to various software state machines -- in this particular instance a SQLite database. It has since developed into a full relational database management system.

Query Interface

SQL HTTP / REST

rqlite is primarily queried via its HTTP(S) API. A query is formed by encapsulating a SQL statement in a HTTP request. And when using the "on disk" mode of rqlite, the SQLite database can also be queried directly.

Logging

Physical Logging

rqlite provides data durability via the Raft consensus system. Every change made to the SQLite database is written to the Raft log, and that log is persisted to disk. In the event of a restart or recovery operation, the SQLite database is completely rebuilt from the data contained in the Raft log.

Isolation Levels

Read Uncommitted Serializable Snapshot Isolation

Since rqlite uses SQLite as its storage engine, it offers the same isolation levels as SQLite.

Stored Procedures

Not Supported

Storage Architecture

Hybrid

rqlite supports both in-memory and disk-oriented storage. The SQLite database can be stored on disk, or in memory. The Raft log is stored on disk.

Foreign Keys

Supported

Since rqlite uses SQLite as its storage engine, it can make full use of SQLite Foreign Key support.

Data Model

Relational

rqlite supports the relational data model, since it uses [SQLite](https://dbdb.io/db/sqlite) as its storage engine.

System Architecture

Shared-Nothing

rqlite Logo
Website

http://www.rqlite.com/

Source Code

https://github.com/rqlite/rqlite

Tech Docs

https://github.com/rqlite/rqlite/tree/master/DOC

Developer

Philip O'Toole

Country of Origin

US

Start Year

2014

Project Type

Open Source

Written in

Go

Embeds / Uses

SQLite

Operating Systems

Linux, OS X, Windows

Licenses

MIT