IdeaWell

Project ideas from Hacker News discussions.

Deep dive into Turso, the “SQLite rewrite in Rust”

Original Article

Hacker News Discussion

📝 Discussion Summary (Click to expand)

1. Rust rewrite – performance, safety, and concurrency

“They’re implementing MVCC” – maxmcd
“Concurrent writes already working is a reasonable definition of success.” – fragmede

The discussion centers on whether Rust can deliver the same speed and reliability as C while adding features like MVCC and concurrent writes.

2. Test‑suite reliability and the SQLite “black‑box”

“SQLite’s test suite is infamously gigantic… the public tests are tiny compared to what SQLite actually runs internally.” – adamzwasserman
“The full SQLite test suite isn’t open source, so you (the third party) don’t have the same confidence in your modifications as the SQLite team does.” – jzebedee

Users argue that without access to the proprietary tests, a rewrite risks missing subtle bugs that the original SQLite team catches.

3. VC‑backed startup vs. open‑source sustainability

“I can easily see how SQLite’s development is sustainable, but not Turso’s.” – ndiddy
“Free VC‑backed software always means ‘free… until it’s in our interest to charge for it’.” – CodingJeebus

Critics warn that Turso’s funding model could lead to a rug‑pull or a shift away from the open‑source ethos.

4. Compatibility and feature gaps with SQLite

“SQLite compatibility for SQL dialect, file formats, and the C API.” – IshKebab
“The sqlite API isn’t fully implemented yet, so I wrote a declarative facade that backfills the missing implementations.” – adamzwasserman

The conversation highlights the tension between maintaining strict compatibility and adding new features that SQLite doesn’t yet support.

🚀 Project Ideas

DualDB Sync Layer

Summary

  • A lightweight Rust/Node.js library that transparently writes to two databases (SQLite, Turso, or Postgres) and keeps them in sync.
  • Solves the pain of migrating from an in‑process DB to a networked one while preserving data integrity and minimizing downtime.
  • Core value: zero‑code‑change migration path with automatic conflict resolution.

Details

Key Value
Target Audience Backend developers using SQLite locally who need to scale to a cloud DB.
Core Feature Dual‑write facade with conflict detection, schema sync, and optional read‑through.
Tech Stack Rust (core), Node.js bindings, SQLite3, Turso SDK, Postgres client, async‑sync engine.
Difficulty Medium
Monetization Hobby

Notes

  • HN users like “adamzwasserman” already built a similar facade; this tool would formalize it and add conflict handling.
  • Enables “write once, run anywhere” and encourages experimentation with Turso without risking data loss.

SQLite Benchmark Suite

Summary

  • A command‑line and web UI tool that benchmarks SQLite, pglite, Turso, and other embedded DBs on the same workload.
  • Addresses the frustration over performance gaps and lack of reliable benchmarks.
  • Core value: data‑driven decision making for choosing the right DB.

Details

Key Value
Target Audience DevOps, performance engineers, hobbyists comparing embedded DBs.
Core Feature Automated benchmark runner, result visualizer, CI integration.
Tech Stack Go (benchmark engine), Docker, Grafana dashboards, REST API.
Difficulty Medium
Monetization Revenue‑ready: $5/month for premium dashboards and CI plugins.

Notes

  • “rudedogg” noted performance gaps; this tool gives concrete numbers.
  • Could spark discussion on “pglite vs SQLite” and help validate claims in the HN thread.

SQLite Compatibility Tester

Summary

  • A test harness that runs the full public SQLite test suite against any SQLite‑compatible database (e.g., Turso, custom forks).
  • Solves the need for confidence in compatibility and regression detection.
  • Core value: automated compatibility verification with minimal effort.

Details

Key Value
Target Audience Database maintainers, contributors to SQLite‑compatible projects.
Core Feature Wrapper to execute SQLite TCL tests, report pass/fail, generate diff logs.
Tech Stack Python (test runner), Docker, SQLite test harness, CI integration.
Difficulty Medium
Monetization Hobby

Notes

  • Addresses concerns about “compatibility” and “test suite” from the discussion.
  • Would be welcomed by “pseudohadamard” and others wanting to validate their forks.

SchemaSync

Summary

  • A CLI tool that compares schemas and data between two database instances (e.g., local SQLite and remote Turso) and generates migration scripts with conflict detection.
  • Helps developers move from in‑process to networked DBs without manual SQL work.
  • Core value: automated, safe schema migration and data diff.

Details

Key Value
Target Audience Full‑stack developers, database admins, CI/CD pipelines.
Core Feature Schema diff, data diff, conflict resolution, rollback plan.
Tech Stack Rust (core), SQLx, SQLite, Turso SDK, Postgres client, CLI.
Difficulty Medium
Monetization Hobby

Notes

  • “adamzwasserman” wrote a declarative facade; SchemaSync would automate the migration part.
  • Encourages discussion on “migration tooling” and “schema versioning” in the HN community.

Read Later