Re:New JSON query operators in SQLite 3.38.0
by masklinn on Sunday February 27, 2022 @06:52AM
(#30487436)
> In case of PostgreSQL there is json and jsonb. For SQLite, hexdump of the database shows text representation and seems to be stored like json than jsonb. I am not aware of the full design and source code but it seems some functions parse and cache the JSON representation.
Wouldn’t a jsonb-type storage require a new storage mode for sqlite, which would be a major architectural change?
JSONB derives (at least logically and historically) from hstore, so postgres had a history of structured type stores. Not so for sqlite.
Re:New JSON query operators in SQLite 3.38.0
by saurik on Sunday February 27, 2022 @07:35AM
(#30487806)
jsonb and hstore are both just an encoding format for the data within a single field and do not affect either the architecture nor the storage model of the database.
Wouldn’t a jsonb-type storage require a new storage mode for sqlite, which would be a major architectural change?
JSONB derives (at least logically and historically) from hstore, so postgres had a history of structured type stores. Not so for sqlite.