Django migrations, friend or foe? Optimize your Django migrations for faster testing

Veteran Django developers know that migrations can be both friend and foe. Learn how to optimize your Django migrations for faster testing and resolve common issues like circular dependencies and slow test runs.

Key takeaways
  • Squash migrations can be used to combine multiple migrations into a single one, reducing the number of migrations and improving performance.
  • To squash migrations, create a new migration with the --empty option, then move the dependencies from the original migrations to the new one.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • Django’s show migrations command can be used to view all migrations for a specific app.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to true can be slow, especially for large numbers of migrations.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database after running tests.
  • The --name option can be used to customize the name of the migration file.
  • Squash migrations can be used to resolve circular dependencies and reduce the number of migrations.
  • Running tests with migrate set to false can speed up test runs by avoiding the creation of the test database.
  • The manage.py migrate command can be used to apply migrations to the database.
  • The SQL command can be used to run SQL statements to create or alter tables.
  • Django’s inspectdb command can be used to inspect the database schema and generate migrations.
  • The --keep-db option can be used to preserve the test database

More talks

Martin Trautmann - pydiverse pipedag: A library for data pipeline orchestration

37C3 - Software Licensing For A Circular Economy

Functional Programming in…SQL? • Sam Roberton • YOW! 2019

DuckDB: Crunching Data Anywhere, From Laptops to Servers • Gabor Szarnyas • GOTO 2024

Next Stop: Insights! How Streamlit and Snowflake Power Up Data Stories

Select ML from Databases [PyCon DE & PyData Berlin 2024]

Matt Harrison - An Introduction to Pandas 2, Polars, and DuckDB | PyData Global 2023

Talks - Alex Monahan, Gabor Szarnyas: Python and SQL: Better Together, Powered by DuckDB