Bummer! You have been redirected as the page you requested could not be found.

Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

SQLAlchemy Basics

Well done!

You have completed SQLAlchemy Basics!

Sign up for Treehouse Back to Library

What is SQLAlchemy?

6:37 with Megan Amendola

An introduction to SQLAlchemy, the Python ORM.

Pre-Requisites

Docs

It's always a good idea to bookmark the documentation for reference. SQLAlchemy Documentation

Local Setup Steps

  • Create a folder for your project
  • Open your folder in your IDE
  • Open the terminal in your IDE
  • Install virtual environment
    • Mac: python3 -m pip install --user virtualenv
    • Windows: py -m pip install --user virtualenv
  • Create a virtual environment
    • Mac: python3 -m venv env
    • Windows: python -m venv env
  • Activate your environment
    • Mac: source ./env/bin/activate
    • Windows: .\env\Scripts\activate
  • Install SQLAlchemy pip install sqlalchemy
  • Create requirements file pip freeze > requirements.txt

GitHub Resources

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    [MUSIC] 0:00
    Hi there, my name is Megan and I'm a teacher here at Treehouse. 0:00
    My pronouns are she, her, hers. 0:04
    In this course, I'm excited to show you SQLAlchemy. 0:07
    SQLAlchemy is an O-R-M, or object-relational mapper. 0:12
    It's a Python code library that transfers data stored in a SQL 0:18
    database into Python objects. 0:22
    You can then use Python code to create, read, update, and 0:26

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up