# Local-First

Published articles for Local-First.

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](<https://devfeed.tech/articles/introducing-credentio-open-source-c-library-for-c2pa-content-credentials-from-google-4214.md>)

Original publisher: [Read original article](<https://developers.googleblog.com/introducing-credentio-open-source-c-library-for-c2pa-content-credentials-from-google/>)

Author: Sherif Hanna

Published: 2026-09-12T11:04:33.891311Z

Content type: news

Language: en

Sources: [Google Developers Blog](<https://devfeed.tech/sources/google-developers-blog.md>)

Topics: [C++](<https://devfeed.tech/topics/c-plus-plus.md>), [Google](<https://devfeed.tech/topics/google.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [API](<https://devfeed.tech/topics/api.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [c-plus-plus](<https://devfeed.tech/tags/c-plus-plus.md>), [data-privacy](<https://devfeed.tech/tags/data-privacy.md>), [google](<https://devfeed.tech/tags/google.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [performance](<https://devfeed.tech/tags/performance.md>), [provenance](<https://devfeed.tech/tags/provenance.md>), [validation](<https://devfeed.tech/tags/validation.md>)

### 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](<https://devfeed.tech/articles/building-a-mini-homelab-that-fits-in-my-carry-on-10470.md>)

Original publisher: [Read original article](<https://www.jeffgeerling.com/blog/2026/mini-homelab-network-fits-in-carry-on/>)

Author: jeff@jeffgeerling.com (Jeff Geerling)

Published: 2026-08-28T15:00:00Z

Content type: opinion

Language: en

Sources: [Jeff Geerling](<https://devfeed.tech/sources/jeff-geerling.md>)

Topics: [Homelab](<https://devfeed.tech/topics/homelab.md>), [networking](<https://devfeed.tech/topics/networking.md>), [Ubiquiti](<https://devfeed.tech/topics/ubiquiti.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Hardware](<https://devfeed.tech/topics/hardware.md>), [SOC](<https://devfeed.tech/topics/soc.md>)

Tags: [5g](<https://devfeed.tech/tags/5g.md>), [arm](<https://devfeed.tech/tags/arm.md>), [battery](<https://devfeed.tech/tags/battery.md>), [building](<https://devfeed.tech/tags/building.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [ethernet](<https://devfeed.tech/tags/ethernet.md>), [fees](<https://devfeed.tech/tags/fees.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [homelab](<https://devfeed.tech/tags/homelab.md>), [linux](<https://devfeed.tech/tags/linux.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [networking](<https://devfeed.tech/tags/networking.md>), [opnsense](<https://devfeed.tech/tags/opnsense.md>), [portable](<https://devfeed.tech/tags/portable.md>), [ubiquiti](<https://devfeed.tech/tags/ubiquiti.md>), [unifi](<https://devfeed.tech/tags/unifi.md>), [video](<https://devfeed.tech/tags/video.md>), [vpn](<https://devfeed.tech/tags/vpn.md>), [youtube](<https://devfeed.tech/tags/youtube.md>)

### 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](<https://devfeed.tech/articles/building-local-first-apps-the-complete-guide-to-offline-first-database-sync-5907.md>)

Original publisher: [Read original article](<https://turso.tech/blog/building-local-first-apps-the-complete-guide-to-offline-first-database-sync>)

Author: Jeff Olson

Published: 2026-07-27T00:00:00Z

Content type: tutorial

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [Turso](<https://devfeed.tech/topics/turso.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Back end](<https://devfeed.tech/topics/backend.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [auth](<https://devfeed.tech/tags/auth.md>), [backend](<https://devfeed.tech/tags/backend.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [guide](<https://devfeed.tech/tags/guide.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [offline](<https://devfeed.tech/tags/offline.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [storage](<https://devfeed.tech/tags/storage.md>), [sync](<https://devfeed.tech/tags/sync.md>), [turso](<https://devfeed.tech/tags/turso.md>)

### 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)](<https://devfeed.tech/articles/why-linear-feels-so-fast-technical-breakdown-18139.md>)

Original publisher: [Read original article](<https://hungrymindsdev.substack.com/p/why-linear-feels-so-fast-technical>)

Author: Alexandre Zajac

Published: 2026-07-20T15:30:40Z

Content type: article

Language: en

Sources: [Hungry Minds](<https://devfeed.tech/sources/hungry-minds.md>)

Topics: [Caching](<https://devfeed.tech/topics/caching.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [client](<https://devfeed.tech/topics/client.md>), [WebSocket](<https://devfeed.tech/topics/websocket.md>), [Software Engineering](<https://devfeed.tech/topics/software-engineering.md>), [Vite](<https://devfeed.tech/topics/vite.md>), [npm](<https://devfeed.tech/topics/npm.md>)

Tags: [cache](<https://devfeed.tech/tags/cache.md>), [caching](<https://devfeed.tech/tags/caching.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [linear](<https://devfeed.tech/tags/linear.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [npm](<https://devfeed.tech/tags/npm.md>), [technical](<https://devfeed.tech/tags/technical.md>), [vite](<https://devfeed.tech/tags/vite.md>), [websocket](<https://devfeed.tech/tags/websocket.md>)

### 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 🧮

## 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](<https://devfeed.tech/articles/job-search-terminal-a-local-first-tool-for-an-ai-shaped-job-market-9083.md>)

Original publisher: [Read original article](<https://uxmag.com/articles/job-search-terminal-a-local-first-tool-for-an-ai-shaped-job-market>)

Author: Pavel Bukengolts

Published: 2026-06-11T03:37:35Z

Content type: opinion

Language: en

Sources: [UX Magazine](<https://devfeed.tech/sources/ux-magazine.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [App](<https://devfeed.tech/topics/app.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [app](<https://devfeed.tech/tags/app.md>), [local-first](<https://devfeed.tech/tags/local-first.md>)

### 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](<https://devfeed.tech/articles/the-architecture-of-local-first-web-development-4274.md>)

Original publisher: [Read original article](<https://smashingmagazine.com/2026/05/architecture-local-first-web-development/>)

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](<https://devfeed.tech/sources/articles-on-smashing-magazine-for-web-designers-and-developers.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [Web Development](<https://devfeed.tech/topics/web-development.md>), [web applications](<https://devfeed.tech/topics/web-applications.md>), [PWA](<https://devfeed.tech/topics/pwa.md>), [React](<https://devfeed.tech/topics/react.md>), [backends](<https://devfeed.tech/topics/backends.md>), [Database](<https://devfeed.tech/topics/database.md>), [GraphQL](<https://devfeed.tech/topics/graphql.md>), [Redis](<https://devfeed.tech/topics/redis.md>), [Cache](<https://devfeed.tech/topics/cache.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [apps](<https://devfeed.tech/tags/apps.md>), [coding](<https://devfeed.tech/tags/coding.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [offline](<https://devfeed.tech/tags/offline.md>), [performance](<https://devfeed.tech/tags/performance.md>), [react](<https://devfeed.tech/tags/react.md>), [redis](<https://devfeed.tech/tags/redis.md>), [web](<https://devfeed.tech/tags/web.md>), [web-apps](<https://devfeed.tech/tags/web-apps.md>), [web-development](<https://devfeed.tech/tags/web-development.md>)

### 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.

## OpenDroneLog: A Self Hosted DJI Flight Log Dashboard

DevFeed: [OpenDroneLog: A Self Hosted DJI Flight Log Dashboard](<https://devfeed.tech/articles/opendronelog-a-self-hosted-dji-flight-log-dashboard-10736.md>)

Original publisher: [Read original article](<https://noted.lol/opendronelog/>)

Author: Jeremy

Published: 2026-03-02T14:34:38Z

Content type: article

Language: en

Sources: [Noted](<https://devfeed.tech/sources/noted.md>)

Topics: [Flight](<https://devfeed.tech/topics/flight.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [Self-hosted](<https://devfeed.tech/topics/self-hosted.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Docker](<https://devfeed.tech/topics/docker.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [React](<https://devfeed.tech/topics/react.md>), [Tauri](<https://devfeed.tech/topics/tauri.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>)

Tags: [docker](<https://devfeed.tech/tags/docker.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [local](<https://devfeed.tech/tags/local.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [maps](<https://devfeed.tech/tags/maps.md>), [react](<https://devfeed.tech/tags/react.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>), [self-hosted-logging](<https://devfeed.tech/tags/self-hosted-logging.md>), [storage](<https://devfeed.tech/tags/storage.md>), [tauri](<https://devfeed.tech/tags/tauri.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>)

### 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](<https://devfeed.tech/articles/how-i-use-obsidian-37185.md>)

Original publisher: [Read original article](<https://calv.info/how-i-use-obsidian>)

Author: Calvin French-Owen

Published: 2026-01-07T22:00:00Z

Content type: tutorial

Language: en

Sources: [Calvin French-Owen](<https://devfeed.tech/sources/calvin-french-owen.md>)

Topics: [Obsidian](<https://devfeed.tech/topics/obsidian-md.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Markdown](<https://devfeed.tech/topics/markdown.md>), [Claude Code](<https://devfeed.tech/topics/claude-code.md>)

Tags: [local-first](<https://devfeed.tech/tags/local-first.md>), [markdown](<https://devfeed.tech/tags/markdown.md>), [notes](<https://devfeed.tech/tags/notes.md>), [obsidian](<https://devfeed.tech/tags/obsidian.md>), [research](<https://devfeed.tech/tags/research.md>), [setup](<https://devfeed.tech/tags/setup.md>), [template](<https://devfeed.tech/tags/template.md>)

### 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](<https://devfeed.tech/articles/how-we-built-the-turso-shell-in-the-browser-5971.md>)

Original publisher: [Read original article](<https://turso.tech/blog/how-we-built-the-turso-shell-in-the-browser>)

Author: Jamie Barton

Published: 2025-10-14T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Turso](<https://devfeed.tech/topics/turso.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [WebAssembly](<https://devfeed.tech/topics/web-assembly.md>), [Vite](<https://devfeed.tech/topics/vite.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [React](<https://devfeed.tech/topics/react.md>), [TypeScript](<https://devfeed.tech/topics/typescript.md>), [Tailwind CSS](<https://devfeed.tech/topics/tailwind.md>), [Web Development](<https://devfeed.tech/topics/web-development.md>)

Tags: [local-first](<https://devfeed.tech/tags/local-first.md>), [offline](<https://devfeed.tech/tags/offline.md>), [react](<https://devfeed.tech/tags/react.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [sync](<https://devfeed.tech/tags/sync.md>), [tailwind-css](<https://devfeed.tech/tags/tailwind-css.md>), [turso](<https://devfeed.tech/tags/turso.md>), [typescript](<https://devfeed.tech/tags/typescript.md>), [vite](<https://devfeed.tech/tags/vite.md>), [webassembly](<https://devfeed.tech/tags/webassembly.md>)

### 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.

## What's new in Svelte: June 2025

DevFeed: [What's new in Svelte: June 2025](<https://devfeed.tech/articles/what-s-new-in-svelte-june-2025-3096.md>)

Original publisher: [Read original article](<https://svelte.dev/blog/whats-new-in-svelte-june-2025>)

Author: Dani Sandoval

Published: 2025-06-01T00:00:00Z

Content type: article

Language: en

Sources: [Svelte blog](<https://devfeed.tech/sources/svelte-blog.md>)

Topics: [Svelte](<https://devfeed.tech/topics/svelte.md>), [Web Development](<https://devfeed.tech/topics/web-development.md>), [Markdown](<https://devfeed.tech/topics/markdown.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>), [Game engine](<https://devfeed.tech/topics/game-engine.md>)

Tags: [2025](<https://devfeed.tech/tags/2025.md>), [agent](<https://devfeed.tech/tags/agent.md>), [ai-models](<https://devfeed.tech/tags/ai-models.md>), [blog](<https://devfeed.tech/tags/blog.md>), [blog-post](<https://devfeed.tech/tags/blog-post.md>), [browser](<https://devfeed.tech/tags/browser.md>), [extension](<https://devfeed.tech/tags/extension.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [markdown](<https://devfeed.tech/tags/markdown.md>), [svelte](<https://devfeed.tech/tags/svelte.md>)

### AI overview

This June 2025 Svelte update covers ongoing Async Svelte work, the introduction of Attachments as a more flexible alternative to actions, and several improvements to Svelte, SvelteKit, and language tools. It also showcases applications built with Svelte and highlights related community videos and articles involving AI models and GitHub Copilot.

### Source excerpt

In addition to advancing the work on Async Svelte, the maintainers have been hard at work introducing long requested features like Attachments. This month, we'll share a bit about the new API along with a huge showcase of apps/sites built with Svelte... Let's dive in! What's new in Svelte and SvelteKit Attachments are essentially a more flexible and modern version of actions. Read more about their use-cases and improvements over actions in the PR (#1500) or in the Svelte docs (svelte@5.29.0, language-tools@109.7.0) Do you have actions you love and want to use them as attachments? The fromAction utility lets you convert actions into attachments (svelte@5.32.0, #15933) Generics are now allowed on snippets - improving typing and type hints (svelte@5.30.0, language-tools@109.8.0, #15915) The Svelte extension will now allow you to add missing imports on save (language-tools@109.6.0, #2744) State fields can now be declared inside class constructors (svelte@5.31.0, #15820) Svelte is now XHTML compliant and the new fragments: 'html' | 'tree' option adds wider CSP compliance (svelte@5.33.0, #15538) Client-side code is now allowed to run at the top-level of universal pages/layouts when SSR is disabled and page options are only boolean or string literals (kit@2.21.0, #13684) For a full list of bug fixes in Svelte, SvelteKit and its adapters, check out their CHANGELOGs here and here. Community ShowcaseApps & Sites built with Svelte Whimsy is a small game engine and a fantasy console for making interactive stories DASHBOT is a 1v1 Space Robot Sprint Battle game for two players - with local and online modes Kraa is a web-based markdown editor that does things a little differently Shovel AI is a batch tool for interacting with large amounts of a text data with AI models md.uy is a collaborative, local-first, peer-to-peer markdown editor BringYourAI is a browser extension that provides instant codebase context on any AI chat website Joe Malatesta figured out a way to present his fi

## 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](<https://devfeed.tech/articles/we-rewrote-large-parts-of-our-api-in-go-using-ai-we-are-now-ready-to-handle-one-billion-databases-6100.md>)

Original publisher: [Read original article](<https://turso.tech/blog/we-rewrote-large-parts-of-our-api-in-go>)

Author: Avinash Sajjanshetty

Published: 2025-05-29T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [API](<https://devfeed.tech/topics/api.md>), [Mobile](<https://devfeed.tech/topics/mobile.md>), [Turso](<https://devfeed.tech/topics/turso.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Go Language](<https://devfeed.tech/topics/go-language.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [api](<https://devfeed.tech/tags/api.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [databases](<https://devfeed.tech/tags/databases.md>), [go](<https://devfeed.tech/tags/go.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [serverless](<https://devfeed.tech/tags/serverless.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [turso](<https://devfeed.tech/tags/turso.md>)

### 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.

## Designing a minimal, local-first version of lichess.

DevFeed: [Designing a minimal, local-first version of lichess.](<https://devfeed.tech/articles/designing-a-minimal-local-first-version-of-lichess-39402.md>)

Original publisher: [Read original article](<https://blog.pranshu-raj.in/posts/designing-tinychess/>)

Author: Pranshu Raj

Published: 2025-05-10T15:22:00Z

Content type: article

Language: en

Sources: [Pranshu Raj - blog on backend systems, performance and sidequests](<https://devfeed.tech/sources/pranshu-raj-blog-on-backend-systems-performance-and-sidequests.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [Go](<https://devfeed.tech/topics/go.md>), [WebSocket](<https://devfeed.tech/topics/websocket.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [JavaScript](<https://devfeed.tech/topics/javascript.md>), [Requirements](<https://devfeed.tech/topics/requirements.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Persistence](<https://devfeed.tech/topics/persistence.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [rate-limiting](<https://devfeed.tech/topics/rate-limiting.md>)

Tags: [concurrency](<https://devfeed.tech/tags/concurrency.md>), [go](<https://devfeed.tech/tags/go.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [latency](<https://devfeed.tech/tags/latency.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [persistence](<https://devfeed.tech/tags/persistence.md>), [rate-limiting](<https://devfeed.tech/tags/rate-limiting.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [requirements](<https://devfeed.tech/tags/requirements.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [websockets](<https://devfeed.tech/tags/websockets.md>)

### 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](<https://devfeed.tech/articles/offline-sync-public-beta-6079.md>)

Original publisher: [Read original article](<https://turso.tech/blog/turso-offline-sync-public-beta>)

Author: Jamie Barton

Published: 2025-03-31T00:00:00Z

Content type: news

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Turso](<https://devfeed.tech/topics/turso.md>), [libSQL](<https://devfeed.tech/topics/libsql.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Embedded Replicas](<https://devfeed.tech/topics/embedded-replicas.md>), [Rust](<https://devfeed.tech/topics/rust.md>), [TypeScript](<https://devfeed.tech/topics/typescript.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [applications](<https://devfeed.tech/tags/applications.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [databases](<https://devfeed.tech/tags/databases.md>), [embedded-replicas](<https://devfeed.tech/tags/embedded-replicas.md>), [local](<https://devfeed.tech/tags/local.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [offline](<https://devfeed.tech/tags/offline.md>), [rust](<https://devfeed.tech/tags/rust.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [sync](<https://devfeed.tech/tags/sync.md>), [turso](<https://devfeed.tech/tags/turso.md>), [typescript](<https://devfeed.tech/tags/typescript.md>)

### 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](<https://devfeed.tech/articles/local-first-sqlite-cloud-connected-with-turso-embedded-replicas-5998.md>)

Original publisher: [Read original article](<https://turso.tech/blog/local-first-cloud-connected-sqlite-with-turso-embedded-replicas>)

Author: Jamie Barton

Published: 2025-03-24T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Turso](<https://devfeed.tech/topics/turso.md>), [Embedded Replicas](<https://devfeed.tech/topics/embedded-replicas.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [data](<https://devfeed.tech/topics/data.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [embedded](<https://devfeed.tech/tags/embedded.md>), [embedded-replicas](<https://devfeed.tech/tags/embedded-replicas.md>), [latency](<https://devfeed.tech/tags/latency.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [replication](<https://devfeed.tech/tags/replication.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [sync](<https://devfeed.tech/tags/sync.md>), [turso](<https://devfeed.tech/tags/turso.md>)

### 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](<https://devfeed.tech/articles/local-first-18555.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/local-first-experience>)

Author: Javi Santana

Published: 2025-03-17T00:00:00Z

Content type: article

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [local](<https://devfeed.tech/tags/local.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [product-updates](<https://devfeed.tech/tags/product-updates.md>), [project](<https://devfeed.tech/tags/project.md>)

### 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](<https://devfeed.tech/articles/ship-data-as-you-ship-code-tinybird-becomes-local-first-18701.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/tinybird-is-local-first>)

Author: Javi Santana

Published: 2025-02-05T00:00:00Z

Content type: release

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [Development](<https://devfeed.tech/topics/development.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [development](<https://devfeed.tech/tags/development.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [product-updates](<https://devfeed.tech/tags/product-updates.md>)

### 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](<https://devfeed.tech/articles/local-rag-with-ollama-mistral-and-turso-5999.md>)

Original publisher: [Read original article](<https://turso.tech/blog/local-rag-with-ollama-and-turso-sqlite>)

Author: Jamie Barton

Published: 2025-01-08T00:00:00Z

Content type: tutorial

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Retrieval-Augmented Generation](<https://devfeed.tech/topics/retrieval-augmented-generation.md>), [Ollama](<https://devfeed.tech/topics/ollama.md>), [Turso](<https://devfeed.tech/topics/turso.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [libSQL](<https://devfeed.tech/topics/libsql.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Chat Bot](<https://devfeed.tech/topics/chatbot.md>), [pdf](<https://devfeed.tech/topics/pdf.md>)

Tags: [build](<https://devfeed.tech/tags/build.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [llm](<https://devfeed.tech/tags/llm.md>), [local](<https://devfeed.tech/tags/local.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [mistral](<https://devfeed.tech/tags/mistral.md>), [offline](<https://devfeed.tech/tags/offline.md>), [ollama](<https://devfeed.tech/tags/ollama.md>), [on-device](<https://devfeed.tech/tags/on-device.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [rag](<https://devfeed.tech/tags/rag.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [text-generation](<https://devfeed.tech/tags/text-generation.md>), [turso](<https://devfeed.tech/tags/turso.md>), [vector](<https://devfeed.tech/tags/vector.md>)

### 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](<https://devfeed.tech/articles/5-non-llm-software-trends-to-be-excited-about-39081.md>)

Original publisher: [Read original article](<https://read.engineerscodex.com/p/5-non-llm-software-trends-to-be-excited>)

Author: Engineer's Codex

Published: 2024-11-12T07:31:23Z

Content type: opinion

Language: en

Sources: [Engineer's Codex](<https://devfeed.tech/sources/engineer-s-codex.md>)

Topics: [Local-First](<https://devfeed.tech/topics/local-first.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Software Engineering](<https://devfeed.tech/topics/software-engineering.md>), [client](<https://devfeed.tech/topics/client.md>), [Data structures](<https://devfeed.tech/topics/data-structures.md>)

Tags: [client](<https://devfeed.tech/tags/client.md>), [data-structures](<https://devfeed.tech/tags/data-structures.md>), [latency](<https://devfeed.tech/tags/latency.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [software-engineering](<https://devfeed.tech/tags/software-engineering.md>)

### 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

## Introducing Offline Writes for Turso

DevFeed: [Introducing Offline Writes for Turso](<https://devfeed.tech/articles/introducing-offline-writes-for-turso-5983.md>)

Original publisher: [Read original article](<https://turso.tech/blog/introducing-offline-writes-for-turso>)

Author: Glauber Costa

Published: 2024-10-25T00:00:00Z

Content type: release

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [Per-user Database](<https://devfeed.tech/topics/per-user-database.md>)

Tags: [announcement](<https://devfeed.tech/tags/announcement.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [embedded-replicas](<https://devfeed.tech/tags/embedded-replicas.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [multi-tenancy](<https://devfeed.tech/tags/multi-tenancy.md>), [offline](<https://devfeed.tech/tags/offline.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [sync](<https://devfeed.tech/tags/sync.md>), [turso](<https://devfeed.tech/tags/turso.md>)

### AI overview

Turso announces a private beta for Offline Writes, allowing local embedded replicas to accept writes while online or offline and synchronize them to Turso Cloud later.

### Source excerpt

Turso is opening a private beta for Offline Writes, letting you write to local embedded replicas at file speed and sync to Turso Cloud when reconnected.

## Turso: Databases For All Your AI Apps

DevFeed: [Turso: Databases For All Your AI Apps](<https://devfeed.tech/articles/turso-databases-for-all-your-ai-apps-5929.md>)

Original publisher: [Read original article](<https://turso.tech/blog/databases-for-all-your-ai-apps>)

Author: Glauber Costa

Published: 2024-10-21T00:00:00Z

Content type: news

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [Turso](<https://devfeed.tech/topics/turso.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [AI Development](<https://devfeed.tech/topics/ai-development.md>), [AI Agent](<https://devfeed.tech/topics/ai-agent.md>), [libSQL](<https://devfeed.tech/topics/libsql.md>), [Platform API](<https://devfeed.tech/topics/platform-api.md>), [LangChain](<https://devfeed.tech/topics/langchain.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [quantization](<https://devfeed.tech/topics/quantization.md>), [iOS](<https://devfeed.tech/topics/ios.md>), [Mobile](<https://devfeed.tech/topics/mobile.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [databases](<https://devfeed.tech/tags/databases.md>), [ios](<https://devfeed.tech/tags/ios.md>), [langchain](<https://devfeed.tech/tags/langchain.md>), [libsql](<https://devfeed.tech/tags/libsql.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [platform-api](<https://devfeed.tech/tags/platform-api.md>), [quantization](<https://devfeed.tech/tags/quantization.md>), [turso](<https://devfeed.tech/tags/turso.md>)

### 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](<https://devfeed.tech/articles/local-first-ai-assistant-kin-leverages-turso-s-libsql-for-on-device-native-vector-search-5997.md>)

Original publisher: [Read original article](<https://turso.tech/blog/local-first-ai-assistant-kin-leverages-tursos-libsql-for-on-device-native-vector-search>)

Author: Simon Westh Henriksen

Published: 2024-10-21T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [libSQL](<https://devfeed.tech/topics/libsql.md>), [Turso](<https://devfeed.tech/topics/turso.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [AI search](<https://devfeed.tech/topics/ai-search.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [Retrieval Augmented Generation (RAG)](<https://devfeed.tech/topics/retrieval-augmented-generation-rag.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Mobile](<https://devfeed.tech/topics/mobile.md>), [Latency](<https://devfeed.tech/topics/latency.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [libsql](<https://devfeed.tech/tags/libsql.md>), [local](<https://devfeed.tech/tags/local.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [mobile](<https://devfeed.tech/tags/mobile.md>), [on-device](<https://devfeed.tech/tags/on-device.md>), [rag](<https://devfeed.tech/tags/rag.md>), [react](<https://devfeed.tech/tags/react.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [vector-search](<https://devfeed.tech/tags/vector-search.md>)

### 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](<https://devfeed.tech/articles/mongodb-realm-device-sync-alternatives-supabase-457.md>)

Original publisher: [Read original article](<https://supabase.com/blog/mongodb-realm-and-device-sync-alternatives>)

Author: Craig Cannon

Published: 2024-10-09T07:00:00Z

Content type: article

Language: en

Sources: [Supabase Blog](<https://devfeed.tech/sources/supabase-blog.md>)

Topics: [Supabase](<https://devfeed.tech/topics/supabase.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [Low Latency](<https://devfeed.tech/topics/low-latency.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [Database](<https://devfeed.tech/topics/database.md>), [React Native](<https://devfeed.tech/topics/react-native.md>)

Tags: [alternatives](<https://devfeed.tech/tags/alternatives.md>), [announcement](<https://devfeed.tech/tags/announcement.md>), [integration](<https://devfeed.tech/tags/integration.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [offline](<https://devfeed.tech/tags/offline.md>), [outages](<https://devfeed.tech/tags/outages.md>), [partner](<https://devfeed.tech/tags/partner.md>), [performance](<https://devfeed.tech/tags/performance.md>), [react-native](<https://devfeed.tech/tags/react-native.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [sync](<https://devfeed.tech/tags/sync.md>)

### 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.

## Building Vector Search and Personal Knowledge Graphs on Mobile with libSQL and React Native

DevFeed: [Building Vector Search and Personal Knowledge Graphs on Mobile with libSQL and React Native](<https://devfeed.tech/articles/building-vector-search-and-personal-knowledge-graphs-on-mobile-with-libsql-and-react-native-5908.md>)

Original publisher: [Read original article](<https://turso.tech/blog/building-vector-search-and-personal-knowledge-graphs-on-mobile-with-libsql-and-react-native>)

Author: Volodymyr Pavlyshyn

Published: 2024-10-02T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [AI search](<https://devfeed.tech/topics/ai-search.md>)

Tags: [ai-agent](<https://devfeed.tech/tags/ai-agent.md>), [graphs](<https://devfeed.tech/tags/graphs.md>), [libsql](<https://devfeed.tech/tags/libsql.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [mobile](<https://devfeed.tech/tags/mobile.md>), [on-device](<https://devfeed.tech/tags/on-device.md>), [rag](<https://devfeed.tech/tags/rag.md>), [react-native](<https://devfeed.tech/tags/react-native.md>), [search](<https://devfeed.tech/tags/search.md>), [vector](<https://devfeed.tech/tags/vector.md>)

### AI overview

Kin describes building on-device vector search and personal knowledge graphs for a React Native mobile AI application using libSQL.

### Source excerpt

How Kin built on-device vector search and personal knowledge graphs for iOS and Android using libSQL bindings and React Native, with no cloud dependency.

## Personal Knowledge Graphs in AI RAG-powered Applications with libSQL

DevFeed: [Personal Knowledge Graphs in AI RAG-powered Applications with libSQL](<https://devfeed.tech/articles/personal-knowledge-graphs-in-ai-rag-powered-applications-with-libsql-6020.md>)

Original publisher: [Read original article](<https://turso.tech/blog/personal-knowledge-graphs-in-ai-rag-powered-applications-with-libsql>)

Author: Volodymyr Pavlyshyn

Published: 2024-09-30T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [libSQL](<https://devfeed.tech/topics/libsql.md>), [Retrieval Augmented Generation (RAG)](<https://devfeed.tech/topics/retrieval-augmented-generation-rag.md>), [Graphs](<https://devfeed.tech/topics/graphs.md>), [Embeddings](<https://devfeed.tech/topics/embeddings.md>), [Local-First](<https://devfeed.tech/topics/local-first.md>), [Mobile](<https://devfeed.tech/topics/mobile.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [databases](<https://devfeed.tech/tags/databases.md>), [embeddings](<https://devfeed.tech/tags/embeddings.md>), [graphs](<https://devfeed.tech/tags/graphs.md>), [libsql](<https://devfeed.tech/tags/libsql.md>), [local-first](<https://devfeed.tech/tags/local-first.md>), [mobile](<https://devfeed.tech/tags/mobile.md>), [rag](<https://devfeed.tech/tags/rag.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

### 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](<https://devfeed.tech/tags/local-first.md?cursor=WyIyMDI0LTA5LTMwVDAwOjAwOjAwKzAwOjAwIiwgIjQ5YmYwMjYyLWRkMzItNDVlMS1iNzI4LWMzOTg5YmRkM2JjMSJd>)