by Matthew Oldham

How to produce meaningful datasets using only SQL

c3RZ6H8yQUyutaAVkfkX7d5DvPm1-NLcbKgY
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…