News for hackers. Stuff that matters.

A comment on SQLite 2022 Recap. Parent comment

Re:SQLite 2022 Recap by HelloNurse on Sunday January 01, 2023 @05:08PM (#34211555)
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.
[ Parent | on HN ]
Re:SQLite 2022 Recap by mulmboy on Sunday January 01, 2023 @05:24PM (#34211683)
How do you enforce the JSON schema?
[ Parent | on HN ]
Re:SQLite 2022 Recap by tenken on Sunday January 01, 2023 @06:40PM (#34212412)
In the application layer
[ Parent | on HN ]
Re:SQLite 2022 Recap by breeze1990 on Sunday January 01, 2023 @06:50PM (#34212493)
define 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.
[ Parent | on HN ]
Re:SQLite 2022 Recap by HelloNurse on Monday January 02, 2023 @09:07AM (#34217935)
We 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.
[ Parent | on HN ]