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 what syntax SQLAlchemy ORM uses to filter our rows. This post is part of my journey to learn Python. You can find the other parts of this series here. You …
With the foundation for SQLAlchemy ORM in place, it is now time to do some CRUD operations without writing SQL statements. This post is part of my journey to learn Python. You can find the other parts of this series here. You find the code for this post in my PythonFriday repository on GitHub …
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. This post is part of my journey to learn Python. You can find the other …
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. This post is part of my journey to learn Python. You can find the other parts of this series here. You find the code for this post in my PythonFriday repository …
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. This post is part of my journey to learn Python. You can find the other parts of this …
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. This post is part of my journey to learn Python. You can find the other parts of this series here. You find …
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. This post is part of my journey to learn Python. You can find the other parts of this series here. You find the code …
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. This post is part of my journey to learn Python. You can find the other parts of this series …
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 …
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. This post is part of my journey to learn Python. You can find the other parts of this series here. You find …