rqlite

rqlite is a lightweight, distributed relational database with an HTTP API. It provides fault-tolerant data storage with automatic leader election, making it ideal for reliable data management at the edge.

What You Can Do After Deployment

1. Visit your domain — Access the rqlite HTTP API endpoint to confirm the node is running
2. Execute SQL statements — Send SQL queries via the HTTP API using curl or any HTTP client
3. Check node status — Query the /status endpoint to see cluster and node details
4. Insert and query data — Create tables, insert rows, and run SELECT queries over HTTP
5. Monitor readiness — Use the /readyz endpoint for health and readiness checks

Key Features

• HTTP API for executing SQL statements and queries
• Fault-tolerant with automatic leader election via Raft consensus
• Easy clustering with node discovery support
• Read consistency levels (none, weak, strong)
• Bulk operations for high-throughput data ingestion
• Parameterized queries to prevent SQL injection
• Hot backups and restore without downtime
• TLS encryption for secure communication
• Built-in authentication and access control
• Minimal resource footprint suitable for edge and IoT deployments

License

MIT — GitHub