# Local-First A set of software principles emphasizing collaboration, user data ownership, offline operation, privacy, and control, with CRDTs identified as a foundational technology. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Introducing Credentio: Open Source C++ Library for C2PA Content Credentials from Google DevFeed: [Introducing Credentio: Open Source C++ Library for C2PA Content Credentials from Google]() Original publisher: [Read original article]() Author: Sherif Hanna Published: 2026-09-12T11:04:33.891311Z Content type: news Language: en Sources: [Google Developers Blog]() Topics: [C++](), [Google](), [Open Source](), [Local-First](), [API](), [data]() Tags: [api](), [c-plus-plus](), [data-privacy](), [google](), [local-first](), [open-source](), [performance](), [provenance](), [validation]() ### AI overview Google introduces Credentio, an open-source C++ library for validating C2PA Content Credentials locally within client applications, server pipelines, and edge software. It is designed for high-performance validation of large media assets with lower memory usage, configurable trust lists, and no need to transmit files to cloud or external validation services. Future plans include generating and embedding Content Credentials. ### Source excerpt Credentio is a newly released, open-source C++ library from Google that allows developers to integrate high-performance, local-first validation of C2PA Content Credentials into their client and server applications. By processing assets entirely locally with a highly optimized memory footprint, the library delivers instant validation verdicts for multi-gigabyte media files without incurring cloud latency, bandwidth costs, or data privacy risks. The library currently features deep manifest parsing alongside configurable trust list integration, and is available now on Google Source with future plans to support full credential generation and embedding. ## Building a mini Homelab that fits in my carry-on DevFeed: [Building a mini Homelab that fits in my carry-on]() Original publisher: [Read original article]() Author: jeff@jeffgeerling.com (Jeff Geerling) Published: 2026-08-28T15:00:00Z Content type: opinion Language: en Sources: [Jeff Geerling]() Topics: [Homelab](), [networking](), [Ubiquiti](), [Local-First](), [Hardware](), [SOC]() Tags: [5g](), [arm](), [battery](), [building](), [cloud](), [ethernet](), [fees](), [hardware](), [homelab](), [linux](), [local-first](), [networking](), [opnsense](), [portable](), [ubiquiti](), [unifi](), [video](), [vpn](), [youtube]() ### AI overview The author describes building a portable homelab that fits in carry-on luggage for a trip to Chicago. It supports 1-10 Gbps networking, battery operation, multiple WAN connections, and 12 wired Ethernet connections. The article also shares first impressions of Ubiquiti UniFi, highlighting its local-first operation, optional cloud integration, lack of core licensing fees, and easy web-based management, while criticizing its proprietary ecosystem and limited hardware control. ### Source excerpt I'm traveling to Chicago for VCF Midwest next month. I'll be demoing NTP time history on vintage Macs, with my own GPS-derived NTP service hosted on an Xserve G5, synced via NTP or a strange AppleTalk timing extension from the 1990s. So I built a little 'portable homelab' (pictured above) that supports 1-10 Gbps networking, can run off a small battery for at least an hour, switches between multiple WANs (so I can get my own 5G Internet connection, in case I need it), and gives me 12 wired Ethernet connections. ## Building Local-First Apps: The Complete Guide to Offline-First Database Sync DevFeed: [Building Local-First Apps: The Complete Guide to Offline-First Database Sync]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-07-27T00:00:00Z Content type: tutorial Language: en Sources: [Turso Blog]() Topics: [Local-First](), [Turso](), [SQLite](), [Databases](), [Back end]() Tags: [architecture](), [auth](), [backend](), [database](), [databases](), [guide](), [local-first](), [offline](), [sqlite](), [storage](), [sync](), [turso]() ### AI overview A complete guide to building local-first, offline-first applications. It explains the local-first model, where data lives on the device and the cloud provides backup, synchronization, and coordination, then introduces Turso Sync and SQLite-based approaches. The article also covers architecture patterns and practical challenges including conflict resolution, authentication, storage management, and partial synchronization. ### Source excerpt What local-first means, how Turso Sync works, three architecture patterns, and how to handle the hard parts: conflicts, auth, storage, and partial sync. ## 🍔🧠 Why Linear Feels So Fast (Technical Breakdown) DevFeed: [🍔🧠 Why Linear Feels So Fast (Technical Breakdown)]() Original publisher: [Read original article]() Author: Alexandre Zajac Published: 2026-07-20T15:30:40Z Content type: article Language: en Sources: [Hungry Minds]() Topics: [Caching](), [Local-First](), [client](), [WebSocket](), [Software Engineering](), [Vite](), [npm]() Tags: [cache](), [caching](), [javascript](), [linear](), [local-first](), [npm](), [technical](), [vite](), [websocket]() ### AI overview A technical breakdown of how Linear aims to feel fast by minimizing network latency. It describes local-first state updates, asynchronous synchronization over WebSocket, code splitting, parallel module loading, service-worker precaching, and separately cached dependency chunks. ### Source excerpt PLUS: Virtual memory explained 👨💻, Spark retires vector DBs 💾, Backprop explained simply 🧮 ## Meeting Notes - A Free Desktop App for Tracking 1:1s DevFeed: [Meeting Notes - A Free Desktop App for Tracking 1:1s]() Original publisher: [Read original article]() Author: Dean Hume Published: 2026-06-29T10:16:48Z Content type: article Language: en Sources: [Dean Hume]() Topics: [App](), [meetings](), [Local-First](), [asr](), [Whisper](), [Open Source](), [Markdown]() Tags: [app](), [autosave](), [desktop](), [free](), [meetings](), [notes](), [offline](), [on-device](), [open-source](), [recording](), [speech-to-text](), [technical-leadership](), [technical-program-manager](), [whisper](), [writing]() ### AI overview The article introduces Meeting Notes, a free, open-source Windows desktop app for organizing 1:1 notes by person. It supports topic tags, Markdown, autosave, voice recording, and offline speech-to-text using Whisper, with data and audio kept on the device. ### Source excerpt Meeting Notes is a free offline desktop app for 1:1s. Organise notes by person, tag topics, and transcribe meetings on-device with Whisper. ## Job Search Terminal: A Local-First Tool for an AI-Shaped Job Market DevFeed: [Job Search Terminal: A Local-First Tool for an AI-Shaped Job Market]() Original publisher: [Read original article]() Author: Pavel Bukengolts Published: 2026-06-11T03:37:35Z Content type: opinion Language: en Sources: [UX Magazine]() Topics: [Local-First](), [App](), [Artificial Intelligence]() Tags: [ai](), [app](), [local-first]() ### AI overview The article presents Job Search Terminal, a free, local-first job-search dashboard designed to help people manage resumes, job evaluations, drafts, notes, interview preparation, and application tracking on their own machines. It uses AI for parsing, comparison, drafting, and suggestions while keeping users responsible for reviewing and editing the output, and requires users to bring their own API key. ### Source excerpt The hiring system adopted AI quickly. Job seekers got left trying to explain themselves to machines they cannot see. And somehow, the burden keeps landing on the applicant: learn the tools, rewrite the resume, decode the algorithm, and pay for another platform just to participate in a process that should already be fair. A 2025 The post Job Search Terminal: A Local-First Tool for an AI-Shaped Job Market appeared first on UX Magazine. ## The Architecture Of Local-First Web Development DevFeed: [The Architecture Of Local-First Web Development]() Original publisher: [Read original article]() Author: hello@smashingmagazine.com (Durgesh Pawar) Published: 2026-05-06T10:00:00Z Content type: opinion Language: en Sources: [Articles on Smashing Magazine -- For Web Designers And Developers]() Topics: [Local-First](), [Web Development](), [web applications](), [PWA](), [React](), [backends](), [Database](), [GraphQL](), [Redis](), [Cache]() Tags: [api](), [apps](), [coding](), [data](), [database](), [local-first](), [offline](), [performance](), [react](), [redis](), [web](), [web-apps](), [web-development]() ### AI overview An opinionated examination of local-first web development, prompted by a project management app that became nearly unusable over a poor connection. The article contrasts local-first architecture with offline-first approaches and discusses the practical lessons learned from using local-first patterns in production apps. ### Source excerpt An honest perspective on building local-first web apps in 2026, written for developers who've been doing this long enough to be skeptical of silver bullets. ## How Sample Vault syncs gigabyte-scale databases from cloud to local with Turso DevFeed: [How Sample Vault syncs gigabyte-scale databases from cloud to local with Turso]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-05-04T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [Turso](), [Local-First](), [Databases](), [Cloud](), [data](), [App](), [Artificial Intelligence]() Tags: [ai](), [case-study](), [cloud](), [databases](), [embedded-replicas](), [local](), [offline](), [sync](), [turso]() ### AI overview Sample Vault uses Turso to synchronize gigabyte-scale, per-user audio metadata databases bidirectionally between the cloud and local devices. The local replicas support offline queries across libraries containing more than 100,000 audio files, while cloud processing generates spectral, classification, genre, mood, and AI-derived metadata. ### Source excerpt Sample Vault uses Turso for cloud-to-local bidirectional sync with per-user databases, enabling offline-first access to gigabyte-scale audio metadata without custom sync code. ## OpenDroneLog: A Self Hosted DJI Flight Log Dashboard DevFeed: [OpenDroneLog: A Self Hosted DJI Flight Log Dashboard]() Original publisher: [Read original article]() Author: Jeremy Published: 2026-03-02T14:34:38Z Content type: article Language: en Sources: [Noted]() Topics: [Flight](), [dashboards](), [Self-hosted](), [Local-First](), [Docker](), [DuckDB](), [React](), [Tauri](), [telemetry]() Tags: [docker](), [duckdb](), [local](), [local-first](), [maps](), [react](), [self-hosted](), [self-hosted-logging](), [storage](), [tauri](), [telemetry]() ### AI overview OpenDroneLog is a self-hosted dashboard for analyzing DJI flight logs and Litchi CSV exports. It organizes local telemetry into maps, charts, battery-health tracking, maintenance data, and printable reports, with desktop and Docker-deployable web versions. ### Source excerpt OpenDroneLog is a self hosted flight log dashboard for DJI and Litchi files that turns raw telemetry into maps, charts, battery health insights, and printable reports using a Docker deployable web app with local first storage. ## How I Use Obsidian DevFeed: [How I Use Obsidian]() Original publisher: [Read original article]() Author: Calvin French-Owen Published: 2026-01-07T22:00:00Z Content type: tutorial Language: en Sources: [Calvin French-Owen]() Topics: [Obsidian](), [Local-First](), [Markdown](), [Claude Code]() Tags: [local-first](), [markdown](), [notes](), [obsidian](), [research](), [setup](), [template]() ### AI overview A personal guide to using Obsidian as a local-first Markdown environment for thinking and writing. The author's central principle is that note-taking should elicit thought, with minimal emphasis on organization and automation beyond practical needs. ### Source excerpt Obsidian has become my personal operating system for thinking and writing. Here's the golden rule I follow and the systems I use. ## How We Built the Turso Shell in the Browser DevFeed: [How We Built the Turso Shell in the Browser]() Original publisher: [Read original article]() Author: Jamie Barton Published: 2025-10-14T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [Turso](), [SQLite](), [WebAssembly](), [Vite](), [SQL](), [Local-First](), [React](), [TypeScript](), [Tailwind CSS](), [Web Development]() Tags: [local-first](), [offline](), [react](), [sql](), [sqlite](), [sync](), [tailwind-css](), [turso](), [typescript](), [vite](), [webassembly]() ### AI overview This article explains how to build the Turso Shell, a full SQLite shell that runs entirely in the browser with Turso's WebAssembly build, Vite, OPFS storage, React, and TypeScript. It covers WASM loading, required COOP and COEP headers, database initialization, a SQL query interface, and upgrading the textarea to a syntax-highlighted code editor. The result is a local-first, offline-capable application that can operate without a backend and synchronize when needed. ### Source excerpt Build a full SQLite shell that runs entirely in the browser using Turso's WebAssembly build, OPFS storage, and Vite. No backend, no server required. ## We rewrote large parts of our API in Go using AI: we are now ready to handle one billion databases DevFeed: [We rewrote large parts of our API in Go using AI: we are now ready to handle one billion databases]() Original publisher: [Read original article]() Author: Avinash Sajjanshetty Published: 2025-05-29T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [API](), [Mobile](), [Turso](), [Scalability](), [SQLite](), [Go Language](), [Cloud](), [Serverless](), [Local-First](), [Artificial Intelligence]() Tags: [ai](), [api](), [cloud](), [databases](), [go](), [local-first](), [scalability](), [serverless](), [sqlite](), [turso]() ### AI overview The article explains how Turso rewrote large parts of its Turso Cloud API in Go, using AI, to address scalability problems and prepare to host one billion SQLite databases. It describes Turso Cloud's hosted, serverless SQLite architecture, synchronization with mobile and server-side SQLite files, and the high-volume database creation patterns that motivated the rewrite. ### Source excerpt How we rewrote large parts of the Turso Cloud API in Go using AI, applying string interning and streaming to get ready to host one billion SQLite databases. ## Spring 2025 IPFS Utility Grantees DevFeed: [Spring 2025 IPFS Utility Grantees]() Original publisher: [Read original article]() Author: Robin Berjon Published: 2025-05-12T00:00:00Z Content type: release Language: en Sources: [IPFS]() Topics: [IPFS](), [Tooling](), [AT Protocol](), [Local-First]() Tags: [2025](), [announce](), [development](), [ipfs](), [object-object](), [tooling]() ### AI overview The IPFS Implementations Grants program announces the grantees of its Spring 2025 utility grant cycle. Supported projects include an AT Protocol CAR explorer, Filecoin CAR indexing tools, and DASL testing work intended to improve tooling, interoperability, and developer access across the IPFS ecosystem. ### Source excerpt We're delighted to announce the grantees for the Spring 2025 round of IPFS Utility Grants. ## Designing a minimal, local-first version of lichess. DevFeed: [Designing a minimal, local-first version of lichess.]() Original publisher: [Read original article]() Author: Pranshu Raj Published: 2025-05-10T15:22:00Z Content type: article Language: en Sources: [Pranshu Raj - blog on backend systems, performance and sidequests]() Topics: [Local-First](), [Go](), [WebSocket](), [real-time](), [SQLite](), [JavaScript](), [Requirements](), [Latency](), [Persistence](), [Concurrency](), [rate-limiting]() Tags: [concurrency](), [go](), [javascript](), [latency](), [local-first](), [persistence](), [rate-limiting](), [real-time](), [requirements](), [sqlite](), [websockets]() ### AI overview The author outlines a plan for tinychess, a smaller local-first version of Lichess intended as a learning project. The planned system includes real-time gameplay, game validation and persistence, matchmaking, spectators, leaderboards, rate limiting, and scoring, using Go, WebSockets, JavaScript, and SQLite or a flat file. ### Source excerpt How I'm planning to build tinychess, and what I've learnt so far while preparing to build it. ## Offline Sync Public Beta DevFeed: [Offline Sync Public Beta]() Original publisher: [Read original article]() Author: Jamie Barton Published: 2025-03-31T00:00:00Z Content type: news Language: en Sources: [Turso Blog]() Topics: [Turso](), [libSQL](), [SQLite](), [Local-First](), [Embedded Replicas](), [Rust](), [TypeScript](), [Cloud]() Tags: [applications](), [aws](), [cloud](), [databases](), [embedded-replicas](), [local](), [local-first](), [offline](), [rust](), [sqlite](), [sync](), [turso](), [typescript]() ### AI overview Turso Offline Sync is now in public beta, enabling applications to write to local SQLite databases while offline and synchronize changes with Turso Cloud when connectivity returns. ### Source excerpt Turso Offline Sync is now in public beta. Write to local SQLite databases offline at file speed, then sync push and pull with Turso Cloud when reconnected. ## Local-First SQLite, Cloud-Connected with Turso Embedded Replicas DevFeed: [Local-First SQLite, Cloud-Connected with Turso Embedded Replicas]() Original publisher: [Read original article]() Author: Jamie Barton Published: 2025-03-24T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [Turso](), [Embedded Replicas](), [SQLite](), [Local-First](), [Replication](), [Latency](), [data](), [Cloud]() Tags: [cloud](), [data](), [embedded](), [embedded-replicas](), [latency](), [local-first](), [replication](), [sqlite](), [sync](), [turso]() ### AI overview Turso Embedded Replicas provide local SQLite reads with cloud synchronization, enabling local-first applications with offline support and low-latency access across devices and servers. ### Source excerpt Discover how Turso's Embedded Replicas deliver microsecond SQLite reads with cloud sync. Build faster, more resilient applications for mobile, edge, and AI with zero-latency local access and automatic data sync - no complex caching required. ## Run Tinybird locally or deploy data projects to the cloud DevFeed: [Run Tinybird locally or deploy data projects to the cloud]() Original publisher: [Read original article]() Author: Javi Santana Published: 2025-03-17T00:00:00Z Content type: article Language: en Sources: [Tinybird]() Topics: [Local-First](), [Cloud](), [data]() Tags: [cloud](), [deploy](), [local](), [local-first](), [product-updates](), [project]() ### AI overview Tinybird can run on a local machine, with data projects deployed locally or to the cloud using the same approach. ### Source excerpt Run Tinybird on your machine. Deploy your data project locally or to the cloud in the exact same way, as it should be. ## Ship data as you ship code: Tinybird becomes local-first DevFeed: [Ship data as you ship code: Tinybird becomes local-first]() Original publisher: [Read original article]() Author: Javi Santana Published: 2025-02-05T00:00:00Z Content type: release Language: en Sources: [Tinybird]() Topics: [Local-First](), [Development](), [Cloud]() Tags: [cloud](), [development](), [local-first](), [product-updates]() ### AI overview Tinybird describes its local-first development model: developers can develop and test on their machines, then deploy when ready without a cloud dependency during development. ### Source excerpt Tinybird is local-first. Develop on your machine, test locally, deploy when ready. No cloud dependency during development. ## Local RAG with Ollama, Mistral, and Turso DevFeed: [Local RAG with Ollama, Mistral, and Turso]() Original publisher: [Read original article]() Author: Jamie Barton Published: 2025-01-08T00:00:00Z Content type: tutorial Language: en Sources: [Turso Blog]() Topics: [Retrieval-Augmented Generation](), [Ollama](), [Turso](), [SQLite](), [Embeddings](), [libSQL](), [Local-First](), [Chat Bot](), [pdf]() Tags: [build](), [cloud](), [data](), [embeddings](), [llm](), [local](), [local-first](), [mistral](), [offline](), [ollama](), [on-device](), [open-source](), [rag](), [sql](), [sqlite](), [text-generation](), [turso](), [vector]() ### AI overview A tutorial for building a fully local and offline Retrieval-Augmented Generation pipeline using Ollama, Mistral, and Turso. It stores documents and vector embeddings in a SQLite file, generates embeddings locally, and retrieves relevant content without cloud calls or network access. ### Source excerpt Build a fully local RAG pipeline with Ollama, Mistral, and Turso. Store data and vector embeddings in one SQLite file, with no cloud calls and no network. ## 5 Non-LLM Software Trends To Be Excited About DevFeed: [5 Non-LLM Software Trends To Be Excited About]() Original publisher: [Read original article]() Author: Engineer's Codex Published: 2024-11-12T07:31:23Z Content type: opinion Language: en Sources: [Engineer's Codex]() Topics: [Local-First](), [Latency](), [Software Engineering](), [client](), [Data structures]() Tags: [client](), [data-structures](), [latency](), [local-first](), [software-engineering]() ### AI overview An opinion article highlights local-first software and related conflict-resolution techniques as software engineering trends outside the focus on LLMs. It explains how local storage and processing can improve latency, user experience, and resilience, and introduces CRDTs as a deterministic way to merge replicated data. ### Source excerpt Innovations outside the AI spotlight ## Turso: Databases For All Your AI Apps DevFeed: [Turso: Databases For All Your AI Apps]() Original publisher: [Read original article]() Author: Glauber Costa Published: 2024-10-21T00:00:00Z Content type: news Language: en Sources: [Turso Blog]() Topics: [Turso](), [Databases](), [AI Development](), [AI Agent](), [libSQL](), [Platform API](), [LangChain](), [Local-First](), [quantization](), [iOS](), [Mobile]() Tags: [agents](), [ai](), [databases](), [ios](), [langchain](), [libsql](), [local-first](), [platform-api](), [quantization](), [turso]() ### AI overview Turso announces generally available native vector search with DiskANN indexing, the Turso Vector SDK, 1-bit quantization, and LangChain support for libSQL as a vector store. The article also describes ephemeral database workflows for AI agents and privacy-focused local-first applications. ### Source excerpt On Day 1 of our Launch Week, find out why Turso is the database for all your AI apps. ## Local first AI assistant Kin leverages Turso's libSQL for on-device native Vector Search DevFeed: [Local first AI assistant Kin leverages Turso's libSQL for on-device native Vector Search]() Original publisher: [Read original article]() Author: Simon Westh Henriksen Published: 2024-10-21T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [libSQL](), [Turso](), [Local-First](), [Artificial Intelligence](), [AI search](), [Embeddings](), [Retrieval Augmented Generation (RAG)](), [SQLite](), [Mobile](), [Latency]() Tags: [ai](), [embeddings](), [libsql](), [local](), [local-first](), [mobile](), [on-device](), [rag](), [react](), [sqlite](), [vector-search]() ### AI overview Kin is a privacy-focused, local-first AI assistant that keeps user data on-device. The article explains why its developers chose Turso's libSQL, a SQLite-compatible database with native vector embeddings, to support on-device vector search and retrieval-augmented generation while reducing dependence on cloud servers and network latency. ### Source excerpt When Kin decided to build a privace focused, local first AI assistant, they settled on Turso's libSQL to power it. ## MongoDB Realm & Device Sync Alternatives - Supabase DevFeed: [MongoDB Realm & Device Sync Alternatives - Supabase]() Original publisher: [Read original article]() Author: Craig Cannon Published: 2024-10-09T07:00:00Z Content type: article Language: en Sources: [Supabase Blog]() Topics: [Supabase](), [Local-First](), [real-time](), [MongoDB](), [Low Latency](), [Data Management](), [Database](), [React Native]() Tags: [alternatives](), [announcement](), [integration](), [local-first](), [mongodb](), [offline](), [outages](), [partner](), [performance](), [react-native](), [real-time](), [sync]() ### AI overview Supabase presents alternatives to MongoDB Realm and Device Sync for building offline-first, real-time applications. The article highlights Legend-State, WatermelonDB, PowerSync, Replicache, and ElectricSQL, with capabilities including synchronization, conflict handling, offline operation, and multi-user collaboration. ### Source excerpt Learn how Supabase can help you transition from MongoDB Realm and Device Sync. ## Personal Knowledge Graphs in AI RAG-powered Applications with libSQL DevFeed: [Personal Knowledge Graphs in AI RAG-powered Applications with libSQL]() Original publisher: [Read original article]() Author: Volodymyr Pavlyshyn Published: 2024-09-30T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [libSQL](), [Retrieval Augmented Generation (RAG)](), [Graphs](), [Embeddings](), [Local-First](), [Mobile](), [SQLite](), [Databases](), [Artificial Intelligence]() Tags: [ai](), [databases](), [embeddings](), [graphs](), [libsql](), [local-first](), [mobile](), [rag](), [sqlite]() ### AI overview The article explains how Kin uses libSQL in a local-first mobile AI application to store personal knowledge graphs and vector embeddings in an embeddable SQLite-compatible database. It describes the need to combine graph and vector capabilities, avoid synchronization costs across separate storage systems, and retain compatibility while adding vector search for RAG. ### Source excerpt How Kin uses libSQL on mobile to store personal knowledge graphs alongside vector embeddings, powering local-first RAG with one embeddable SQLite file. [Next page]()