On Tue, Jan 14, 2020 at 9:35 AM Wout Mertens <wout.mert...@gmail.com> wrote:
> On Mon, Jan 13, 2020 at 10:45 PM James K. Lowden <jklow...@schemamania.org>
> This is a trade-off between schema simplicity, storage layout and speed of 
> some operations. I'd
> argue that in this particular case, a JSON field is beneficial for 
> simplicity, speed and storage space.

+1. Echoes my own thoughts on this thread.

James is right too of course, in the absolute, but limited
denormalization for efficiency,
and arguably for simplicity too, despite James' opinion, are valuable.
Now it's "just" the
matter of making the right tradeoff based on the particular
circumstances, fully aware
of the pros and cons. And that requires experience and knowledge (and
testing/benchmarking, duh).

Hopefully this particular thread will help people on this recurring topic. --DD
sqlite-users mailing list

Reply via email to