6 ms·
I thought the point was that the DB could reach into JSONB for you (potentially indexed as well) instead of having to deserialize outside. So the exact serializ
by gleenn 3y ago
I thought the point was that the DB could reach into JSONB for you (potentially indexed as well) instead of having to deserialize outside. So the exact serialization isn't maybe as interesting as the direct queryability.
- fbdab103 3y agoDoes SQLite make any promises on the internal implementation? I assumed that the only guarantee was at the SQL interface.
- banana_giraffe 3y agoThey do promise it'll be a stable format: > The JSONB format is not intended as an interchange format. Nevertheless, JSONB is stored in database files which are intended to be readable and writable for many decades into the future. To that end, the JSONB format is well-defined and stable. The separate SQLite JSONB format document provides details of the JSONB format for the curious reader. And indeed the functions jsonb() and json() will let you convert to and from jsonb.