The JSON standard is a given for all developers, so much so that virtually all databases can handle it. Since processing textual JSON is costly, all major database providers (open source and commercial) have added a JSON storage format known as "binary". This binary encoding brings many benefits, such as query performance, partial updating, client-side support, etc., but also inconveniences that you'd better be aware of.
In this session, we'll compare the different binary JSON formats of PostgreSQL (JSONB), MongoDB (BSON), MySQL (BJSON) and Oracle (OSON) in a fun and interactive way. From this, we'll be able to deduce a few best practices for application development.
#BSON #JSONB #OSON #JSON #MongoDB #PostgreSQL #Oracle #MySQL
