For my other projects I'm generally using SQLite where starting a new in-memory database is so fast it's effectively free.
There's a separate mechanism for writing tests where you need to explicitly test transaction mechanics: https://docs.djangoproject.com/en/5.0/topics/testing/tools/#...
For my other projects I'm generally using SQLite where starting a new in-memory database is so fast it's effectively free.