News for hackers. Stuff that matters.
Re:The fastest tool for querying large JSON files is written... by dorianmariefr on Friday April 15, 2022 @12:10PM (#31041864)
jq for quick lookup, jsonb for actual storage, indexing jsonb is a pain though
Re:The fastest tool for querying large JSON files is written... by cryptonector on Friday April 15, 2022 @01:35PM (#31043079)
JSONB is optimized for compression, but also pessimized for writing.

What we should do is teach jq to read and write various binary JSON formats including JSONB.