Using Static Analysis + Speeding up JSON queries


Details
This month we will have two talks!
From Daniel Abernathy:
This talk will cover Multi-Valued Indexes, a feature released in MySQL 8 which lets you index an array of values per row - perfect for improving queries that rely on certain JSON functions.
And from Hunter Skrasek:
Numerous technologies exist for creating web applications, with PHP and JavaScript being the most prevalent. Their dynamic typing and runtime execution capabilities allow for a seamless transition from prototype to finished product. However, as apps grow in complexity and significance in our everyday lives, the absence of type safety and compilation checks might be felt. In this presentation, we will explore the concept of static analysis and its potential to enhance your team’s software development process.
Daniel Abernathy is a senior web developer who has worked with PHP and JavaScript for over 10 years. He is currently enjoying writing code with Vue.js at QAD Redzone.
Hunter is a Software Architect at Modernize Home Services and has been a software engineer since 2014. He has been using PHP, the Laravel framework, and containers for the last five years to enhance and expand the lead generation and marketing operations. When Hunter is not at work, he is either in charge of the Laravel Austin meetup or planning the next Longhorn PHP conference.
MergePHP is:
* AtlantaPHP
* AustinPHP
* AZ PHP
* BostonPHP
* Kansas City PHP
* San Diego PHP
* SeattlePHP
* UtahPHP
* Vegas PHP
* Vancouver PHP
Previous streams available:
https://www.youtube.com/c/MergePHP
Follow us on Twitter: https://twitter.com/MergePHP
Or Mastadon: https://phpc.social/@merge
***
Speaker Signups: https://beta.is/MergePHP

Using Static Analysis + Speeding up JSON queries