UUID Primary Keys make a lot of sense in modern applications, and UUIDs have become a popular way for developers to publicly identify objects in their applications. Benefits include: They obscure the identifier, making it virtually impossible for attackers to guess IDs. They allow Foreign Key references to be similarly ...

Whoah, that title is a mouthful. Let's break it down by starting with definitions: Correlated Aggregate Queries: self-joining a table using an aggregated value, e.g. MIN(id), to find the correlated value of a different column, e.g. URL. Scalar-Aggregate Comparison: the process of combining scalar and aggregate SQL functions to compare ...