mysql

May 10 2022

Generating a Short Random ID in MySQL

SQL / 05/10/2022

From time to time, I have had to go back to a legacy database and for one reason or another add a non-integer surrogate key. Sometimes this has come up when working on an old API that exposes a primary key in the URL (GET /account/123). This generally can be bad for security, as a user could attempt to access other resources by incrementing the […]

Generating a Short Random ID in MySQL Continue Reading »

Dec 9 2019

PostgreSQL’s GREATEST (and LEAST) function

SQL / 12/09/2019

PostgreSQL has two functions that are not standard SQL, but are very helpful in certain situations : GREATEST and LEAST. In SQL MIN and MAX are aggregate functions that operate across all rows. But there are times where you want the smallest or largest value in a finite number of columns, a scalar min/max. That is where GREATEST and LEAST come in. Both allow for

PostgreSQL’s GREATEST (and LEAST) function Continue Reading »