HTTP/3 via QUIC

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 – SQL Optimizer And Rewriter

 

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:

  • Cross-platform support, such as Linux, Mac, and Windows
  • Support Heuristic Rules Suggestion
  • Support Complicate SQL Indexing Optimize
  • Support EXPLAIN analyze for query plan
  • Support SQL fingerprint, compress and built-in pretty print
  • Support merge multi ALTER query into one SQL
  • Support self-config rewrite rules from SQL Rewrite
  • Suggestions were written in Chinese. But SOAR also gives many tools, which can be used without understanding Chinese.

And if you are familiar with the other tools that provide similar functionality, here’s how SOAR compares to them:

The Complete Guide to WordPress Performance Optimization

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

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:

  • Inefficient architecture for writes
  • Inefficient data replication
  • Issues with table corruption
  • Poor replica MVCC support
  • Difficulty upgrading to newer releases

HTTP : The headers we want

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.