Changes between Initial Version and Version 1 of Ticket #29928, comment 7


Ignore:
Timestamp:
Nov 8, 2018, 3:03:40 AM (5 years ago)
Author:
Michel Samia

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #29928, comment 7

    initial v1  
    11I see more possible solutions here. We can go sequentailly over them:
    2   1. (short term) document that sqlite isn't checking foreign keys in in tests
     2  1. (short term) document that sqlite isn't checking foreign keys in tests
    33  2. (mid-term) allow changing the checking mode for sqlite in settings.py via and option in the database dict and document it. Mention it can cause slowness
    44  3. (holy grail) contribute to sqlite a simple refactor/feature which will allow calling something like check_constraints on an uncommitted transaction and get the integrity errors more effectively (checking only uncommitted objects, not whole db). I guess this is the way how it works now for postgreSQL and Oracle. I'm already thinking of filing a feature request in sqlite for this but first I would like to hear your opinion on it :)
Back to Top