In this architecture, every microservice exists to answer a known question (e.g., display some product with all its metadata, etc.), which makes it essential to have fast access to known aggregated data. While the ability to query both structured and unstructured data is the biggest draw of JSONB in PostgreSQL, the availability of JSONB also coincided with the surge of interest in microservices architecture. Once JSONB was made available in PostgreSQL v9.4 in 2014, the popularity of the database grew significantly. Since the name JSON was already used for features in Postgres, we decided to use JSONB, for “JSON Binary,” as the name. So in 2013, we began working on what we called Native HStore with array and nesting support, and in 2014, we started work on adding a binary storage native data structure and an application HStore structure. However, no operations were enabled because at that time, the developers did not believe this was necessary. In 2012, limited features of JSON were enabled in Postgres, including storage and organization. In 2006, these features were officially committed in PostgreSQL as an extension. This provided schema flexibility, which quickly became popular among users. In 2003, we implemented HStore to store key-value pairs in a binary format. In 2000, while working on, a major Russian portal, I and others began implementing text arrays and full-text search within PostgreSQL. Such features enable businesses to accomplish more tasks using a single database solution, introducing more innovation more quickly while conserving development resources and putting less pressure on teams to manage security for multiple applications.Ī brief history of bringing JSON and JSONB into PostgreSQL Among its benefits are a flexible schema to help businesses ramp up new projects quickly and compression to reduce overhead and increase performance. JSONB is now the most popular supported data type driving adoption of Postgres. JSONB, a data type exclusive to PostgreSQL, is an evolution of JSON that stores the text-based data in binary form, making the applications that access the unstructured data both faster and more efficient. JSON is a file format and data interchange format that enables applications to store and analyze text-based documents.
In this confusing environment, the adoption of one particular open source database, PostgreSQL, is growing rapidly based on its ability to handle both structured and unstructured data.Ī relational, or SQL, database system with more than 30 years of active development history, PostgreSQL is known for reliability, a strong feature set, and great performance. And we know that companies today tend to rely on a variety of on-premises and cloud-based databases and services to make the best use of their data. We know that data drives innovation and powers better customer experiences.
0 kommentar(er)
