{"library":"piccolo","type":"library","category":null,"description":"Piccolo is a fast, user-friendly, and fully type-annotated ORM and query builder for Python, primarily focused on asynchronous operations. It supports PostgreSQL, SQLite, and CockroachDB, and comes with batteries included like migrations, an admin GUI, and ASGI application templates. Currently at version 1.33.0, Piccolo releases frequently, often with minor version bumps every few weeks, incorporating new features and improvements.","language":"python","status":"active","version":"1.33.0","tags":["ORM","async","database","SQL","PostgreSQL","SQLite","CockroachDB","migrations","admin-gui"],"install":[{"cmd":"pip install piccolo","imports":["from piccolo.table import Table","from piccolo.columns import Varchar","from piccolo.columns import Integer","from piccolo.engine.sqlite import SQLiteEngine","from piccolo.engine.postgres import PostgresEngine"]},{"cmd":"pip install \"piccolo[all]\"","imports":[]},{"cmd":"pip install \"piccolo[postgres]\"","imports":[]}],"homepage":"https://piccolo-orm.com","github":"https://github.com/piccolo-orm/piccolo","docs":"https://piccolo-orm.readthedocs.io/en/latest/index.html","changelog":null,"pypi":"https://pypi.org/project/piccolo/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":6.8,"avg_import_s":0.52,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/piccolo/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":null}}