2024.08.15

📰 News & Discussions

Fireproof Uses Merkle CRDTs to Cut Database Latency

"The low latency, run-anywhere database combines cryptographic technologies with linked data and distributed computing approaches."

localfirst.fm #13 – Maggie Appleton: Barefoot Developers, AI, end-user programming

The guest of the latest episode of localfirst.fm is Maggie Appleton (@Mappletons), a designer, anthropologist and developer who has recently explored the world of local-first by giving the closing keynote at Local-First Conf.

Local-First, Now and Always!

Post by Lukas Werner regarding building a POC with CR-SQLite, which allows merging different SQLite databases together that have taken independent writes.

Replicache vs. The World: Solving Web App Sync Challenges with Cutting-Edge Technology

Exploration of implementing Replicache. Repost of article by @isaachagoel that previously appeared here.

🛠️ Tools & Resources

Local Vault

"Local Vault is a new library that provides a simple key-val storage abstraction across various client-side storage mechanisms, and automatically handles encryption via a key that's protected in a biometric passkey (TouchID, FaceID, etc)." - @getifyX

Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync

v0.2 release of PGlite — a WASM Postgres build packaged into a TypeScript/JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun.

postgres.new: In-browser Postgres with an AI interface

"It’s like if ChatGPT and Postgres had a love-child: launch as many databases as you want, build them with AI, create charts, create embeddings." - @kiwicopple

Show HN: Pg_replicate – Build Postgres replication applications in Rust

"pg_replicate lets you very easily build applications which can copy data (full table copies and CDC) from Postgres to any other data system."

SyncLite: Bridging the Gap Between Gen AI Powered Search/RAG Applications for Edge and Cloud

"We're thrilled to introduce a solution that bridges the gap between edge and cloud for Gen AI-powered search and Retrieval Augmented Generation (RAG) applications."

Embeddable and Portable Storage for AI-Powered Apps and Personal Knowledge Graphs

Summary of in-app embeddable databases: LevelDB, SQLite, LibSQL, Firebird, DuckDB, PGLite, CozoDB, Realm.

✨ Apps

Onlook

"Onlook lets you visually edit your React app and write your changes back to code in real-time". "[T]he enthusiasm behind https://onlook.dev being local-first was certainly surprising" - @D_R_Farell

How to Contribute

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