FtisiotHow to speed up COUNT(DISTINCT)While counting is common in every application, sometimes it is not enough: when we need to display the amount of unique users generating…15 min read·Jan 17, 2024----
FtisiotHow AI made my Amazon RDS for MySQL queries 23x fasterLearn how I found MySQL slow queries and optimised the performance with EverSQL’s AI-driven optimisation engine to get 23x performance gain10 min read·Jan 4, 2024----
FtisiotHow to JSON in MySQLThis series covers how to solve common problems on JSON datasets with MySQL and it includes (links will appear once the target pages are…1 min read·Jul 21, 2023----
FtisiotSo… what does a Staff Developer Advocate do?So… what does a Staff Developer Advocate do, and how is it different from the Senior Developer Advocate role you were doing before?5 min read·May 24, 2023----
FtisiotPostgreSQL® JSONB Cheatsheet: Complete & Fast Lookup GuideHow do I extract a JSON item? What about tabulating the content? Can I build a set of rows from an array?4 min read·May 2, 2023----
FtisiotDoes Apache Kafka® really preserve message ordering?One of Apache Kafka®’s most known mantras is “it preserves the message ordering per topic-partition”, but is it always true? In this blog…7 min read·Mar 31, 2023----
FtisiotOut of the box PostgreSQL monitoring with InfluxDB and Grafana dashboardsGrafana® visualizes time series data as a graph, allowing you to observe how your application behaves over time. Grafana dashboards offer…5 min read·Mar 24, 2023----
FtisiotA SOFT methodology to define robust data platformsIn today’s data-driven era, it’s critical to design data platforms to help business to foster innovation and compete in the market…9 min read·Jan 5, 2023----
FtisiotFrom data stack to data stuck: the risks of not asking the right data questionsCompanies are in a continuous motion: new requirements, new data streams, new technologies are popping up every day. When designing new…6 min read·Dec 21, 2022----
FtisiotUsing PostgreSQL® JSON functions to navigate reviews of restaurants in IndiaAnalyse Indian restaurant reviews using PostgreSQL® JSON functions8 min read·Nov 22, 2022----