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. (more…)
The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQ” 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 of a relational database.(more…)
Written by Giuseppe Broccolo First published in Italian Since PostgreSQL 9.3, it is possible to update and insert into views directly, so long as the view refers to only one underlying table.PostgreSQL 9.4 allows us to use the CHECK clause for INSERTs into updatable views. For example, consider a table composed of just one integer column; and consider two views, one on numbers divisible by 2 and one on numbers divisible by 3. If we try to insert the number 123 into the first view:----$ CREATE TABLE some_data(id int4 PRIMARY KEY);CREATE TABLE$ CREATE VIEW first AS SELECT * FROM some_data WHERE 0 = id%2;CREATE VIEW$ CREATE VIEW second AS SELECT * FROM some_data WHERE 0 = id%3;CREATE VIEW$ INSERT INTO first(id) VALUES (123);----
Up until now, reading this blog has kept you up-to-date with the latest developments in PostgreSQL. This time I would like to invite you to meet the team of 2ndQuadrant at the PostgreSQL Conference Europe 2014 which took place in Madrid on October 21st-24th.As you know, 2ndQuadrant offers 7 days a week, 24 hours a day support to companies all over the globe. As you can well imagine, to be able to provide this non-stop support we have hired world-class experts who have years of experience and are PostgreSQL contributors, developers or committers. To answer your queries without delay, we needed our team to be scattered around the world. Team members who attended the conference came from Japan, Australia, Chile, Ecuador, Argentina, USA, UK, Germany, France, Italy Estonia and the Czech Rep...