Posts tagged with sql
The final part of Oh Dear's series on SQL performance. Mattias introduces phpunit-query-count-assertions, a package that catches N+1 queries, duplicate queries, and missing indexes in your test suite. Since implementing this at Oh Dear, they've eliminated 15% of their SELECT queries.
Read more [ohdear.app]
While parameterized queries are the preferred method, sole() adds an extra layer of protection when using raw queries, especially when only one record should match.
Read more [aaronsaray.com]
Join thousands of developers
Every two weeks, I share practical tips, tutorials, and behind-the-scenes insights from maintaining 300+ open source packages.
No spam. Unsubscribe anytime. You can also follow me on X.
Mattias delves into optimizing SQL queries using indexes, focusing on MySQL 8.0. He explains how indexes work, how to analyze slow queries using MySQL’s EXPLAIN keyword, and the impact of different index configurations on query performance.
Read more [ohdear.app]
At Oh Dear, my colleague Mattias recently vastly increased the performance of our service. Here's how he did it.
Read more [ohdear.app]
– tighten.com - submitted by Kayla Helmick
Learn how to use SQL generated columns and database views in Laravel to simplify queries, boost performance, and make your data easier to filter, sort, and reuse across your application.
Read more [tighten.com]
Here are some special cases that you should keep in mind when working with NULL.
Read more [raymondtukpe.com]
Pretty cool that you can achieve this by executing a query, and without application logic.
Read more [sqlfordevs.com]
– aaronfrancis.com - submitted by Aaron Francis
Spoiler: it is optimized to be fast, and you should use it.
Read more [aaronfrancis.com]
Let's explain the two most important topics when working with RDBMSs: indexes and transactions.
Read more [architecturenotes.co]
While Amazon S3 is awesome for storage, It also has a feature called S3 Select. With S3 Select, You can use a simple SQL query to filter the content of the stored objects. and retrieve only a subset of data that you need.
Read more [sanjit.me]
– tray2.se - submitted by Patrik Ahlström
I hope you won't run into any of these.
Read more [tray2.se]
– aaronfrancis.com - submitted by Aaron Francis
A slight modification to traditional offset/limit pagination that can drastically boost performance.
Read more [aaronfrancis.com]
By thinking outside of the box, you can often get much faster database performance by splitting values across multiple database columns.
Read more [downing.tech]
Tobias explains how you can make this operation very fast even if your table has several million records.
Read more [tpetry.me]
Databases are the backbone of most modern systems, so taking some time to understand how they work is a good investment for any developer.
Read more [hakibenita.com]
sql tips: you can group by anything pic.twitter.com/YoJVlUyghG
— ?Julia Evans? (@b0rk) 29 september 2019
Read more [twitter.com]
CASE is SQLs answer to other programming languages IF-ELSE statement. If you need to test a condition and return a value CASE is the expression you need.
Read more [www.helenanderson.co.nz]
My colleague Brent offers some more details on the intricacies of Laravel's query builder.
I recently learned that not all query builder functionality in Laravel is "safe". This means that user input shouldn't be passed directly to it, as it might expose your application to SQL injection vulnerabilities.
Read more [stitcher.io]
Our laravel-query-builder package exposed a serious security issue: it allowed SQL injection attacks. Laravel Query Builder v1.17.1, which is now available, fixes the vulnerability. If you're using the package, stop reading now and upgrade to the latest version first. For Laravel 5.6, 5.7 and 5.8…
In an amazing (and funny) talk Lukas Eder demonstrates how powerful SQL (or any 4th generation programming language) really is.