Sponsor of the Day:
Jerkmate
https://will-keleher.com/posts/sql-queries-rarely-use-multiple-indexes/
A one-table SQL query will often use a single index · will keleher
For a query like `WHERE A = ? AND B = ?`, the most efficient index will be on `(A, B)` or `(B, A)`. Two indexes on `(A)` and `(B)` won't necessarily be...
one tablesql queryoften usesingleindex
https://will-keleher.com/posts/indexes_are_like_sorted_arrays/
Indexes are sorted arrays (sort of) · will keleher
Thinking of B-trees and B+-trees as sorted arrays can help you reason about indexes and performance.
sorted arraysindexeskeleher
https://will-keleher.com/posts/i-hate-literal-arguments/
Literal and Optional Parameters Can Make Code Hard to Read (in TypeScript) · will keleher
Avoiding literal and optional parameters leads to more readable code, and you should consider turning inlay hints for literal parameter names on if your editor...
optional parametersmake codeliteralhardread