News for hackers. Stuff that matters.
Re:The fastest tool for querying large JSON files is written... by breatheoften on Friday April 15, 2022 @07:01PM (#31046993)
I really wish it preserved key order ... is quite annoying losing this at the storage layer ...
Re:The fastest tool for querying large JSON files is written... by cryptonector on Saturday April 16, 2022 @05:57PM (#31056453)
So preserving key order is... nice for some things, but what's nice about JSONB is that it's optimized for reading and querying.
Re:The fastest tool for querying large JSON files is written... by johnthescott on Saturday April 16, 2022 @02:49AM (#31050177)
i am curious to known an example where key order would matter.
Re:The fastest tool for querying large JSON files is written... by realaleris149 on Saturday April 16, 2022 @12:55PM (#31053915)
Had this exact issue. The UBL [1] standard has a primarty XML representation where the order of elements are enforced in the schema. It also has a JSON representation, so when going from JSON to XML the exact order is needed to obtain a valid XML.

[1] https://www.oasis-open.org/committees/tc_home.php?wg_abbrev=...