A simple project to explore the number of GCs when doing basic ORM work

YES, OMG YES. Check this out Python Default GC Settings: SQLAlchemy – 20,000 records in one query 1,859 GCs 908ms 78.7 MB mem MongoDB – 20,000 records in one query 463 GCs 593ms 75.8 MB mem Talk Python-optimized GC Settings: SQLAlchemy – 20,000 records in one query: 29 GCs (64x improvement) 695ms (23% improvement) 76.8 MB mem (surprisingly: 2% improvement with less GC) MongoDB – 20,000 records in one query 10 GCs (46x improvement) 515ms (13%) 72.3 MB mem (surprisingly: […]

Read more

A fast, user friendly ORM and query builder which supports asyncio

Piccolo 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. Syntax The syntax is clean and expressive. You can use it as a query builder: […]

Read more