by Matthew Oldham

How to produce meaningful datasets using only SQL

Photo by Mika Baumeister on Unsplash

Have you ever needed to seed a database with random, yet realistic, data for the purposes of testing, demonstration, or training? It’s a very common requirement, and one I have faced many times.

It doesn’t take long in the development timeline before someone needs to test with “real” data. Since my role in past projects has almost exclusively been oriented around the data tier…