From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg] On Behalf Of Paolo Vernazza Sent: 18 January 2006 11:30 To: [email protected] Subject: Re: [sqlite] [RBL] [sqlite] Randomly ordering results
Steve O'Hara ha scritto: > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > rg] On Behalf Of [EMAIL PROTECTED] > Sent: 17 January 2006 17:37 > To: [email protected] > Subject: Re: [sqlite] [RBL] [sqlite] Randomly ordering results > > "Steve O'Hara" <[EMAIL PROTECTED]> wrote: > >> The standard SQLite function random() is actually seeded by >> the current time and date every time you open a database. >> >> > > FWIW, the random() function in SQLite uses a cryptographic > PRNG and (at least on Unix) is seeded using /dev/urandom > if that device is available. So it should give you very > good randomness. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > -----Original Message----- > > You are of course right, I just looked at the Windows version which is > seeded on date/time. > Sorry, but I can't miss to write: Steve, If you're going to offer advice, at least do some basic research to make sure it's accurate. ;) Paolo -----Original Message----- LOL Hoisted by my own petard !! Steve
