RE: [sqlite] GUID/UUID in sqlite.

2007-08-29 Thread Prakash Reddy Bande
-Original Message- From: Scott Hess [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 29, 2007 1:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] GUID/UUID in sqlite. In either case, if you use the UUID as a primary key in more than one table, you should consider having one table to convert

Re: [sqlite] GUID/UUID in sqlite.

2007-08-29 Thread Scott Hess
In either case, if you use the UUID as a primary key in more than one table, you should consider having one table to convert the UUID to a 64-bit id, and use that as the primary keys on the other tables. If you have UUID as a primary key, your table will have 2 b-trees, one for the index of UUID

RE: [sqlite] GUID/UUID in sqlite.

2007-08-29 Thread Prakash Reddy Bande
To: sqlite-users@sqlite.org Subject: Re: [sqlite] GUID/UUID in sqlite. You could experiment with making your 128 bit entity a BLOB. The alternative would be to represent it it in ASCII. Changing its radix would probably be the significant overhead, not the Sqlite storage. Prakash Reddy Bande wrote

Re: [sqlite] GUID/UUID in sqlite.

2007-08-29 Thread John Stanton
You could experiment with making your 128 bit entity a BLOB. The alternative would be to represent it it in ASCII. Changing its radix would probably be the significant overhead, not the Sqlite storage. Prakash Reddy Bande wrote: Hi, I am designing a database where-in my column data is