NOSQL Archives - 2ndQuadrant

Posts

Inserting JSONB data in PostgreSQL 9.6

January 26, 2017/0 Comments/in Rubens' PlanetPostgreSQL /by Rubens Souza

The jsonb_insert function brought in with PostgreSQL 9.6 gives more control when inserting new values into a jsonb array and/or new keys into a jsonb object. This article introduces this new function together with some examples.

JSONB and PostgreSQL 9.5: with even more powerful tools!

May 30, 2016/2 Comments/in Featured, Rubens' PlanetPostgreSQL /by Rubens Souza

PostgreSQL 9.5 has introduced new JSONB functionalities, greatly improving its already present NoSQL characteristics. With the inclusion of new operators and functions, now it is possible to easily modify the JSONB data. In this article these new modifiers will be presented together with some examples of how to use them.

Why should you learn PostgreSQL?

June 9, 2015/1 Comment/in PostgreSQL /by 2ndQuadrant Press

A few weeks ago I asked one of my colleagues why I should learn PostgreSQL. Harald’s answer was: “To start any new journey of learning, asking ‘why’ is an excellent question. It gives us both a direction to send us on our way and an expected destination. Without a clear path to follow, our brains […]

JSONB type performance in PostgreSQL 9.4

March 3, 2015/15 Comments/in Marco's PlanetPostgreSQL /by Marco Nenciarini

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data, allowing PostgreSQL to be competitive in managing the “lingua franca” of the moment for the exchange of data via web services. It is useful to perform a number of tests to verify its actual performance.

NoSQL with PostgreSQL 9.4 and JSONB

February 23, 2015/1 Comment/in Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer a data structure in a “key-value” array, dictionary style (widely used in the field of development) and, at the same time, ensures all the advantages […]

2ndQuadrant is now part of EDB

Posts

Inserting JSONB data in PostgreSQL 9.6

JSONB and PostgreSQL 9.5: with even more powerful tools!

Why should you learn PostgreSQL?

JSONB type performance in PostgreSQL 9.4

NoSQL with PostgreSQL 9.4 and JSONB

Support & Services

Products

Postgres Learning Center

About Us