Comment on SQLite as a Document Database (2020)Comments−Insimwytim13dIf you applying NOT NULL constraint, why not extract it from json altogether as a separate column? What's the use of it in json?You may construct it back on retrieval, if you need it in results.
Comments
If you applying NOT NULL constraint, why not extract it from json altogether as a separate column? What's the use of it in json?
You may construct it back on retrieval, if you need it in results.