Back to feed

alchemy-utils 0.1a0

Simon Willison's Weblog

Aug 12, 2026

8/12/2026

Uvx Alpha Delivers Dependency-Scoped CLI For PostgreSQL Table Inspection With Structured JSON Rows

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.


8/12/2026

Database-Agnostic Sqlite-Utils Reaches Alpha With SQLAlchemy Backend Enabling Cross-Engine Workflows Across PostgreSQL SQLite And DuckDB

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.


8/12/2026

Significant Performance Improvement With Automatic Schema Creation For CSV Ingestion Into DuckDB

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.