Is anyone using random strings as their primary key? Uuids, guids, etc. I
have random 27 character strings that I'm creating. They are very similar
to uuids, but a little more aesthetically pleasing.
I'd like to start using them as my primary keys, so when it comes time to
scale out my database onto multiple machines things will be easier.
The docs, luckily, :) do explain how to to this. So that's good.
But I'd like some reassurance anyway. Last thing I need is to come up
against some obscure bug because I'm the only one using this feature. I
mean obscure but immediate would be okay. But database corruption or
inconsistencys gives me the willies. Is anyone else doing this?
By the way, here is the relevant part of the docs:
Non-Integer Keys <http://www.sqlobject.org/SQLObject.html#id56>
While not strictly a legacy database issue, this fits into the category of
"irregularities". If you use non-integer keys, all primary key management is
up to you. You must create the table yourself (SQLObject can create tables
with int or str IDs), and when you create instances you must pass a
idkeyword argument into constructor (like
Person(id='555-55-5555', ...)).
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
