Claim◆Video · 7:00 · 9m
Verscel's new TypeScript-to-native compiler, Scriptic, produces tiny standalone binaries — ideal for CLI tools and embedded use cases where shipping a Node.js runtime is impractical.
CJ · Syntax
ExampleArticle
sqlite-utils query can now read the SQL query from standard input by passing a hyphen in place of the query argument, enabling piped usage like echo "select * from dogs" | sqlite-utils query dogs.db -.
The query command gains stdin support, allowing SQL to be piped in rather than passed as a literal argument. ✦ AI generated
Simon Willison · Simon Willison's Weblog · 2026-07-11 · original ↗
sqlite-utils query can now read the SQL query from standard input by passing - in place of the query, for example echo "select * from dogs" | sqlite-utils query dogs.db -.
Read full article ↗excerpt · fair-use quotation
Related moments
Fact◆Article · 34 words
The biggest new feature in this release is support for introspecting and creating compound foreign keys, and because that involves a subtle breaking change to table.foreign_keys, it had to land before the 4.0 stable release.
Simon Willison · Simon Willison's Weblog
Mechanism◆Article · 40 words
Table.delete_where() never wraps its DELETE in a transaction, so it fails to commit and leaves the database connection permanently poisoned, causing silent data loss on subsequent operations.
Claude Fable · Simon Willison's Weblog