alchemy-utils 0.1a0 · Simon Willison's Weblog
Science, Technology & Innovation · Aug 12, 2026
The alpha offers a single `uvx` command using `alchemy-utils[postgresql]` to inspect local PostgreSQL tables and output actual rows as structured JSON, without requiring a separate PostgreSQL CLI client.
alchemy-utils 0.1a0 · Simon Willison's Weblog
Science, Technology & Innovation · Aug 12, 2026
An alpha database-agnostic successor to sqlite-utils uses SQLAlchemy to provide compatible insert, upsert, bulk, schema, update, and introspection operations across PostgreSQL, SQLite, and DuckDB, enabling one workflow for embedded and production databases.
alchemy-utils 0.1a0 · Simon Willison's Weblog
Science, Technology & Innovation · Aug 12, 2026
A DuckDB ingestion workflow automatically creates a schema while streaming a remote CSV into a local table, with optimization reducing runtime from nearly an hour to about 35 seconds—a roughly 100× improvement.