2024.08.08

📰 News & Discussions

The SQLite Takeover with Turso’s Glauber Costa

The Syntax.fm podcast interviews Glauber Costa (@glcst) regarding Turso, a distributed SQLite platform getting attention for its managed service and libSQL fork.

GenAI Predictions and The Future of LLMs as local-first offline SLMs

@liran_tal discusses issues with online third-party LLMs, and argues that "the future of LLMs is in local-first offline inference", and it starts with the use of "offline Small Language Models (SLMs)".

How to run a local LLM for inference with an offline-first approach

Also by @liran_tal: describing tools for running local LLMs.

"Offline-first is the future of the web"

@DanniFriedland summarizes some of the major benefits of offline-first for development teams.

Leveraging Local-First Personal AI in the Decentralized Space

Summary of a talk by @simonwh on learnings from building local-first personal AI.

Collaboration is a spectrum from asynchronous to fully synchronous

@jessmartin shares lab notes regarding working styles for collaborative software falling on a spectrum.

Now We Know What Local-First Means

@GermanJablo muses on the definition of local-first and how it compares to offline-first, points out perceived issues with local-first, and argues for new terminology ("public sync").

🛠️ Tools & Resources

Bruinen Delta

Bruinen Delta is a distributed SQLite database built specifically for edge computing environments.

Basic

Basic ("a new database focused on privacy, user-owned data, and local-first") announces hacker preview.

Limbo

"Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite."

Semantic search in-browser using PGLite

@thorwebdev shows a demo of in-browser semantic search using @huggingface's Transformers.js and ElectricSQL's pglite.

✨ Apps

Anytype

Anytype ("the everything app for those who celebrate trust & autonomy") recently announced its 0.42.0 release, emphasizing its local-first bonafides.

How to Contribute

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