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

Francesco Tisiot Ideas!

From Food till Tech and Everything in the Middle

Mar 22, 2023

: Learn PostgreSQL JSON with Pizza

A talk about JSON handling in PostgreSQL: from data loading to query to indexing.

Talk Details

Mar 7, 2023

Pg Day Paris 2023: Fix Your Strings!

Strings are one of the most used types in databases; they can store pretty much any data and don’t enforce any rules on the inserted input. This talk showcases the risk of using strings and how to mitigate them to ensure data quality.

Talk Details

Mar 1, 2023

How to load JSON data in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB. This doc showcases how to load JSON data into a column.

Continue Reading

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


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