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

query

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 6, 2023

How to index and query a JSON object in PostgreSQL®?

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

Continue Reading

Nov 7, 2022

How to query remote InfluxDB via cURL

Sometimes you want to query a remote InfluxDB server to understand the data in it. This can be done via cURL as explained in the InfluxDB docs

Continue Reading


Francesco Tisiot

Mastodon Francesco comes from Verona, Italy and works as a Staff 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!

Story logo

© 2023