ftisiot ideas about food and life
who talks suggestions soft json-pg

Francesco Tisiot Ideas!

From Food till Tech and Everything in the Middle

Jan 26, 2023

SOFT Methodology

This page contains all the links related to the SOFT (Scalable Observable Fast Trustworthy) methodology for defining robust data platforms.

Continue Reading

Jan 24, 2023

What are the directions of technical data platforms scalability?

Technical scalability is one of the main drivers of a data platform, as mentioned in the SOFT methodology. But what are the options? In this blog we’ll evaluate the direction of scalability and the tradeoffs you might encounter in the decision process.

Continue Reading

Jan 12, 2023

How to tabulate a JSON to a record in PostgreSQL®

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to tabulate a JSON to a record:

Continue Reading

Jan 12, 2023

How to tabulate a JSON to a recordset in PostgreSQL®

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to tabulate a JSON to a recordset:

Continue Reading

Jan 10, 2023

How to edit a JSON object in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the jsonb_set function to remove the null values for JSONB columns.

Continue Reading

Jan 10, 2023

How to remove an item from a JSON array in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the - operator to remove an item from an array.

Continue Reading

Jan 10, 2023

How to remove fields from a JSON document in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to remove fields from a JSON document:

Continue Reading

Jan 10, 2023

How to remove nulls JSON object in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the json_strip_nulls (jsonb_strip_nulls for JSONB) function to remove the null values.

Continue Reading

Jan 10, 2023

How to concatenate two JSON documents in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the opearator || to concatenate two JSON objects.

Continue Reading

Jan 9, 2023

How to create a JSON object from array of key/value pairs in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from an array of key/value pairs.

Continue Reading


Francesco Tisiot

Mastodon Francesco comes from Verona, Italy and works as a Senior Developer Advocate at Aiven. With his many years of experience as a data analyst, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!

  • ««
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • »
  • »»

Story logo

© 2023