GoKawiil
Tech News
A new web app called editsqlite allows users to open SQLite databases, SQL dumps from MySQL, Postgres or SQLite, and CSV files directly in the browser without uploading them to a server. Users can edit data in a spreadsheet-like grid or via a built-in SQL console, then export a freshly rebuilt file in several formats. The tool processes files entirely client-side and never writes to the original file.
The developer behind rqlite, an open-source system that pairs SQLite with the Raft consensus protocol, published a retrospective marking the project's origin in September 2014. He recounts building it to solve a storage problem at jut.io, switching its Raft implementation from goraft to Hashicorp's Raft in 2016, and designing it as a CP system where writes require majority acknowledgment through a leader node.
A developer published 'whatsapp-mcp,' an open-source project that lets AI assistants like Claude search and read a user's WhatsApp messages. Users link their phone like WhatsApp Web, and the server stores message data in a SQLite database inside a Cloudflare Durable Object under their own account. The tool can read, search and recall contact names but cannot send messages, and requires a Cloudflare Workers Paid plan to run.
Corey Prophitt shipped a commercial product, marketyour.games, built with the BCHS stack: OpenBSD, C, httpd and SQLite. The app includes user accounts, a search dashboard, folder organization, Stripe payments and Postmark emails, served through CGI binaries rather than a modern framework. Deployment consists of replacing a single statically linked binary, relying on only three external libraries: libcurl, libsodium and libcjson.
APSW (Another Python SQLite Wrapper) is an open-source library that exposes the complete SQLite C API to Python, including features like full text search, sessions, virtual tables, VFS, JSON, and CArray. It supports CPython 3.10 and later, works with synchronous code and async frameworks, and is distributed via PyPI and GitHub under an OSI-approved open source license.
Cloudflare engineers describe building a deterministic simulation testing (DST) tool for celld, a runtime for running Workers and Durable Objects applications outside Cloudflare's infrastructure using only an S3-compatible object store as an external dependency. The simulator, still in development and not yet public, controls event ordering, timing, and storage responses so that failures involving delayed messages, failed writes, or node restarts can be reliably reproduced and debugged.
A personal computing writer describes switching away from Emacs to the macOS/iOS note app Bear, citing fatigue with Emacs and Org mode, before reversing course and moving all notes back into Emacs using the Denote package, which supports Markdown files natively. The migration involved exporting Bear's Markdown notes and using a Claude Code-assisted script to convert file names, links, and attachments.
In an interview, CHICKEN Scheme maintainer and co-maintainer of the irregex library Peter Bex described his path from a childhood C64 into BASIC, C, and eventually Lisp/Scheme, which he studied at university through The Little Lisper/Schemer and SICP. He discussed his ongoing core contributions to CHICKEN Scheme, including numerical tower code, irregex upkeep, bug fixes and security patches, alongside broader topics like Scheme standardization, databases, and Clojure.
Supabase announced it is acquiring Turso, a company that rebuilt SQLite in Rust and built a cloud platform letting a single server manage millions of lightweight databases. Supabase said existing users on either platform won't see immediate changes: it will keep building on Postgres while Turso continues its SQLite work, with the two eventually integrated into one ecosystem.
Jevotron is a new command-line tool that scans files such as CSV, YAML, JSON, TOML and OBO for anomalies, producing field-level probability scores and a review queue. The tool caches results in SQLite so unchanged entries aren't reassessed on subsequent runs, and users can guide scans with text instructions or a local Python config. A pilot test on 24 public agent traces reported the tool matched 130 of 163 step-quality labels (79.8% accuracy), with 89.7% precision and 70.3% recall for identifying harmful steps.
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.