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
