3 ms·
Link? My reading last time I looked at this was that the sqlite and postgres “jsonb” were different.
by ks2048 3y ago
Link? My reading last time I looked at this was that the sqlite and postgres “jsonb” were different.
- cryptonector 3y agoThis is the first time that SQLite3 is getting JSONB. Idk if it's the same as PG's. TFA doesn't say. I assume they are the same or similar because I seriously doubt that D.R. Hipp is unaware of PG's JSONB, but then for that reason I am surprised that he didn't say in TFA.
- cryptonector 3y agohttps://sqlite.org/draft/jsonb.html https://sqlite.org/draft/jsonb.html says they're NOT the same.
- anarazel 3y agohttps://sqlite.org/draft/jsonb.html https://sqlite.org/draft/jsonb.html references postgres: > The "JSONB" name is inspired by PostgreSQL, but the on-disk format for SQLite's JSONB is not the same as PostgreSQL's. The two formats have the same name, but they have wildly different internal representations and are not in any way binary compatible.