2026.11.19

đź“° News & Discussions

Turso Sync: Local-First SQLite with Push and Pull

"Turso Sync ships logical changes instead of pages, so writes stay local and you decide when to push and pull. Here is how it works, what the benchmarks show, and where last-push-wins fits."

Local Analytics Doesn’t Need a Database Server

"TL;DR: From interactive maps to graph exploration, DuckDB makes it possible to analyze data without a database server. Ilya Boyandin shares how this approach led to SQLRooms, a toolkit for building analytics applications that bring data, visualizations, and AI-assisted analysis together on the user’s machine."

How I Built DraftLine: A Local-First, Zero-Friction Screenwriting App

"DraftLine is designed around a local-first approach. You can work directly in the app without depending on a proprietary cloud service or a DraftLine account."

Building Card Field: A Digital Business Card the Server Cannot Read

"Card Field reuses MyField’s end-to-end encrypted sync capability. This capability was first refined in Turn Field: app data is encrypted on the device, and the cloud only acts as an encrypted relay that stores and forwards encrypted data. Other authorized devices receive it, then decrypt, merge, and use it locally."

🛠️ Tools & Resources

Prisma IBD

"A type-safe IndexedDB client generated from your Prisma schema, with the Prisma Client API you already know. Add optional sync for offline-first apps, with conflict resolution and ownership rules."

instantdb-rust

"A drop-in, self-hosted InstantDB sync engine, rewritten in Rust. Your existing @instantdb apps, unmodified, on your own Postgres."

Turso Cloud BYOC: the same product, in your own AWS account

"Turso Cloud BYOC runs Turso Cloud inside your own AWS account. It is the same product, with the same API and the same operations, and your data stays in your account."

SQLike

"A SQLite subset written in MoonBit for browsers and Node.js. Run SQL in memory, or execute predefined statements with IndexedDB persistence for offline use. Add the separate @mizchi/litestream package for synchronization."

✨ Apps

Estimate Cam

"Free, MIT-licensed browser app for solo contractors to organize job photos, prepare scopes and estimates, and export branded reports. Projects use local IndexedDB storage with backup/export; no signup or device sync. Optional AI uses the user's provider, and browser dictation may send audio to its speech provider." Source.

DraftLine

"Writers should control their files, storage, and workflow. Open formats and local-first design help protect that freedom."

Prusa Connect

"Local-first Prusa Connect is a printer server you run yourself. Download just one file for Linux, Windows, macOS or Raspberry Pi and run it."

EpicNotes

"EpicNotes is the local-first workspace that unites notes, tasks & calendar — with semantic AI search"

DoneTrace

"Local-first, one-click export anytime, openable in the free edition." "Zero-config end-to-end encrypted cloud backup."

How to Contribute

Anyone can contribute to Local-First News with a pull request. Instructions and guidelines available here.

Sponsors

Local-First News is sponsored by PowerSync. Interested in sponsoring? Get in touch