Talk Python To Me cover image

#5: SQLAlchemy and data access in Python

Talk Python To Me

00:00

How to Use Python to Combine Security and SQL Queries

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

Play episode from 16:29
Transcript

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app