On: Fun facts about SQLite

[TekMol]

How does "have some clue as to what structure used to be at one point or the other" relate to the topic of columns vs json fields?

[Althorion → TekMol]

It is what they meant by ‘tracking’, which is what you’ve asked about.

[TekMol → Althorion]

I have the feeling you both are confusing your development workflow around database structure with the structure itself.

You seem to think that using columns somehow results in some type of automatic "tracking" (versioning?) of something.

[Althorion → TekMol]

Not quite. We are saying that adding `not_available_before: 2026`, or similar, ‘right away’ is usually not a good thing; therefore anything that helps with doing that is not something we desire.

It should be a multistep process. Yes, it will waste time now, but it will save it in a long run.

[TekMol → Althorion]

How will it save time in the long run?