README.md

kqlite 

Lightweight remote SQLite with high availability and automatic failover.

• Replicated SQLite database and remote access over the PostgreSQL wire protocol.
• Automatic failover to an active secondary instance and registering back as secondary a former primary.
• Quick and easy setup and high availability configuration with only two DB Nodes.

Works by translating PostgreSQL frontend wire messages into SQLite transactions and converting results back into PostgreSQL response wire messages. Many PostgreSQL clients also inspect the pg_catalog to determine system information so kqlite mirrors this catalog by using an attached in-memory database with virtual tables. A rewrite on those system queries is performed to convert them to usable SQLite syntax.

Table of contents

• Architecture
• Installation
• Quick Start
• Configuration
• Development