sqlite-utils 4.1 Released
Simon Willison · rss · 2026-07-12
sqlite-utils has released version **4.1**, the first minor update since 4.0, adding several detailed features: - `insert` and `upsert` now include a `--code` option, allowing you to provide a Python code snippet or script file directly to generate rows for insertion. - `insert` / `upsert` now support `--type` to manually override inferred column types, preventing strings like zip codes from being stored as integers. - Added a `drop_index` method and `drop-index` CLI command to delete indexes by name, with support for ignoring non-existent indexes. - `query` can now read SQL from standard input using `-`. - `upsert` can automatically infer the primary key of an existing table, reducing the need to repeatedly type `--pk`. - `transform()` / `transform_sql()` and the CLI `transform` now feature `strict` options to toggle between SQLite strict and non-strict modes. The author noted that parts of this implementation involved having **GPT-5.6 Codex** manually test the new `transform(strict=)` option, which led to the discovery and fixing of two minor bugs.
More from coding & agent
- Codex turns out 123 screensavers in one playful batch — intellectronica · 2026-07-21
- Grok Build adds `grok doctor`, resumable sessions and remote image paste — mark_k · 2026-07-21
- Autoresearch proposes packaging ML runs as studies with questions, analysis, and code diffs — morgymcg · 2026-07-21
- CHAP defines approvals, handoffs, and audit logs for human-agent workflows — DeliveryTechnical199 · 2026-07-21
- The author says Codex reached 20x and is now debugging spec decoding on a hybrid parallel setup — TheZachMueller · 2026-07-21
- Axcess adds an MCP connector for WCAG accessibility checks that scanners miss — modelcontextprotocol · 2026-07-21