50 ms·
> This is no longer true in database that have JSON support Doing that means losing foreign-key referential integrity...
by DaiPlusPlus 3y ago
> This is no longer true in database that have JSON support
Doing that means losing foreign-key referential integrity...
- mattmanser 3y agoHe specifically addressed that in the comment. In the sentence right after the bit you quoted.
- jmull 3y agoThe comment alludes to this, but to clarify: You can have your data stored in tables with all the constraints you might want, but then use json in queries to return the results in whatever form you want.
- DaiPlusPlus 3y agoMy mistake - to be fair, it is 5am here
- conradev 3y agoGenerated columns (i.e. some_json->>'id') can have constraints just fine, maintaining whatever integrity you want