Thursday, July 17, 2025

The Digital Press

All the Bits Fit to Print

Ruby
Web Development Artificial Intelligence
Urban Planning
Astronomy

Piccolo: Async Python ORM with Query Builder and Admin GUI

Async ORM and query builder with admin GUI for Python developers

From Hacker News Original Article Hacker News Discussion

A new async ORM and query builder offers robust support for Postgres, SQLite, and CockroachDB, featuring both synchronous and asynchronous operations with an integrated admin GUI.

Why it matters: Simplifies database interactions with async support, essential for modern web development and data science workflows.

The big picture: Combines type-annotated modern Python with built-in models, authentication, migrations, and admin tools for a full-stack developer experience.

Quick takeaway: Includes a playground for easy learning, tab completion for iPython and VSCode, and supports complex queries like joins and updates.

Commenters say: Users appreciate the ease of use, async functionality, and built-in admin, while some seek more advanced customization options.