GoKawiil
Tech News
A developer released Capsule, a tool for building self-contained web apps that embed their own SQLite database within a single file. The apps run without requiring cloud servers, user accounts, or an internet connection, keeping all data stored locally on the user's device.
A developer released Solid Objects, an open-source library that replicates the Durable Objects programming model—one identity, one state, one ordered mailbox per object—without requiring a dedicated vendor runtime or daemon. Instead, it runs directly on databases developers already operate, including SQLite, PostgreSQL, and MySQL. The release follows the creator's frustration with vendor lock-in and unpredictable metered billing tied to existing Durable Objects platforms.
A new open-source tool called Engrim gives AI coding assistants persistent, project-level memory stored in a local SQLite database rather than tied to any single vendor's cloud. It lets developers switch between tools like Claude Code, Cursor, Windsurf and Google Antigravity mid-project while retaining architectural decisions and constraints, using a hybrid search combining SQLite FTS5 keyword search with lightweight vector embeddings. The creator reports it was validated over 105 sessions on a 50,000-line trading codebase with zero regressions and no loss of context across model switches.
DoltLite, a fork of SQLite that swaps its B-tree storage layer for a Git-style Prolly Tree engine, has reached Beta status at version 0.50.0 just five months after launch. The project reuses SQLite's SQL parser, analyzer and file system code untouched, while the underlying storage was rebuilt to support branching, merging, diffing and syncing like Dolt and Git. The maintainers say the work was largely completed through around 2,000 pull requests generated by AI coding agents using an orchestrator called Gas Town.
Following up on his earlier SELF executable format that stores a program as a SQLite database, the author released self-httpd, a proof-of-concept web server whose code, website, routes, and visitor logs all live in a single SQLite file. The program reads its own instructions and writes new state, such as button-press logs, back into that same file transactionally, eliminating the need for separate folders like /var, /tmp, or /home.
LatticeDB is a new single-file, embedded property-graph database that supports graph traversal, HNSW-based vector similarity search, and BM25 full-text search through one unified query language. It requires no server or configuration, targets single-machine relationship-heavy workloads, and shares its transaction log across graph writes and event streams for durability.
A developer created SELF (Structured Executable & Linkable Format), a prototype that replaces the traditional ELF executable format with a SQLite database file that can actually be run directly. The project builds on earlier work called sqlelf, which allowed users to query ELF binaries using SQL, and is now available on GitHub.