Talk Python To Me cover image

#5: SQLAlchemy and data access in Python

Talk Python To Me

Python Core: A Comprehensive System for Building a Whole Schema From Scratch

3min Snip

00:00
Play full episode
core was designed to be this comprehensive system of building a whole schema from scratch so meaning if you have a blank database you can build up all of your objects in python and then say you know metadata. Create all and that will emit what we call data definition language ddl which is like table statements, create sequence and create index they will emit all those things for you. In order to make that feasible we have to also have support for attributes like if a column is nullable or not. If a column is a primary key if acolumn is index if there's a unique constraint on a set of columns so seek a lock in theschema system has objects and flags that represent all of these

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