meta_pixel
Tapesearch Logo
Log in
Talk Python To Me

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

Talk Python To Me

Michael Kennedy

Technology

4.8635 Ratings

🗓️ 8 August 2021

⏱️ 59 minutes

🧾️ Download transcript

Summary

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.

Transcript

Click on a timestamp to play from that location

0:00.0

ORMs are one of the main tools to put first-class data access in the hands of non-SQL-loving developers,

0:06.3

and even for those who do love SQL, making them way more productive.

0:10.5

When you hear about ORMs and Python, we often hear about either SQL Alchemy or Django ORM,

0:16.0

and we should, they're great.

0:17.4

But there are newer ORMs that take better advantage of modern Python. On this episode,

0:22.1

you'll meet Daniel Townsend. He's the creator of Piccolo ORM. A great ORM that is async-first,

0:27.8

but also has a synchronous API. It has a super clean query syntax, and it's easy to learn. This

0:34.2

is Talk Python to Me, episode 328, recorded July 22nd, 2021.

0:52.5

Welcome to Talk Python, a weekly podcast on Python, the language, the libraries, the ecosystem, and the personalities.

0:58.9

This is your host, Michael Kennedy. Follow me on Twitter where I'm at M. Kennedy, and keep up with

1:03.5

the show and listen to past episodes at Talk Python.fm, and follow the show on Twitter via at Talk Python.

1:09.9

This episode is brought to you by Linode, us over at Talk Python Training, and the transcripts

1:14.8

are brought to you by Assembly AI.

1:17.0

Please check out what we're all offering during our segments.

1:19.2

It really helps support the show.

1:21.7

Do you want to learn Python, but you can't bear to subscribe to yet another service?

1:25.9

At Talk Python Training, we hate subscriptions too.

1:29.2

That's why our course bundle gives you full access to the entire library of courses

1:32.7

for one fair price. That's right. With the course bundle, you save 70% off the full price of our

1:38.8

courses, and you own them all forever. That includes courses published at the time of the purchase as well as courses

1:45.6

released within about a year of the bundle. So stop subscribing and start learning at talk python.fm

1:51.9

slash everything. Dan, welcome to Talk Python to me. Yeah, thanks for having me. I'm a big fan of the

...

Please login to see the full transcript.

Disclaimer: The podcast and artwork embedded on this page are from Michael Kennedy, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Michael Kennedy and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.

Copyright © Tapesearch 2025.