2 ms·
AFAIK jsonb is not a specific format, it’s just a generic term for “a json equivalent binary representation”. The sqlite blurb says jsonb is generally smaller t
by masklinn 3y ago
AFAIK jsonb is not a specific format, it’s just a generic term for “a json equivalent binary representation”. The sqlite blurb says jsonb is generally smaller than json, but IIRC from when postgres added jsonb postgres’ is generally slightly larger.
- cryptonector 3y agoPG's JSONB has a specification (well, inside PG, not a standard), and they won't change it except in backwards compatible ways (or, really, at all).
- masklinn 3y ago> PG's JSONB has a specification (well, inside PG, not a standard) So does sqlite's. An implementation detail, even a necessarily stable one, does not a format make.