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

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 compare cross-columnar ...

Continue reading

How to use UUID "Pseudo" 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 obscured.They allow for ...

Continue reading

Tesla Could Compete With Apple In The Smartphone Space

SummaryTesla's brand affinity is almost on-par with Apple.Tesla has the tech & team to build competitive smartphones with Apple.Tesla may pivot to generate revenue to support other efforts.I love Tesla (TSLA). Who doesn't? Even passionate short-sellers and Elon Musk critics often offer a caveat that their bearishness is on execution, ...

Continue reading