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!
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
- Why We Changed YugaByte DB Licensing to 100% Open Source – Given the current general trend, this seems to me great news. Let’s not forget that open source is what made the current level of innovation possible.
- Concurrency is not Parallelism, by Rob Pike – a great explanation of what concurrency is, followed by practical explanation of how to implement it in Go.
- Organizations Running on More Clouds Less Likely to See Security Threats – Another point of view on why companies should use multiple cloud services (if they can afford to).
- Docker Security Considerations – PART I, by John Lionis – This explains why we should be concerned by Docker security, and it includes a list of containers capabilities.
- GitHub starts blocking developers in countries facing US trade sanctions – There were cases already, and this is something we should be concerned about. If you read this newsletter from one of those countries and you have experience to report, I’d like to hear it.
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.
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.