I want my code to make sure that the DB is consistent - i.e. that there are no wrong data types (i.e. number in a text field, etc.) and more importantly - that references indeed reference actual items.
Since data is added from an external JSON, I do not want to implement restrictions on inserting inconsistent data - it could lead to insertion being rejected due to a reference not existing, even though the reference will be inserted later in the file. It seems that it will be better to make sure that the data is consistent only after the insertion has completed for the entire file.