Talk Python To Me cover image

#5: SQLAlchemy and data access in Python

Talk Python To Me

How to Use Python to Combine Security and SQL Queries

2min Snip

00:00
Play full episode
I really like the fluent API that you put together there where you basically you start the query and whatever you do to it what comes out of the query. I took this thing right from from Ian Bicking's SQL object which was that you overload python operators like the double equals operator or the greater than operator so that when you have these little objects that refer to columns and values in a database you can compare them with the python comparison operators and they kind of auto magically create another object like a comparison. If you want to get some quick results for a program you're writing you might want to start with the ORM first and then and then do a deeper dive later. There's just two ways

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode