{"repo":"piccolo-orm/piccolo","free":true,"listed":false,"github":"https://github.com/piccolo-orm/piccolo","clone":"git clone https://github.com/piccolo-orm/piccolo.git","description":"A fast, user friendly ORM and query builder which supports asyncio.","language":"Python","stars":1937,"topics":["piccolo","asyncio","python","python3","orm","postgresql","asgi","database","query-builder","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"Piccolo is a fast, user friendly ORM and query builder which supports asyncio. Read the docs. Features Some of it’s stand out features are: - Support for sync and async. - A builtin playground, which makes learning a breeze. - Tab completion support - works great with iPython and VSCode. - Batteries included - a User model, authentication, migrations, an admin GUI, and more. - Modern Python - fully type annotated. - Make your codebase modular and scalable with Piccolo apps (similar to Django apps). Syntax The syntax is clean and expressive. You can use it as a query builder: Or like a typical ORM: Installation Installing with PostgreSQL driver: Installing with SQLite driver: Installing with all optional dependencies (easiest): Building a web app? Let Piccolo scaffold you an ASGI web app, using Piccolo as the ORM: Starlette, FastAPI, BlackSheep, Litestar, Ravyn, Lilya, Quart, Falcon and Sanic are currently supported. Piccolo ecosystem Piccolo Admin Piccolo Admin is a powerful admin interface / content management system for Python, built on top of Piccolo. It was created at a design agency to serve the needs of customers who demand a high quality, beautiful admin interface for their websites. It's a modern alternative to tools like Wordpress and Django Admin. It's built using the latest technologies, with Vue.js on the front end, and a powerful REST backend. Some of it's standout features: Powerful data filtering Builtin security Multi-factor Authentication Media support, both ","default_branch":null,"files":null,"tree":[],"storefront":"/r/piccolo-orm","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/piccolo-orm/piccolo/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}