#81: CRUD in SQLAlchemy ORM
With the foundation for SQLAlchemy ORM in place, it is now time to do some CRUD operations without writing SQL statements.
persistence
#80: Creating the Foundation for SQLAlchemy ORM
The Object Relational Mapper (ORM) part of SQLAlchemy offers us a way to persist data in a database without the need to write our own SQL statements. Let us look how that works and what rules we need to follow.
#79: JOINs in SQLAlchemy Core
Relationships between tables are of little use if we cannot join them in our queries. Let's look at how SQLAlchemy Core creates JOIN statements.
#78: Relationship Patterns in SQLAlchemy Core
Relational databases are great to protect your data integrity. However, that only works when you tell the database which objects have a relationship. Let us look what SQLAlchemy Core offers us to create foreign keys through metadata.
#77: Filters in SQLAlchemy Core
When we access our database, we most often only want to work with a few specific rows and not the whole table. Let us look how we can use filters in SQLAlchemy Core.
#76: CRUD With Metadata in SQLAlchemy Core
One of the benefits of SQLAlchemy is that it comes with an abstraction for SQL. Let’s find out how a bit of metadata can help us write much less database code.
#75: CRUD With Raw SQL in SQLAlchemy Core
If you know your SQL and want to use it with Python, SQLAlchemy is a good tool to help you. You can start with plain SQL commands and later move to a higher level of abstraction.
#74: Important Concepts in SQLAlchemy
The big challenge for me in learning SQLAlchemy was that it comes with a lot of terms and concepts that you need to know before you can start to understand this toolkit. Some are familiar and work the same way as in other programming languages, while others are an additional level of abstraction that were new for me. To clear things up, I wrote this post to explain the meaning of the most important concepts in SQLAlchemy.
#73: First Steps with SQLAlchemy
A big gap in my knowledge of Python is how to access a database. Let us look what Python offers to persist data in a relational database like PostgreSQL, SQLite or SQL Server.