Learn Python with Talk Python's Python courses

Piccolo: A fast, async ORM for Python (updated)

Episode #328, published Sun, Aug 8, 2021, recorded Thu, Jul 22, 2021.

This episode is carbon neutral.
ORMs are one of the main tools to put first-class data access in the hands on non-SQL-loving developers and even for those who do love SQL, making them way more productive. When you hear about ORMs in Python, we often hear about either SQLAlchemy and Django ORM. And we should, they are great. But there are newer ORMs that take better advantage of modern Python.

On this episode, you'll meet Daniel Townsend. He's the creator of Piccilo ORM. A great ORM that is async first, but also has synchronous APIs. It has a super clean query syntax. And, it's easy to learn.

Links from the show

Dan on Twitter: danieltownsend
Piccolo ORM: piccolo-orm.com
Piccolo on GitHub: github.com
Little Bobby Tables joke: bobby-tables.coml
Syntax example: github.com
Piccolo Admin: piccolo-orm.readthedocs.io
Python's Pathlib: docs.python.org
Watch YouTube live stream edition: youtube.com
Episode transcripts: talkpython.fm

Stay in touch with us
Subscribe on YouTube (for live streams): youtube.com
Follow Talk Python on Twitter: @talkpython
Follow Michael on Twitter: @mkennedy

Want to go deeper? Check out our courses

Daniel Townsend
Daniel Townsend
Dan is a full stack developer and tech lead, with a love for Python, and creating nice UI. He is based in the UK, and started his career after picking up a secondhand book on HTML, which sparked a lifelong interest in building digital products. He's often found tinkering with web sockets, Postgres, and asyncio.
Episode sponsored by
Ads served ethically
Become a friend of the show
Stay in the know and get a chance to win our contests.
See our privacy statement about email communications.