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

Pin Pinned

Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka
ftisiot profile

Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

#apachekafka #apacheflink #streaming #sql
11
Comments
11 min read
Helping PostgreSQL® professionals with AI-assisted performance recommendations
ftisiot profile

Helping PostgreSQL® professionals with AI-assisted performance recommendations

#postgres #sql #performance #ai
5
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.

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

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

#announcements #ai #postgres
2
Comments
3 min read
How to use pgbench to test PostgreSQL® performance
ftisiot profile

How to use pgbench to test PostgreSQL® performance

#postgres #pgbench #sql #performance
2
Comments
5 min read
From dbf to PostgreSQL with Python
ftisiot profile

From dbf to PostgreSQL with Python

#postgres #dbf #sql #python
Comments
2 min read
List of PostgreSQL® AI Projects and Resources
ftisiot profile

List of PostgreSQL® AI Projects and Resources

#postgres #ai #projects #resources
4
Comments
1 min read
11 Lessons to learn when using NULLs in PostgreSQL®
ftisiot profile

11 Lessons to learn when using NULLs in PostgreSQL®

#postgres #sql #null #isnull
8
Comments
11 min read
How to CONCAT in MySQL
ftisiot profile

How to CONCAT in MySQL

#mysql #concatenation #concat #string
Comments
6 min read
How to load JSON data in PostgreSQL with the COPY command
ftisiot profile

How to load JSON data in PostgreSQL with the COPY command

#postgres #json #copy #dataload
23
Comments
4 min read
Load StackOverflow's StackExchange data in PostgreSQL®
ftisiot profile

Load StackOverflow's StackExchange data in PostgreSQL®

#postgres #stackoverflow #stackexchange #dataload
Comments 2
7 min read
Managing data drift with Apache Kafka® Connect and a schema registry
ftisiot profile

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

#apachekafka #data
1
Comments
17 min read
1 billion rows challenge in MySQL
ftisiot profile

1 billion rows challenge in MySQL

#mysql #sorting #1brc
Comments
4 min read
How to use PostgreSQL® SUBSTRING
ftisiot profile

How to use PostgreSQL® SUBSTRING

#postgres #string #substring #regex
1
Comments
4 min read
1 billion rows challenge in PostgreSQL and ClickHouse
ftisiot profile

1 billion rows challenge in PostgreSQL and ClickHouse

#clickhouse #postgres #sorting
40
Comments 5
6 min read
How AI made my Amazon RDS for MySQL queries 23x faster
ftisiot profile

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

#mysql #rds #query #optimize
1
Comments
10 min read
Change Data Capture from Amazon RDS to Apache Kafka® with Debezium
ftisiot profile

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

#cdc #apachekafka #rds #debezium
3
Comments 1
5 min read
How to tabulate a JSON document in MySQL
ftisiot profile

How to tabulate a JSON document in MySQL

#mysql #json #tabulate
1
Comments
2 min read
Kafka Connect sink to OpenSearch/ElasticSearch: how to sink unix timestamps
ftisiot profile

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

#apachekafka #kafkaconnect #opensearch #elasticsearch
2
Comments
1 min read
Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector
ftisiot profile

Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector

#challenge #machinelearning #postgres
3
Comments 1
1 min read
Consume Apache Kafka® messages via REST APIs
ftisiot profile

Consume Apache Kafka® messages via REST APIs

#apachekafka #rest #http #opensource
1
Comments
3 min read
JSON vs JSONB in PostgreSQL
ftisiot profile

JSON vs JSONB in PostgreSQL

#postgres #json #jsonb
50
Comments 3
3 min read
How to JSON in MySQL
ftisiot profile

How to JSON in MySQL

#mysql #json
Comments
1 min read
Image recognition with Python, OpenCV, OpenAI CLIP and pgvector
ftisiot profile

Image recognition with Python, OpenCV, OpenAI CLIP and pgvector

#imagerecognition #python #postgres
2
Comments 1
10 min read
Pros and Cons of Multi Step Data Platforms
ftisiot profile

Pros and Cons of Multi Step Data Platforms

#data #platform #datapipeline
Comments
6 min read
So… what does a Staff Developer Advocate do?
ftisiot profile

So… what does a Staff Developer Advocate do?

#devrel #growth
Comments
5 min read
Use PostgreSQL® DOMAIN rules to validate columns of data
ftisiot profile

Use PostgreSQL® DOMAIN rules to validate columns of data

#postgres #validation #data #domain
Comments
7 min read
PostgreSQL® JSONB Cheatsheet: Complete and Fast Lookup Guide
ftisiot profile

PostgreSQL® JSONB Cheatsheet: Complete and Fast Lookup Guide

#postgres #jsonb #cheatsheet #json
1
Comments
4 min read
PostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup Guide
ftisiot profile

PostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup Guide

#postgres #jsonb #cheatsheet #json
49
Comments 4
4 min read
Does Apache Kafka® really preserve message ordering?
ftisiot profile

Does Apache Kafka® really preserve message ordering?

#apachekafka #order #messages
Comments
7 min read
Build your first data pipeline with Aiven for Apache Flink®
ftisiot profile

Build your first data pipeline with Aiven for Apache Flink®

#apacheflink #streaming #datapipeline
Comments
1 min read
Out of the box PostgreSQL monitoring with InfluxDB and Grafana dashboards
ftisiot profile

Out of the box PostgreSQL monitoring with InfluxDB and Grafana dashboards

#grafana #monitoring #influxdb
1
Comments
4 min read
Aiven's journey to enable a better Apache Flink® experience
ftisiot profile

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

#apacheflink #datastreaming #cloud
Comments
6 min read
What are the directions of technical data platforms scalability?
ftisiot profile

What are the directions of technical data platforms scalability?

#scalability #data #dataplatforms
1
Comments
5 min read
How to JSON in PostgreSQL®
ftisiot profile

How to JSON in PostgreSQL®

#postgres #json #query #sql
1
Comments 2
2 min read
From data stack to data stuck: the risks of not asking the right data questions
ftisiot profile

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

#data #questions #choice
Comments
5 min read
A SOFT methodology to define robust data platforms
ftisiot profile

A SOFT methodology to define robust data platforms

#dataplatforms #design #evaluate
Comments
9 min read
Tips for Successful Conference Abstracts
ftisiot profile

Tips for Successful Conference Abstracts

#tips #publispeaking #abstract #cfp
2
Comments
7 min read
8 tips to speed up Apache Kafka® Connect development
ftisiot profile

8 tips to speed up Apache Kafka® Connect development

#apachekafka #kafkaconnect #streaming #integration
Comments
9 min read
A Talk For One
ftisiot profile

A Talk For One

#talks #content #audience
Comments
6 min read
Using PostgreSQL® JSON functions to navigate reviews of restaurants in India
ftisiot profile

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

#postgres #json #analytics
8
Comments
8 min read
How to query remote InfluxDB via cURL
ftisiot profile

How to query remote InfluxDB via cURL

#influxdb #curl #query
1
Comments
1 min read
Picking a baby name with PostgreSQL® and FuzzyStrMatch
ftisiot profile

Picking a baby name with PostgreSQL® and FuzzyStrMatch

#postgres #fuzzystrmatch #stringmatching
2
Comments
6 min read
Remove naughty words from your data using DataCater
ftisiot profile

Remove naughty words from your data using DataCater

#postgres #datacater #data
1
Comments
9 min read
Convert Epoch to Timestamps in Apache Flink with TO_TIMESTAMP_LTZ
ftisiot profile

Convert Epoch to Timestamps in Apache Flink with TO_TIMESTAMP_LTZ

#apacheflink #timestamps #convert
1
Comments
1 min read
Define a PostgreSQL database connection in JSON and import it in PGAdmin 4
ftisiot profile

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

#pgadmin4 #connections #import
5
Comments
1 min read
Use Aiven's metadata parser to understand how your data flows
ftisiot profile

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

#metadata #graph #datalineage
2
Comments
6 min read
Yep, my slides are useless!
ftisiot profile

Yep, my slides are useless!

#publicspeaking #slides
3
Comments
5 min read
Use your own connector with Twitter and Aiven for Apache Kafka®
ftisiot profile

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

#apachekafka #kafkaconnect #twitter
5
Comments
8 min read
Looking back at Kafka Summit 2022 London
ftisiot profile

Looking back at Kafka Summit 2022 London

#kafkasummit #apachekafka #conference
Comments
5 min read
Beautify kcat consumer output by piping to jq
ftisiot profile

Beautify kcat consumer output by piping to jq

#apachekafka #kcat #json #jq
7
Comments 1
2 min read
Keep the SQL: Move from batch to streaming with Apache Kafka® and Apache Flink®
ftisiot profile

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

#apachekafka #apacheflink #streamingdatapipelines
5
Comments
13 min read
Support Database Technology Migration with Apache Kafka® and Apache Kafka® Connect
ftisiot profile

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

#apachekafka #apachekafkaconnect #database
Comments
12 min read
Explore the new SEARCH and CYCLE features in PostgreSQL 14
ftisiot profile

Explore the new SEARCH and CYCLE features in PostgreSQL 14

#postgres #recursion #newfeatures
7
Comments
10 min read
Manage Apache Kafka Connect connectors with kcctl
ftisiot profile

Manage Apache Kafka Connect connectors with kcctl

#apachekafka #kafkaconnect #kcctl
4
Comments
6 min read
Solving the knapsack problem in PostgreSQL
ftisiot profile

Solving the knapsack problem in PostgreSQL

#postgres #packing #analytics
5
Comments 2
8 min read
Get started with Apache Superset and PostgreSQL
ftisiot profile

Get started with Apache Superset and PostgreSQL

#apachesuperset #postgres #dataviz
8
Comments
6 min read
How to create fake data with Python and Faker
ftisiot profile

How to create fake data with Python and Faker

#python #faker #data
1
Comments
1 min read
The pursuit of happiness with Python and PostgreSQL
ftisiot profile

The pursuit of happiness with Python and PostgreSQL

#postgres #python #psycopg2 #pandas
4
Comments
8 min read
TIG Stack: Using Telegraf, InfluxDB and Grafana on Aiven
ftisiot profile

TIG Stack: Using Telegraf, InfluxDB and Grafana on Aiven

#grafana #telegraf #influxdb #monitoring
2
Comments
5 min read
Analysing Netflix shows with pgAdmin and PostgreSQL
ftisiot profile

Analysing Netflix shows with pgAdmin and PostgreSQL

#pgadmin #postgres #netflix #analytics
3
Comments
5 min read
Teach yourself Apache Kafka and Python with a Jupyter Notebook
ftisiot profile

Teach yourself Apache Kafka and Python with a Jupyter Notebook

#apachekafka #jupyter #notebooks #jupyterlab
9
Comments
8 min read