🦞🌯 Lobster Roll

Stories by marcobambini

Why haven't local-first apps become popular? (marcobambini.substack.com)
Ultra efficient vector extension for SQLite (marcobambini.substack.com)
CRDT and SQLite: Local-First Value Synchronization (marcobambini.substack.com)
Fortran Outsmarted Our Billion-Dollar AI Chips (medium.com)
Show HN: Liteparser – a complete SQLite parser in C (marcobambini.substack.com)
SQLite-Agent: enables SQLite databases to run autonomous AI agents (github.com)
SQLite in Production? Not So Fast for Complex Queries (yyhh.org)
SQLite Vector Is Now Nix Flake Ready (cwrk.ai)
LiteParser: A fully featured embeddable SQLite parser (github.com)
Weblite: Embeddable C library for HTTP/HTTPS requests with WebSocket fallback (github.com)
SQLite-Vector: highly efficient vector extension for SQLite (github.com)
SQLite-Vector: highly efficient vector solution for SQLite (github.com)
Project AVA: 3D Hologram AI Desk Companion (razer.com)
The Secret Life of a Local-First Value (marcobambini.substack.com)
The Secret Life of a SQLite Local-First Value (marcobambini.substack.com)
The Future of Databases Is Local-First (marcobambini.substack.com)
Show HN: SQLite-RAG – A semantic search engine built on top of SQLite (github.com)
Over the past few months, we have developed a new hybrid search engine built on top of SQLite. It combines vector similarity search with full-text search (FTS5 extension) using Reciprocal Rank Fusion (RRF) for enhanced document retrieval.<p>Let us know what you think!
Assuming one transaction per second, the limit would be reached in 544.4 years (github.com)
A fix for a divergence issue in a popular CRDT library (github.com)
Gravity Language Architecture (github.com)
PolyMCP: A simple way to interact with MCP servers using custom agents (github.com)
Building a RAG on SQLite (blog.sqlite.ai)
Project LiteGate: SQLite at the Edge. Cloud-Neutral Sync. Reactive by Design (litegate.io)
The Secret Life of a Local-First SQLite Value (marcobambini.substack.com)