Book Image

Mastering The Faster Web with PHP, MySQL, and JavaScript

By : Andrew Caya
Book Image

Mastering The Faster Web with PHP, MySQL, and JavaScript

By: Andrew Caya

Overview of this book

This book will get you started with the latest benchmarking, profiling and monitoring tools for PHP, MySQL and JavaScript using Docker-based technologies. From optimizing PHP 7 code to learning asynchronous programming, from implementing Modern SQL solutions to discovering Functional JavaScript techniques, this book covers all the latest developments in Faster Web technologies. You will not only learn to determine the best optimization strategies, but also how to implement them. Along the way, you will learn how to profile your PHP scripts with Blackfire.io, monitor your Web applications, measure database performance, optimize SQL queries, explore Functional JavaScript, boost Web server performance in general and optimize applications when there is nothing left to optimize by going beyond performance. After reading this book, you will know how to boost the performance of any Web application and make it part of what has come to be known as the Faster Web.
Table of Contents (19 chapters)
Title Page
Copyright and Credits
Dedication
Packt Upsell
Foreword
Contributors
Preface
Free Chapter
1
Faster Web – Getting Started
6
Querying a Modern SQL Database Efficiently
Index

Modern SQL


What is Modern SQL and how does it distinguish itself from traditional SQL? What are its main features? Let's start by defining the concept itself.

Definition

As Markus Winand states on his website https://modern-sql.com, Modern SQL can be defined as "an internationally standardized, widely available and Turing complete data processing language supporting relational and non-relational data models." This definition refers to a set of standards that were promoted by the ISO and ANSI organizations over the years and that added new features to the SQL programming language. Since SQL-92, many new versions of the SQL standard were adopted and these standards introduced many new features based on relational and non-relational models. Here is a short list of these features with the corresponding standard that confirmed their adoption into the SQL language:

  • WITH and WITH RECURSIVE (SQL:1999)
  • CASE (SQL:1999 and SQL:2003)
  • OVER AND PARTITION BY (SQL:2003 and SQL:2011)
  • OVER AND ORDER BY (SQL:2003...