SQLAlchemy

Keep your Python models and database objects in sync

SQLAlchemy is a toolkit written in Python that lets you interact with SQL databases. It is essentially the glue that will bring your Python application and data together. SQLAlchemy is also an object relational mapper (or ORM), which means it translates your data in a database into objects in Python so it is easy to work with.

Start learning with

Google

Overview

SQLAlchemy is a multipurpose tool to interact with SQL databases using Python. Its most common use is to map data structures in your code with data in your database.

Who curated this track

Jon Chan
  • Founder of Bento
  • Developer at Stack Overflow
  • Self-taught developer
Background Concepts
 
What is a Python ORM?

(stackoverflow.com)

Understanding what an Object Relational Mapping (or ORM) is will be key before learning SQLAlchemy and using it in Python. Get a quick overview of how it's used before diving in.

15M

Foundations
 
SQLAlchemy ORM for Beginners

(www.youtube.com)

This is an excellent video introduction to SQLAlchemy for people who have no exposure to the ORM. It covers basic operations and setup with accompanying slides.

1H

 
Object Relational Tutorial

(docs.sqlalchemy.org)

This is the official documentation for SQLAlchemy. It's the most comprehensive tutorial on their platform as you'll get and it's worth spending time studying it. Go through the whole thing.

7H

Practical SQLAlchemy
Do you know Flask or other Python web framework?

It's very common for Flask or other web frameworks to be mentioned when you're learning about SQLAlchemy. If you're unfamiliar with a Python web framework, at least understand the basics before going further.

 
Flask SQLAlchemy

(www.youtube.com)

Learning SQLAlchemy in isolation is very rare and is much better understood in the context of a web framework, like Flask. The two technologies go very well together, and it's easiest to learn them side-by-side.

3H

Start this track