Install seeded RAND as a sqlite function

Question

Install seeded RAND as a sqlite function

fsaad opened this issue 8 years ago · 1 comments

RANDOM from sqlite3 draws global entropy --- much better to draw from the bdb's seeded prng.

Answer 1 · 2017-06-25T14:09:59.000Z

We may further consider installing (i) a host of samplers for standard distributions, such as NORMAL, GAMMA, BETA, STUDENTT, VONMISES, etc, and (ii) trigonometric functions such as SIN, COS, ATAN, etc. These primitives could be a valuable addition to BQL, and assist in routines such as synthetic data generation, adding noise to columns, etc.