Webtagr - Technology News Summarizer

Turso: A 1GB Mystery Solved by an LLN

2025-09-01

Turso, a Rust rewrite of SQLite, encountered a bizarre issue: databases exceeding 1GB were reported as corrupted by SQLite, despite being perfectly intact. The root cause? SQLite inserts a special page at the 1GB mark, a step missing in Turso. Nikita, a remarkably skilled engineer on the Turso team (suspected to be an LLM or alien!), leveraged his seemingly superhuman knowledge to pinpoint and fix the bug. This highlights the importance of thorough testing and comprehensive documentation, showcasing the potential of LLMs in code understanding and debugging.

(turso.tech)

Development

From Prison Cell to Turso Software Engineer: A Hacker News Story

2025-06-16

An incarcerated programmer, serving time for drug-related offenses, landed a software engineering job at Turso. Using limited prison internet access, he dedicated himself to coding, contributing to open-source projects, and ultimately impressed Turso with his work on Project Limbo, a rewrite of SQLite. His story highlights perseverance, second chances, and the power of open source.

(turso.tech)

Development

Turso Offline Sync Public Beta: Always-On Apps, Even Offline

2025-03-31

Turso is thrilled to announce the public beta of Turso Offline Sync! Your applications can now function seamlessly, even without internet connectivity. Local database operations continue normally, automatically syncing upon reconnection. Leveraging embedded replicas, your local database (on-device or server) stays in sync with your Turso Cloud database, with changes propagated to all replicas. This beta addresses previous limitations of unidirectional sync, enabling fast local writes, offline capabilities, and later syncing to the Turso Cloud. This simplifies development for local-first apps, mobile apps, POS systems, field data collection, and IoT applications. The beta currently supports TypeScript and Rust, and includes features like bi-directional sync, remote write support, WAL sync checkpointing, and conflict detection (resolution coming soon).

(turso.tech)

Development offline sync

Building a High-Performance SQLite Edge Replica with Turso and Fly.io

2025-02-13

This tutorial demonstrates how to build custom SQLite edge replicas for Turso using Node.js and Fly.io to boost database performance. By deploying proxy servers across multiple global regions and leveraging Fly.io's Anycast network, low-latency data access is achieved. The solution caches data locally in a SQLite file, periodically syncing with the primary database, reducing network latency and data replication costs for a superior user experience. The tutorial covers Dockerfile configuration, Fly.io deployment, proxy server implementation details, and includes a security authentication mechanism.

(turso.tech)

Development edge computing