Piccolo
A fast, user-friendly ORM and query builder for Python with async support, batteries included.
What is Piccolo?
Piccolo is a fast, user-friendly Object-Relational Mapper (ORM) and query builder for Python. It enables developers to interact with databases using clean, expressive syntax while supporting both synchronous and asynchronous operations. The project solves the need for a modern, batteries-included database toolkit that integrates seamlessly with async web frameworks.
Python developers building web applications with ASGI frameworks like FastAPI, Starlette, or Sanic, who need a productive ORM with async support. It's also suitable for teams migrating from Django seeking a lighter, more flexible alternative.
Developers choose Piccolo for its exceptional developer experience, comprehensive feature set out of the box, and native async support. Its built-in admin interface, modular app system, and clean syntax provide a compelling alternative to heavier frameworks while maintaining power and flexibility.
Overview
A fast, user friendly ORM and query builder which supports asyncio.
Use Cases
Best For
- Building async web applications with FastAPI or Starlette
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
