DEV Community

Francesco Tisiot profile picture

Francesco Tisiot

Francesco is a Staff Developer Advocate at Aiven. Long time data practitioner and analytics enthusiast!

Location Verona, Italy Joined Joined on  Personal website https://ftisiot.net/ github website twitter website

Work

Staff Developer Advocate at Aiven.io

Helping PostgreSQL® professionals with AI-assisted performance recommendations

Helping PostgreSQL® professionals with AI-assisted performance recommendations

4
Comments
3 min read

Want to connect with Francesco Tisiot?

Create an account to connect with Francesco Tisiot. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Introducing Aiven's AI Database Optimizer: The First Built-In SQL Optimizer for Enhanced Performance

Introducing Aiven's AI Database Optimizer: The First Built-In SQL Optimizer for Enhanced Performance

2
Comments
3 min read
How to use pgbench to test PostgreSQL® performance

How to use pgbench to test PostgreSQL® performance

2
Comments
5 min read
From dbf to PostgreSQL with Python

From dbf to PostgreSQL with Python

Comments
2 min read
List of PostgreSQL® AI Projects and Resources

List of PostgreSQL® AI Projects and Resources

4
Comments
1 min read
11 Lessons to learn when using NULLs in PostgreSQL®

11 Lessons to learn when using NULLs in PostgreSQL®

7
Comments
11 min read
How to CONCAT in MySQL

How to CONCAT in MySQL

Comments
6 min read
How to load JSON data in PostgreSQL with the COPY command

How to load JSON data in PostgreSQL with the COPY command

21
Comments
4 min read
Load StackOverflow's StackExchange data in PostgreSQL®

Load StackOverflow's StackExchange data in PostgreSQL®

Comments 2
7 min read
Managing data drift with Apache Kafka® Connect and a schema registry

Managing data drift with Apache Kafka® Connect and a schema registry

1
Comments
17 min read
1 billion rows challenge in MySQL

1 billion rows challenge in MySQL

Comments
4 min read
How to use PostgreSQL® SUBSTRING

How to use PostgreSQL® SUBSTRING

1
Comments
4 min read
1 billion rows challenge in PostgreSQL and ClickHouse

1 billion rows challenge in PostgreSQL and ClickHouse

40
Comments 5
6 min read
How AI made my Amazon RDS for MySQL queries 23x faster

How AI made my Amazon RDS for MySQL queries 23x faster

1
Comments
10 min read
Change Data Capture from Amazon RDS to Apache Kafka® with Debezium

Change Data Capture from Amazon RDS to Apache Kafka® with Debezium

1
Comments 1
5 min read
How to tabulate a JSON document in MySQL

How to tabulate a JSON document in MySQL

1
Comments
2 min read
Kafka Connect sink to OpenSearch/ElasticSearch: how to sink unix timestamps

Kafka Connect sink to OpenSearch/ElasticSearch: how to sink unix timestamps

1
Comments
1 min read
Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector

Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector

2
Comments
1 min read
Consume Apache Kafka® messages via REST APIs

Consume Apache Kafka® messages via REST APIs

1
Comments
3 min read
JSON vs JSONB in PostgreSQL

JSON vs JSONB in PostgreSQL

45
Comments 3
3 min read
How to JSON in MySQL

How to JSON in MySQL

Comments
1 min read
Image recognition with Python, OpenCV, OpenAI CLIP and pgvector

Image recognition with Python, OpenCV, OpenAI CLIP and pgvector

Comments 1
10 min read
Pros and Cons of Multi Step Data Platforms

Pros and Cons of Multi Step Data Platforms

Comments
6 min read
So… what does a Staff Developer Advocate do?

So… what does a Staff Developer Advocate do?

Comments
5 min read
Use PostgreSQL® DOMAIN rules to validate columns of data

Use PostgreSQL® DOMAIN rules to validate columns of data

Comments
7 min read
PostgreSQL® JSONB Cheatsheet: Complete and Fast Lookup Guide

PostgreSQL® JSONB Cheatsheet: Complete and Fast Lookup Guide

1
Comments
4 min read
PostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup Guide

PostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup Guide

49
Comments 4
4 min read
Does Apache Kafka® really preserve message ordering?

Does Apache Kafka® really preserve message ordering?

Comments
7 min read
Build your first data pipeline with Aiven for Apache Flink®

Build your first data pipeline with Aiven for Apache Flink®

Comments
1 min read
Out of the box PostgreSQL monitoring with InfluxDB and Grafana dashboards

Out of the box PostgreSQL monitoring with InfluxDB and Grafana dashboards

1
Comments
4 min read
Aiven's journey to enable a better Apache Flink® experience

Aiven's journey to enable a better Apache Flink® experience

Comments
6 min read
What are the directions of technical data platforms scalability?

What are the directions of technical data platforms scalability?

1
Comments
5 min read
How to JSON in PostgreSQL®

How to JSON in PostgreSQL®

1
Comments 2
2 min read
From data stack to data stuck: the risks of not asking the right data questions

From data stack to data stuck: the risks of not asking the right data questions

Comments
5 min read
A SOFT methodology to define robust data platforms

A SOFT methodology to define robust data platforms

Comments
9 min read
Tips for Successful Conference Abstracts

Tips for Successful Conference Abstracts

2
Comments
7 min read
8 tips to speed up Apache Kafka® Connect development

8 tips to speed up Apache Kafka® Connect development

Comments
9 min read
A Talk For One

A Talk For One

Comments
6 min read
Using PostgreSQL® JSON functions to navigate reviews of restaurants in India

Using PostgreSQL® JSON functions to navigate reviews of restaurants in India

8
Comments
8 min read
How to query remote InfluxDB via cURL

How to query remote InfluxDB via cURL

1
Comments
1 min read
Picking a baby name with PostgreSQL® and FuzzyStrMatch

Picking a baby name with PostgreSQL® and FuzzyStrMatch

2
Comments
6 min read
Remove naughty words from your data using DataCater

Remove naughty words from your data using DataCater

1
Comments
9 min read
Convert Epoch to Timestamps in Apache Flink with TO_TIMESTAMP_LTZ

Convert Epoch to Timestamps in Apache Flink with TO_TIMESTAMP_LTZ

1
Comments
1 min read
Define a PostgreSQL database connection in JSON and import it in PGAdmin 4

Define a PostgreSQL database connection in JSON and import it in PGAdmin 4

5
Comments
1 min read
Use Aiven's metadata parser to understand how your data flows

Use Aiven's metadata parser to understand how your data flows

2
Comments
6 min read
Yep, my slides are useless!

Yep, my slides are useless!

3
Comments
5 min read
Use your own connector with Twitter and Aiven for Apache Kafka®

Use your own connector with Twitter and Aiven for Apache Kafka®

6
Comments
8 min read
Looking back at Kafka Summit 2022 London

Looking back at Kafka Summit 2022 London

Comments
5 min read
Beautify kcat consumer output by piping to jq

Beautify kcat consumer output by piping to jq

7
Comments
2 min read
Keep the SQL: Move from batch to streaming with Apache Kafka® and Apache Flink®

Keep the SQL: Move from batch to streaming with Apache Kafka® and Apache Flink®

5
Comments
13 min read
Support Database Technology Migration with Apache Kafka® and Apache Kafka® Connect

Support Database Technology Migration with Apache Kafka® and Apache Kafka® Connect

Comments
12 min read
Explore the new SEARCH and CYCLE features in PostgreSQL 14

Explore the new SEARCH and CYCLE features in PostgreSQL 14

7
Comments
10 min read
Manage Apache Kafka Connect connectors with kcctl

Manage Apache Kafka Connect connectors with kcctl

4
Comments
6 min read
Solving the knapsack problem in PostgreSQL

Solving the knapsack problem in PostgreSQL

5
Comments 2
8 min read
Get started with Apache Superset and PostgreSQL

Get started with Apache Superset and PostgreSQL

6
Comments
6 min read
How to create fake data with Python and Faker

How to create fake data with Python and Faker

1
Comments
1 min read
The pursuit of happiness with Python and PostgreSQL

The pursuit of happiness with Python and PostgreSQL

4
Comments
8 min read
TIG Stack: Using Telegraf, InfluxDB and Grafana on Aiven

TIG Stack: Using Telegraf, InfluxDB and Grafana on Aiven

2
Comments
5 min read
Analysing Netflix shows with pgAdmin and PostgreSQL

Analysing Netflix shows with pgAdmin and PostgreSQL

3
Comments
5 min read
Teach yourself Apache Kafka and Python with a Jupyter Notebook

Teach yourself Apache Kafka and Python with a Jupyter Notebook

9
Comments
8 min read
loading...