sqlite-utils
PulseAugur coverage of sqlite-utils — every cluster mentioning sqlite-utils across labs, papers, and developer communities, ranked by signal.
- developed by Claude fable 90%
- used by Claude fable 70%
- affiliated with Datasette Apps 60%
- used by GPT 5.6 "Sol" 60%
- used by Moebius 0.2B 60%
- affiliated with Kimi k3 50%
- competes with Moebius 0.2B 50%
- other shot-scraper 50%
- authored by GPT 5.6 "Sol" 50%
- affiliated with shot-scraper 50%
- used by Kimi k3 50%
- 2026-07-07 product_launch Simon Willison released version 4.0 of sqlite-utils, introducing database migrations, nested transactions, and compound foreign key support. source
- 2026-07-07 product_launch Simon Willison released version 4.0 of sqlite-utils, introducing database schema migrations, nested transactions, and support for compound foreign keys. source
4 day(s) with sentiment data
-
SQLite with sqlite-vec enables cost-effective, private semantic search
A new approach to building semantic search engines bypasses cloud dependencies by utilizing SQLite with the sqlite-vec extension. This method allows for local embedding generation and vector querying on minimal hardware…
-
sqlite-utils 4.2.1 fixes bug, 4.2 enhanced table transform
Simon Willison has released version 4.2.1 of his sqlite-utils tool, fixing a bug that caused crashes. This bug was introduced in version 4.2, which itself contained significant improvements to the table.transform() feat…
-
Simon Willison releases alchemy-utils alpha with AI assistance
Simon Willison has released two alpha versions of alchemy-utils, a Python library designed to provide a database-agnostic interface similar to his existing sqlite-utils library. The project, developed with assistance fr…
-
datasette-auth-tokens plugin updated for sqlite-utils compatibility
Simon Willison has released version 0.4a13 of datasette-auth-tokens, an authentication plugin for the Datasette data exploration tool. This update ensures compatibility with the latest version of the sqlite-utils library.
-
sqlite-utils 3.39.1 released with back-ported fix, references Claude Code and Kimi K3
Simon Willison released version 3.39.1 of sqlite-utils, which includes a back-ported fix for table.delete_where() that was originally in version 4. The release notes also reference recent articles on a "Fireside Chat wi…
-
Ruff linter v0.16.0 expands default rules, uncovering project issues
The Ruff linter, developed by Astral, released version 0.16.0, significantly expanding its default enabled rules from 59 to 413. This update revealed numerous issues across various projects, with Simon Willison's sqlite…
-
Ruff v0.16.0 ships with expanded default checks, aiding AI code upgrades
Astral has released Ruff v0.16.0, significantly expanding its default rule set to include 413 checks, a substantial increase from the previous 59. This update aims to catch more severe issues, including syntax and runti…
-
Sam Altman planned local GPT-3-level model release to preempt competitors
Sam Altman, in an email exposed during the Musk v. Altman lawsuit, revealed OpenAI's intention to release a local, consumer-hardware-compatible language model with capabilities similar to GPT-3. This move, planned for O…
-
New tool explains SQLite query execution in the browser
A new browser-based tool, SQLite Query Explainer, has been developed to help users understand how SQLite executes SQL queries. Created by Julia Evans and built using Fable, it runs SQLite within Python via Pyodide and W…
-
Vintage Quixote web framework sees recent commit after 21 years
The Quixote web framework, originally developed over two decades ago, has seen recent activity with its latest commit occurring six hours prior to this report. This framework's history traces back to an import from Apac…
-
Mermaid diagram syntax converted to ASCII art with new tool
Simon Willison has developed a tool called mermaid-ascii that converts Mermaid diagram syntax into ASCII and Unicode art. This tool, built using a Go library compiled to WebAssembly, supports various diagram features li…
-
Linus Torvalds declares Linux will embrace AI as a useful tool
Linus Torvalds, the creator of Linux, has stated that Linux will not be an anti-AI project. He views AI as a useful tool, asserting that its utility is no longer in question. Torvalds indicated that any developers who d…
-
Grok CLI's Mermaid renderer adapted for browser use
Simon Willison explored the Grok CLI's Rust codebase, discovering a self-contained terminal renderer for Mermaid diagrams. He successfully integrated this renderer into a browser environment using WebAssembly. This demo…
-
GitHub Changeling adopts cooldowns; GPT-5.6 and Claude Fable referenced
Simon Willison's blog post discusses the "GitHub Changeling" feature, which now includes a default three-day cooldown period before Dependabot creates pull requests for new releases. This change aims to provide stabilit…
-
GPT-5.6 Sol and GPT-Image-2 create open-source desktop pet
Simon Willison details the creation of a custom desktop pet named "Pedalican" using Codex Desktop, which leveraged GPT-5.6 Sol for the design and GPT-Image-2 for sprite assets. The process involved iterative prompting t…
-
Lobste.rs completes migration to SQLite, reducing costs and improving performance
The community site Lobste.rs has successfully migrated from MariaDB to SQLite, completing a transition that began in August 2018. This move has resulted in decreased CPU and memory usage, improved site performance, and …
-
Datasette 1.0a37 released with performance and documentation improvements
Simon Willison has released a minor update to Datasette, version 1.0a37. This release focuses on performance and documentation enhancements for the permissions system. Additionally, a cosmetic API change that caused iss…
-
Simon Willison shares cache-friendly uvx strategy for GitHub Actions
Simon Willison has detailed a method for efficiently caching tools installed via `uvx` within GitHub Actions workflows. By setting the `UV_EXCLUDE_NEWER` environment variable to a specific date, subsequent `uvx` command…
-
SQL controls Doom game mechanics in novel DOOMQL project
Peter Gostev has developed DOOMQL, a novel Doom-like game where SQL queries control game mechanics such as movement, collision, and combat, all within a SQLite database. The game is implemented as a Python terminal scri…
-
AI Models Correlate with Surge in Open-Source Project Activity
Simon Willison observed a significant increase in his open-source project Datasette's code activity, correlating with the release of advanced AI models. He noted a spike in changes coinciding with the availability of Op…