Federico-Razzoli.com UPDATEs #4

Newsletter sent on 7th August 2019

Good Wednesday morning – if you are in Europe.

Federico-Razzoli.com UPDATEs resumes after a long silence. My business is still a one-person business, so it can happen that I’m too busy to write. I knew from the beginning that I won’t be always be able to write you every Monday morning, but I’ll do my best to avoid several weeks delays in the future.

Let’s see if I manage to make this issue interesting enough to be excused for the delay!

Federico-Razzoli.com contents

An article I had in my mind for a long time is MySQL/MariaDB: use SQL properly to run less queries. Compare how much time database vendors spend to improve and extend SQL language (both implementation and the standards), and how much non-trivial syntax is actually used. Isn’t the difference ridiculous? Yet, SQL is really useful and expressive. Knowing it better allows us to ask exactly what we want, instead of reinventing many wheels in our code. And obtain the result in a shorter time, consuming less server resources, keeping the code clearer & more maintainable.

The latter three points mean that our website will retain more users, and our company will save money for its infrastructure and for future development. Doing things right is a great satisfaction for a professional, but it’s also and above all a solid contribute to business. This is an argument you may want to use in your next discussions with your product manager, they will probably understand your point of view and appreciate your mindset.

Remember my series of articles on InnoDB indexes? Well, I felt there was a missing piece: Why MySQL tables need a primary key. I wrote it as a reference to show developers when they believe that a table shouldn’t have a primary key, but it can be useful for many persons. If you have more arguments, please add a comment – contributions are always welcome.

Articles from the web

Events

First of all, let me say that the latest two events of London Open Source Databases meetup, with Peter Zaitsev (Percona CEO) and Monty Widenius (MySQL and MariaDB’s dad) were a success!

The next big even I’m looking forward to is Percona Live Europe 2019. The call for papers is closed and I’m waiting to know if my proposals were accepted.

About me

If you like my contents, my public talks, my books and this newsletter, you may want to check my professional services. If you can’t make this kind of decisions, please consider to endorse me with your manager.

Thank you!

Toodle pip,
Federico Razzoli