Another slant on UUID from Uncle Ben. http://www.sys-con.com/coldfusion/article.cfm?id=705
Cheers, Phil. ----- Original Message ----- From: "Geoff Bowers" <[EMAIL PROTECTED]> Newsgroups: cfaussie To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 6:48 PM Subject: [cfaussie] Re: Whats your Primary Key? > Yorke Hinds wrote: > > What is the support in the AU community for the > > use of UUID over numeric primary keys in a DB/table? > > Plenty of support. Everyone who uses FarCry for instance uses UUIDs for > primary keys in most tables. To use or not use depends on the > application. The argument that integers provide faster indices is not > really relevant -- it depends on the application and its data as to > whether or not such a benefit has any bearing. > > This post lays out some pretty good reasoning for UUIDs as PKs: > http://affy.blogspot.com/2003_03_02_affy_archive.html#90405845 > > I'd add to that cross db platform support. > > > If not using UUID in as the primary key in the DB/table, > > what can be used to encode or mask url variables that > > include the primary key. I am aware of session variables > > and form variables to hide numeric records. > > What are you trying to do here? > > -- geoff > http://www.daemon.com.au/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
