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.