One could say in the first quarter-century of my life, that while I was always fascinated by programming, I could never overcome the guilt of not really knowing whether the tool I am building right now isn’t already superceded by some much better …
russellromney/honker
“Postgres NOTIFY/LISTEN semantics” for SQLite, implemented as a Rust SQLite extension and various language bindings to help make use of it.
The design of this looks very solid. It lets you write Python code for queues that lo…
Serving the For You feed
One of Bluesky’s most interesting features is that anyone can run their own custom “feed” implementation and make it available to other users – effectively enabling custom algorithms that can use any mechanism they like t…
SQLite 3.53.0
SQLite 3.52.0 was withdrawn so this is a pretty big release with a whole lot of accumulated user-facing and internal improvements. Some that stood out to me:
ALTER TABLE can now add and remove NOT NULL and CHECK constraints – I’ve …
Tool: SQLite Query Result Formatter Demo
See my notes on SQLite 3.53.0. This playground provides a UI for trying out the various rendering options for SQL result tables from the new Query Result Formatter library, compiled to WebAssembly.
…
Research: SQLite WAL Mode Across Docker Containers Sharing a Volume
Inspired by this conversation on Hacker News about whether two SQLite processes in separate Docker containers that share the same volume might run into problems due to WAL sha…
Eight years of wanting, three months of building with AI
Lalit Maganti provides one of my favorite pieces of long-form writing on agentic engineering I’ve seen in ages.
They spent eight years thinking about and then three months building syntaqli…
Tool: Syntaqlite Playground
Lalit Maganti’s syntaqlite is currently being discussed on Hacker News thanks to Eight years of wanting, three months of building with AI, a deep dive into exactly how it was built.
This inspired me to revisit a res…
After I wrote the initial teaser article “SQLite – Working with large data sets in Python effectively” about how awesome SQLite databases are via sqlite3 in…