4 ms·
As weird and inefficient as it may seem at first glance, JSON in a database can have a variety of uses, so I certainly see the benefit. But… is there any use f
by yunruse 6y ago
As weird and inefficient as it may seem at first glance, JSON in a database can have a variety of uses, so I certainly see the benefit.
But… is there any use for a null byte explicitly in a JSON string? The de facto standard (easy to use and instantly recognisable) for blobs seems to be base64. I can’t think of any meaningful data benefits other than data efficiency (which is easily mitigated by storing the blob directly in the database).
- corty 6y agoJSON strings must conform to UTF8. Storing plain non-base64 blobs in them is abuse of broken JSON parsers.