News for hackers. Stuff that matters.
Re:When to Avoid JSONB in a PostgreSQL Schema by taspeotis on Friday September 02, 2016 @01:48AM (#12411116)
> 2. You could have a table with every field that's ever been used as a nullable field and add new columns every time a new version of the form appears

Depending on your RDBMS this is not actually so bad. SQL Server has sparse column support which helps to make this sort of schema practical. It comes with some strings attached, however [1].

[1] https://msdn.microsoft.com/en-AU/library/cc280604.aspx

There are no comments on this comment yet.