Re: Is randomblob(16) a good guid generation across multiple computers?

Rowan Worth <[email protected]> Fri, 21 Feb 2020 09:00:20 +0800
Newsgroups gmane.comp.db.sqlite.general
Message-ID <CAJtcO2RTfmUKEJOWTK4TOKZh0m5fS48w2uo8drL8odM1KpqAuw@mail.gmail.com>
On Fri, 21 Feb 2020 at 03:59, Jens Alfke <[email protected]> wrote:

> > On Feb 20, 2020, at 10:48 AM, Richard Hipp <[email protected]> wrote:
> >
> > That assumption is not correct for SQLite, which does you a
> > cryptographically strong PRNG.  And the SQLite PRNG is seeded from
> > /dev/random on unix.
>
> Not quite; I'm looking at the function unixRandomness() in SQLite 3.28.
> It's seeded from /dev/urandom, which on Linux "will produce lower quality
> output if the entropy pool drains, while /dev/random will prefer to block
> and wait for additional entropy to be collected." (I'm quoting the macOS
> man page, which goes on to say that on macOS it always returns high-quality
> randomness.)
>

There are a lot of myths in this area, but from what I gather /dev/urandom
is totally fine for cryptographic purposes in modern linux, and any
advantages of /dev/random are highly overstated.

https://www.2uo.de/myths-about-urandom/
 -Rowan
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users