Understanding Django ORM Foreign Key Deletion Constraints One essential feature of Django’s ORM is the ability to define relationships between models using Foreign Keys. While Foreign Keys facilitate data integrity and consistency, it’s crucial to understand and manage the deletion of related objects to avoid unintended consequences. In this article, we’ll explore Django ORM Foreign Key deletion constraints and how they impact your database. Django Development
Database Sharding Explained More features, active users, and data are collected daily. Your database is slowing your application. Many people don't understand database sharding, which could solve their difficulties. This article explains database sharding, its benefits, including how to use it and when not to. Architecture Databases
Advanced SQLAlchemy Features You Need To Start Using If you are Python developer and you work with SQL databases, then SQLAlchemy is most likely a library you are familiar with. It’s a powerful, yet flexible toolkit for working with SQL in Python with lots of features. Some of these features like ORM and basic queries are common knowledge, but there are quite a few features you might not know about and should definitely be taking advantage of. So, let’s se how to leverage things like hybrid properties, nested queries, table metadata, dialects and more! Python Development Databases
Raw SQL vs Query Builder vs ORM After reading this article, you will know when to use raw SQL, a query builder and an ORM. You will also know how to use each of them in Python. All of the code in this article is runnable. You just need to initialize the database and add environment variables. Python Development Databases