Utah PG Meetup

Greetings,
We have a great presentation this month from Brian Broderick. All the details are below. This will once again be in Person at Entrata and also online.

Title: Learn how databases parse SQL and use this knowledge to optimize your schema and queries.All programming languages convert code into instructions that it needs to execute. Though SQL tells a database what data to read or write, it works the same.Over the past several years, I’ve been writing tools to understand how queries perform. One such tool is Lantern, an open-source project that parses SQL and performs static analysis on the queries. Currently, it determines which queries ran the most and which caused the most strain on the database. Future work will analyze data access patterns such as table and column usage to help inform schema and query optimizations.Using Lantern as an example, we’ll discuss the different components a database uses to understand SQL, namely tokens, lexers, scanners, parsers, ASTs, evaluators, etc.A deeper understanding of how databases work will give you more tools to make the right design decisions for your projects.Bio:

Brian Broderick
I once asked, out loud, “What is a database? And why would I ever need to use one?” Little did I know then that they would define my career for the next two decades.
Other interests include pottery, hiking, and looking for something good to stream on TV.
Find me on GitHub at: https://github.com/brianbroderick

The meetup will say "online" so that we can share the zoom link but we will also be in person @
Entrata
4205 Chapel Ridge Rd, Lehi, UT 84043