Piccolo is a Python object-relational mapper (ORM) and query builder designed around clean, expressive syntax. It supports both synchronous and asynchronous database access, allowing developers to use it with traditional applications or asyncio-based web services.
Piccolo can be used as a full ORM or as a standalone query builder. PostgreSQL is its primary database, with additional support for CockroachDB and SQLite. It includes migration tools, a command-line interface, an interactive playground, authentication components and a modular application system similar to Django apps.
This is free and open source software.
Key Features
- Offers synchronous and asynchronous database access.
- Functions as both an ORM and a standalone query builder.
- Supports PostgreSQL, CockroachDB and SQLite databases.
- Provides clean, expressive syntax for selecting, joining, updating and deleting data.
- Includes database schema migration tools.
- Provides a built-in interactive playground for exploring queries.
- Includes a user model and authentication functionality.
- Supports modular Piccolo apps for organising larger projects.
- Provides comprehensive Python type annotations and editor completion.
- Includes a command-line interface for managing projects and migrations.
- Can scaffold ASGI applications using frameworks including FastAPI, Starlette, Litestar, Quart, Falcon and Sanic.
- Integrates with Piccolo Admin and Piccolo API.
Website: github.com/piccolo-orm/piccolo
Support:
Developer: Daniel Townsend
License: MIT License
Piccolo is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| Python Object-Relational Mapping Software | |
|---|---|
| Django | High-level web application framework that has a powerful ORM |
| SQLAlchemy | Python SQL Toolkit and Object Relational Mapper |
| Peewee | Simple, small and expressive Object Relational Mapper. It has few concepts |
| Tortoise | Easy-to-use asyncio ORM inspired by Django |
| Pony | Billed as the smartest Python ORM |
| SQLObject | Forms a part of many applications including TurboGears |
| Storm | Designed to work with thin relational databases and big systems |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |
Please read our Comment Policy before commenting.