Federico Razzoli, Author at Vettabase

<img width="60" height="60" src="https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant-96x96.jpeg" class="avatar avatar-60 photo" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant-96x96.jpeg 96w, https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant-150x150.jpeg 150w, https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant-12x12.jpeg 12w, https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant-24x24.jpeg 24w, https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant-48x48.jpeg 48w, https://vettabase.com/blog/wp-content/uploads/2020/10/federico-razzoli-mysql-consultant.jpeg 200w" sizes="(max-width: 60px) 100vw, 60px" />

About Federico Razzoli

Federico is Vettabase Ltd director, and he's an expert database consultant specialised in the MariaDB and MySQL ecosystems.

Vettabase announces immudb partnership with Codenotary Inc

Posted on 18 October 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/06/experiment_with_immu-640x318.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/experiment_with_immu-640x318.jpeg 640w, https://vettabase.com/blog/wp-content/uploads/2021/06/experiment_with_immu-16x9.jpeg 16w" sizes="(max-width: 640px) 100vw, 640px" />

We are happy to announce that Vettabase started a partnership with the immudb team. immudb is an immutab;e, relational and K/V database. Continue reading Vettabase announces immudb partnership with Codenotary Inc→

The costs of using multiple database technologies

Posted on 3 October 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/10/introducing_new_databases-1-640x318.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/10/introducing_new_databases-1-640x318.png 640w, https://vettabase.com/blog/wp-content/uploads/2021/10/introducing_new_databases-1-16x8.png 16w" sizes="(max-width: 640px) 100vw, 640px" />

Before introducing a new database technology in your organisation, consider the drawbacks. Continue reading The costs of using multiple database technologies→

How slow is SELECT * ?

Posted on 18 September 2021 by Federico Razzoli — 4 Comments ↓

<img width="600" height="311" src="https://vettabase.com/blog/wp-content/uploads/2021/09/select_star.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/select_star.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/select_star-300x156.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/select_star-16x8.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continue reading How slow is SELECT * ?→

Identify useless queries in MariaDB/MySQL

Posted on 7 September 2021 by Federico Razzoli — No Comments ↓

<img width="600" height="237" src="https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries-300x119.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/identify_useless_queries-16x6.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

Some queries always fail or never return rows. They should be eliminated to improve database performance. Continue reading Identify useless queries in MariaDB/MySQL→

NULL comparisons in MariaDB, PostgreSQL, and SQLite

Posted on 6 September 2021 by Federico Razzoli — No Comments ↓

<img width="600" height="311" src="https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1.png" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1.png 600w, https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1-300x156.png 300w, https://vettabase.com/blog/wp-content/uploads/2021/09/null_comparisons-1-16x8.png 16w" sizes="(max-width: 600px) 100vw, 600px" />

Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem. Continue reading NULL comparisons in MariaDB, PostgreSQL, and SQLite→

Choosing Cassandra consistency levels

Posted on 9 August 2021 by Federico Razzoli — 2 Comments ↓

<img width="600" height="311" src="https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level.jpeg 600w, https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level-300x156.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/08/cassandra_choose_consistency_level-16x8.jpeg 16w" sizes="(max-width: 600px) 100vw, 600px" />

Choose the best balance between speed and consistency by setting proper consistency levels. Continue reading Choosing Cassandra consistency levels→

ALERT: Many Cassandra users may need an urgent upgrade

Posted on 28 July 2021 by Federico Razzoli — No Comments ↓

<img width="446" height="300" src="https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Vettabase Monthly Time" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller.jpeg 446w, https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller-300x202.jpeg 300w, https://vettabase.com/blog/wp-content/uploads/2021/06/hours_smaller-16x12.jpeg 16w" sizes="(max-width: 446px) 100vw, 446px" />

Vettabase Monthly Time

Cassandra 4.0 GA was released on 26th July 2021. Older versions users need to upgrade quickly. Continue reading ALERT: Many Cassandra users may need an urgent upgrade→

Automating interactive programs execution with Expect

Posted on 13 July 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/07/automate_interactive_programs_with_expect-640x318.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/07/automate_interactive_programs_with_expect-640x318.jpeg 640w, https://vettabase.com/blog/wp-content/uploads/2021/07/automate_interactive_programs_with_expect-16x8.jpeg 16w" sizes="(max-width: 640px) 100vw, 640px" />

How we automated the creation of immudb users and databases with the help of the Expect language. Continue reading Automating interactive programs execution with Expect→

Cassandra login error: Cannot achieve consistency level LOCAL_ONE

Posted on 9 July 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/07/cassandra_cannot_achieve_local_one-640x318.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/07/cassandra_cannot_achieve_local_one-640x318.jpeg 640w, https://vettabase.com/blog/wp-content/uploads/2021/07/cassandra_cannot_achieve_local_one-16x8.jpeg 16w" sizes="(max-width: 640px) 100vw, 640px" />

Cassandra login fails with: “Cannot achieve consistency level LOCAL_ONE”? Let’s see why it happens, and how to solve the problem Continue reading Cassandra login error: Cannot achieve consistency level LOCAL_ONE→

A summary of MariaDB 10.6

Posted on 7 July 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/07/upgrade_to_mariadb_10_6-640x318.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/07/upgrade_to_mariadb_10_6-640x318.jpeg 640w, https://vettabase.com/blog/wp-content/uploads/2021/07/upgrade_to_mariadb_10_6-16x8.jpeg 16w" sizes="(max-width: 640px) 100vw, 640px" />

MariaDB 10.6 is now Generally Available! Let’s see what’s new and if it’s worth an upgrade. Continue reading A summary of MariaDB 10.6→