How to use UUID "Pseudo" Primary Keys in Django Rest Framework in 2 easy steps!

UUID Primary Keys in  Django Rest Framework in 2 Easy Steps

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 ...

Continue reading

Scalar-Aggregate Comparison for High-Performance Correlated Aggregate SQL Queries

Scalar-Aggregate Comparison for High-Performance Correlated Aggre

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 ...

Continue reading