alchemy-utils 0.1a0: A database-agnostic take on sqlite-utils
OpenAI
Simon Willison released alchemy-utils, a prototype library that mirrors the sqlite-utils API but uses SQLAlchemy to support multiple database engines. Built with the help of Codex and GPT-5.6 Sol Ultra, it is now available as an alpha version and can be used via a one-liner CLI command.
Simon Willison announced alchemy-utils 0.1a0, a prototype library he created with AI assistance from Codex and GPT-5.6 Sol Ultra. The goal was to build a database-agnostic version of his sqlite-utils library, keeping the same core API methods like insert, upsert, insert_all, upsert_all, create, and update, plus table introspection, but backed by SQLalchemy to work with multiple database engines. He tested it against PostgreSQL, SQLite, and DuckDB, and used a test-driven development approach with pytest. The result is good enough for an alpha release. He demonstrates using it via the command line to list rows from a PostgreSQL database and to insert a CSV of San Francisco trees into a DuckDB database, with performance optimized from nearly an hour to about 35 seconds.
- Abbreviations
- CLI = Command-Line Interface — интерфейс командной строки
- CSV = Comma-Separated Values — значения, разделённые запятыми
- API = Application Programming Interface — программный интерфейс приложения
- TDD = Test-Driven Development — разработка через тестирование
Source: Simon Willison —
original