JSONB in PostgreSQL today and tomorrow
We know that data drives innovation and powers better customer experiences. 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. 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.A 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. JSON is a file format and data interchange format that enables applications to store and analyze text-based documents. As such, JSON powers NoSQL databases. 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.To read this article in full, please click here
We know that data drives innovation and powers better customer experiences. 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. 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.
A 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. JSON is a file format and data interchange format that enables applications to store and analyze text-based documents. As such, JSON powers NoSQL databases. 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.
