3 ms·
With JSON blobs in simple tables a very large part of designing a database schema becomes designing a JSON schema, with different opportunities to make mistakes
by HelloNurse 4y ago
With JSON blobs in simple tables a very large part of designing a database schema becomes designing a JSON schema, with different opportunities to make mistakes but (potentially) the same strictness.
- mulmboy 4y agoHow do you enforce the JSON schema?
- HelloNurse 4y agoWe are talking about the internal database of some application: its schema is something that should be designed well, not enforced defensively like a schema for validating undependable inputs.
- tenken 4y agoIn the application layer
- breeze1990 4y agodefine schema with data class and you have tools like protobuf/thrift. And I find it really unnecessary to map every attribute to a SQL column.