As we are still trying to get the grip with HTTP/2, the world is moving on. Here’s the blog post with some initial details on HTTP/3 and QUIC. Turns out, we moving away from TCP to UDP with encryption.
Here are more details from the CloudFlare blog post.
Let the fear, uncertainty, and doubt begin!
SOAR is an SQL Optimizer and Rewriter. It can help analyse, optimize, and rewrite SQL queries. Don’t get offset by the Chinese documentation as default – there is an English translation.
Here are some of the features:
And if you are familiar with the other tools that provide similar functionality, here’s how SOAR compares to them:
SitePoint runs an extensive guide to the WordPress performance optimization. Not only it goes over the usual points like hosting selection and avoiding unnecessary plugins, but it also provides some insight into the WordPress database management and optimization, web server tweaks, and links to a few handy tools to help with performance of your site.
“Why Uber Engineering Switched from Postgres to MySQL” is an interesting study with plenty of technical detail of how MySQL was a better choice than PostgreSQL for the very demanding growth of Uber. These kinds of issues are probably way out of scope for any “regular Joe” application, but the insight into the differences of MySQL and PostgreSQL architectures is still useful.
Main PostgreSQL limitations covered by the study are:
“The headers we want” is a very simple, straight to the point blog post on the Fastly blog. Unlike many other more generic articles on the subject, it doesn’t try to explain the meaning of every HTTP header out there, and it doesn’t go into deep theory or the meaning of life, the universe and everything.
Instead it tells you plain and clear which headers should be emitted by your website or web application. And these cover everything from the usual Content-Type and Content-Length, all the way down to the CORS and Server-Timing.
Once the basic functionality of your website or web application is done and out of the way, this blog post comes in handy with the specific best practices to make your site more secure and much faster.
For more on the same subject, have a look at “The headers we don’t want” in the same blog.