How Turso made connections to SQLite databases 575x faster
9 months ago
- #Rust
- #Database
- #SQLite
- Turso is a full rewrite of SQLite in Rust, designed for modern applications.
- It addresses SQLite's architectural limitations, like improving write concurrency and eliminating the 'database is locked' issue.
- Turso significantly speeds up connection opening, achieving a 500x improvement for databases with many tables (e.g., 10,000 tables).
- SQLite's connection opening slows down with more tables due to schema parsing.
- Turso optimizes this by sharing schema state among connections, reducing opening time to 40 microseconds.
- Turso embraces parallelism and multithreading, unlike SQLite's single-threaded origins.
- Turso is open for contributions, with over 130 contributors, unlike SQLite's closed community.