SAMPLING WITH SQL

Summary from the TLDR Web Dev newsletter

For efficient SQL sampling techniques for large datasets, the A-ES algorithm can be used for weighted sampling without replacement. This article explains a novel SQL-based approach for sampling with replacement, using the A-ES algorithm and showing off its effectiveness through a biased coin flip simulation.