probcomp / bayeslite

BayesDB on SQLite. A Bayesian database table for querying the probable implications of data as easily as SQL databases query the data itself.
http://probcomp.csail.mit.edu/software/bayesdb
Apache License 2.0
922 stars 64 forks source link

Install seeded RAND as a sqlite function #565

Closed fsaad closed 7 years ago

fsaad commented 7 years ago

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

fsaad commented 7 years ago

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.