Thread by @driscollis

Today is a great day to talk about one of #Python's most popular SQL ORMs - SQLAlchemy!

SQLAlchemy is an Object Relational Mapper for Python. That means that it can translate Python code to SQL.

🧵👇🐍

Let's take a look at creating a database with #Python and #SQLAlchemy

You need to create classes that model tables in your database.

Then to create the actual database, you use `Base.metadata.create_all()`

Now let's add some data to our database using #Python and #SQLAlchemy

The following code shows how to add data to both our tables. It also shows how to add multiple rows of data all at once! 🐍🔥

Now that you have data in the database, let's find out how to write a simple query and change one of the fields!

Here are a couple of examples that demonstrate how to change two different fields in your database:

To wrap things up, let's look at how you might delete a record from a database using #Python and #SQLAlchemy

Thanks for reading my thread on Python and SQLAlchemy. Working with databases can be fun in Python!