VO IDs from mysql

[lordnahkim]

Hi,

(Cliff, you are a genius)

It seems the recommended creation of VOs, and retrieving those VOs is by using a Stringed ID - is that correct?  The reason I ask is because I'm developing an RIA pulling some arrays from MySQL (via ZendAMF).  I have limited knowledge of the LAMP end of things, so it is hard for me to explain my concern to that team.  My concern is with regard to retrieving IDs as Strings from MySQL - afaik they want to use numbered auto-increment.  Does it break with best practice to use those numbered records when ID'ing my VOs?  Or if anyone knows about lamp stuff, how should I approach fetching records to where I get a String that is more reliable?  They mentioned something about "keys"?

Hope that makes sense.  I appreciate your consultation!

[puremvc]

Auto-increment is easy, but not a super way to generate ids particularly if there will be a massive number of records. UUIDs  are the generally accepted way of creating string IDs that are universally unique. Its a 16 char string Based on time and MAC address usually, but there are various ways of generating them.

MySQL has a method for generating them.

Search wikipedia for UUID, there's a good treatment there.

-=Cliff>

[Joel Hooks]

Flex has UIDUtil for creating them.

[lordnahkim]

Thanks so much for the guidance guys!  I can already imagine the benefits of this approach.