Re: [sqlite] Unique ids over several databases or auto_increment primary or id range.

On 4/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > Hi, i have several databases with same structure on several hosts, and > > want them to generate globaly unique ids. > > Then random() function generates 64-bits of high-quality > randomness that you can use

Re: [sqlite] Unique ids over several databases or auto_increment primary or id range.

[EMAIL PROTECTED] wrote: > Hi, i have several databases with same structure on several hosts, and > want them to generate globaly unique ids. Then random() function generates 64-bits of high-quality randomness that you can use for a ID. Such IDs will be unique with a very high probability,

[sqlite] Unique ids over several databases or auto_increment primary or id range.

Hi, i have several databases with same structure on several hosts, and want them to generate globaly unique ids. So can I add row to table with explicit id and without modyfing rowid sequence? eg insert into db (value) values ( 'first' ) ; insert into db (value) values ( 'second' ) ; insert