How to Create an Index in Django Without Downtime

 By realpython - 2020-12-06

Description

In this step-by-step Python tutorial, you'll get a solid understanding of the limitations of Django migrations by tackling a well known problem: creating an index in Django with no downtime.

Summary

  • Managing database migrations is a great challenge in any software project.
  • If the commands do not match, then you might end up with inconsistencies between the database and the models state.
  • database_operations are operations to apply to the database.
  • Once you understand it, and how to utilize it, you can overcome many limitations of the built-in migration operations.

 

Topics

  1. Database (0.12)
  2. Backend (0.09)
  3. Frontend (0.07)

Similar Articles

Python and MySQL Database: A Practical Introduction

By realpython - 2021-01-22

In this tutorial, you'll learn how to connect your Python application with a MySQL database. You'll design a movie rating system and perform some common queries on it. You'll also see best practices a ...

Introduction to Python SQL Libraries

By realpython - 2020-12-28

In this step-by-step tutorial, you'll learn how to connect to different database management systems by using various Python SQL libraries. You'll interact with SQLite, MySQL, and PostgreSQL databases ...

Dump and load a database in Neo4j Desktop

By Graph people - 2020-11-11

Have you ever wanted to share a database you created in Neo4j Desktop with your colleague but not sure exactly how to go about it? Maybe you want to clone the database locally to perform various write ...

How to use IndexedDB to build Progressive Web Apps

By Medium - 2020-09-01

In this previous post, I talked about implementation of IndexedDB inside Service Workers. If you don’t understand that part, please read that article to clear up some concepts about service workers…