3 ms·
What's the difference between jsonb and bson? They look so similar to each other...
by luikore 13y ago
What's the difference between jsonb and bson? They look so similar to each other...
- pilif 13y agojsonb is the name of a data type used in postgres in order to store, index and update JSON. bson is the same used by MongoDB and also made a semi-official standard.
- MartinMond 13y agoBSON actually was considered as the JSON storage format for PostgreSQL, but was discarded once people figured out that BSON stores ["a", "b", "c"] as {0: "a", 1: "b", 2: "c"} which is just silly.
- cies 13y agowow.. thanks for that info, i came here to see the diference and and a little shocked by the silliness of BSON (and the team that created it, apparently Mongo); compared quality devotion of the postgres community.. well done postgres!