Re: [PHP] using UID in DB

2010-03-31 Thread Tommy Pham
On Wed, Mar 31, 2010 at 2:29 AM, Lester Caine wrote: > Tommy Pham wrote: >>> >>> Storage wise it is just a 128 bit number, so twice as big as a simple 64 >>> bit >>> 'generator' that would normally be used in a single database system. The >>> improvement is to use a raw number rather than a 16 cha

Re: [PHP] using UID in DB

2010-03-31 Thread Lester Caine
Tommy Pham wrote: Storage wise it is just a 128 bit number, so twice as big as a simple 64 bit 'generator' that would normally be used in a single database system. The improvement is to use a raw number rather than a 16 character string. Don't you mean raw number as 16 byte, which is what I in

Re: [PHP] using UID in DB

2010-03-31 Thread Tommy Pham
On Wed, Mar 31, 2010 at 12:37 AM, Lester Caine wrote: > Tommy Pham wrote: >> >> Hi, >> >> I'm just wondering if anyone on this list using some type of >> UID/UUID/GUID in any of the DB?  If so, what DBMS/RDBMS are you using >> and how many rows do you have for the table(s) using it?  What data >>

Re: [PHP] using UID in DB

2010-03-31 Thread Lester Caine
Tommy Pham wrote: Hi, I'm just wondering if anyone on this list using some type of UID/UUID/GUID in any of the DB? If so, what DBMS/RDBMS are you using and how many rows do you have for the table(s) using it? What data type are you using for that column? Firebird is currently improving suppo

Re: [PHP] using UID in DB

2010-03-30 Thread Tommy Pham
On Tue, Mar 30, 2010 at 8:38 PM, Paul M Foster wrote: > On Tue, Mar 30, 2010 at 08:07:01PM -0700, Tommy Pham wrote: > >> On Tue, Mar 30, 2010 at 7:37 PM, Paul M Foster >> wrote: >> > >> > Unless you have some compelling need to store a number like this, I >> > don't see the need to. What I store

Re: [PHP] using UID in DB

2010-03-30 Thread Paul M Foster
On Tue, Mar 30, 2010 at 08:07:01PM -0700, Tommy Pham wrote: > On Tue, Mar 30, 2010 at 7:37 PM, Paul M Foster > wrote: > > > > Unless you have some compelling need to store a number like this, I > > don't see the need to. What I store is what is called in PostgreSQL a > > "serial" value. MySQL cal

Re: [PHP] using UID in DB

2010-03-30 Thread Tommy Pham
On Tue, Mar 30, 2010 at 7:37 PM, Paul M Foster wrote: > > Unless you have some compelling need to store a number like this, I > don't see the need to. What I store is what is called in PostgreSQL a > "serial" value. MySQL calls it "auto_increment". You store all the other > values as a row, and th

Re: [PHP] using UID in DB

2010-03-30 Thread Paul M Foster
On Tue, Mar 30, 2010 at 02:18:53PM -0700, Tommy Pham wrote: > On Tue, Mar 30, 2010 at 2:04 PM, Paul M Foster > wrote: > > On Tue, Mar 30, 2010 at 01:36:27PM -0700, Tommy Pham wrote: > > > >> Hi, > >> > >> I'm just wondering if anyone on this list using some type of > >> UID/UUID/GUID in any of t

Re: [PHP] using UID in DB

2010-03-30 Thread Tommy Pham
On Tue, Mar 30, 2010 at 2:04 PM, Paul M Foster wrote: > On Tue, Mar 30, 2010 at 01:36:27PM -0700, Tommy Pham wrote: > >> Hi, >> >> I'm just wondering if anyone on this list using some type of >> UID/UUID/GUID in any of the DB?  If so, what DBMS/RDBMS are you using >> and how many rows do you have

Re: [PHP] using UID in DB

2010-03-30 Thread Paul M Foster
On Tue, Mar 30, 2010 at 01:36:27PM -0700, Tommy Pham wrote: > Hi, > > I'm just wondering if anyone on this list using some type of > UID/UUID/GUID in any of the DB? If so, what DBMS/RDBMS are you using > and how many rows do you have for the table(s) using it? What data > type are you using for

[PHP] using UID in DB

2010-03-30 Thread Tommy Pham
Hi, I'm just wondering if anyone on this list using some type of UID/UUID/GUID in any of the DB? If so, what DBMS/RDBMS are you using and how many rows do you have for the table(s) using it? What data type are you using for that column? TIA, Tommy -- PHP General Mailing List (http://www.php.n