Show HN: gRPSQLite – A SQLite VFS for remote databases via gRPC
a year ago
- #gRPC
- #Database
- #SQLite
- gRPSQLite enables remote SQLite databases via gRPC, allowing any storage system to act as a backend.
- Features include real SQLite compatibility, support for any storage system, instant availability, atomic transactions, and read replicas.
- Quick start involves running a container, starting a memory server, and using SQLite normally with data persistence.
- The system converts SQLite file operations into gRPC calls, requiring a simple gRPC server implementation for storage handling.
- Early-stage software with limited testing, not recommended for production use.
- Use cases include multi-tenant SaaS, AI workflows, immutable databases, and read fanout scenarios.
- Examples provided in Rust demonstrate memory server implementations with various features.
- Two methods of using the SQLite VFS: dynamically loading or statically compiling into a SQLite binary.
- Performance benefits include atomic batch commits and read replicas for scaling reads.
- Contributions require discussion before pull requests to ensure alignment with project goals.