June 2023 Recap of Tobias Petry - Issue #22
Laravel Live UK 2023
I was at the Laravel Live UK | 2023 conference this month which was a blast. I’ve met wonderful people and had some really interesting conversations.
And it was also the first time I had the honor of being able to give a talk. I told a packed room of 300 Laravel developers about the different ways of scaling a database. The countless hours of preparations had been worth it: They liked it!
I definitely want to do this again!
MySQL EXPLAIN Explained
Obviously, I have been doing quite some work for explainmysql.com:
New Algorithms
I’ve optimized the application so that the additional information of explain plans now shares a meaningful description for them. But they are also rating them whether they are good (green) or something you should look at (orange).
API
I always believed that you should make workflows as simple as possible. Copying queries from your application, running them in your favorite tool, copying the output and pasting it into explainmysql.com does not fit the “simple” label. So I’ve worked on an API to automatically submit results to the website. Th next months I will have to write integrations into so many tools…
Laravel
The first integration is an easy way to submit Laravel Query Builder plans by the API. With just a single command multiple metrics about the query are calculated, and submitted and you are getting the shareable URL.
That’s the simple workflow I always had in mind!
Check out the package: tpetry/laravel-mysql-explain
Laravel Query Expressions
It's the first Laravel query expressions release with expressions created by the community 🥳 You can now e.g. use MySQL's FIND_IN_SET() function with all databases if you have a legacy app that still stores concatenated string lists you need to search within.
Check out the package: tpetry/laravel-query-expressions
Laravel PostgreSQL Driver
The usual problem with ORM libraries is their ability to represent multiple databases. At first, this sounds great, but each database is different and to implement only the common features of all databases means to miss many specific functions. Since I primarily work with the Laravel framework and PostgreSQL, I started to develop an extended driver to support more features of PostgreSQL: tpetry/laravel-postgresql-enhanced
Last month these remarkable features were added:
My Database Tips
I’ve removed the weekly database tips from this newsletter. You can still get them by subscribing to the SqlForDevs newsletter.
Interesting Articles, News and Tools
I’ve moved the monthly links of interesting findings to my SQL For Devs newsletter. Compared to just once a month, I now share new findings every week!