[Opensim-dev] sqlite3 UUID formats in build 3077

[Justin Clark-Casey]

Hi there,

The original change was accidental.  I appreciate your pain - I do 
believe we try to avoid changing things arbitrarily non-accidentally 
(for instance, we jumped through quite a few hoops a while back to 
maintain the existing different uuid persistence across the different 
databases when libsl changed their LLUUID.ToString() behaviour).

At some point there may need to be a large change to make LLUUID 
persistence consistent across the different database tables.  However, I 
would hope that when that day comes, everything is done in the same 
revision so the pain of migrating data only needs to be suffered once.

-- 
justincc
Justin Clark-Casey



James Stallings II wrote:
> I'm with CharlieO on this one. It may not impact you guys as 
> programmers a whole lot, but for those of us operating regions/grids 
> having this number change format is a nightmare. Please, settle on 
> some method of dealling with this and run with it.
>
> Thanks
> daTwitch/Hiro Protagonist
>
>
> On Jan 16, 2008 7:36 AM, unknown person <turbod_speedy at hotmail.com 
> <mailto:turbod_speedy at hotmail.com>> wrote:
>
>     If speed was not a factor in the change, due to the chaos such a
>     change,
>     then change back, then yet change again.......
>
>     Couldn't we just put something in that will read both types?
>     Check for uuid with AND without the dashes, at least until there is a
>     consensus on how this should be handled?
>
>     Tho I could just be blowing a smoke into the wind here as I have
>     no idea
>     as to why such changes are being made in the first place.
>     Just makes it hard for everyone else in the short term.
>
>     CharlieO
>
>     > Date: Tue, 15 Jan 2008 14:40:25 -0800
>     > From: mic.bowman at intel.com <mailto:mic.bowman at intel.com>
>
>     > To: opensim-dev at lists.berlios.de
>     <mailto:opensim-dev at lists.berlios.de>
>     > Subject: Re: [Opensim-dev] sqlite3 UUID formats in build 3077
>     >
>     > Thanks, Justin.
>     >
>     > Other than consistency across databases, I don't think it really
>     matters
>     > (its hard to think that a few bytes in the key size will make a
>     > difference in either storage or lookup time given the overall
>     size of
>     > most of the assets). Just wanted to know what the future looks like
>     > before I write the script to fix all the id's in my current
>     database.
>     > :-)
>     >
>     > --mic
>     >
>     >
>     > -----Original Message-----
>     > From: opensim-dev-bounces at lists.berlios.de
>     <mailto:opensim-dev-bounces at lists.berlios.de>
>     > [mailto:opensim-dev-bounces at lists.berlios.de
>     <mailto:opensim-dev-bounces at lists.berlios.de>] On Behalf Of Justin
>     > Clark-Casey
>     > Sent: Tuesday, January 15, 2008 2:25 PM
>     > To: opensim-dev at lists.berlios.de
>     <mailto:opensim-dev at lists.berlios.de>
>     > Subject: Re: [Opensim-dev] sqlite3 UUID formats in build 3077
>     >
>     > Bowman, Mic wrote:
>     > >
>     > > FYI... Current build (3077) changes UUID format in the local
>     asset
>     > > storage (sqlite3) to include the '-' in the UUID (local
>     storage was
>     > > using a format without the '-' for a while). Should we assume
>     that
>     > > format will continue? (It means I need to transform my current
>     asset
>     > > database... but it is consistent with storage format for UUIDs
>     used in
>     >
>     > > many other places.)
>     > >
>     > > --mic
>     > >
>     > This happened in r3069. In r3081 I've reversed it so we're back
>     to using
>     >
>     > the non-dashed format. However, I'm not sure if this was done on
>     purpose
>     >
>     > - if it was, you might see it change back again shortly ;)
>     >
>     > --
>     > justincc
>     > Justin Clark-Casey
>     >
>     > _______________________________________________
>     > Opensim-dev mailing list
>     > Opensim-dev at lists.berlios.de <mailto:Opensim-dev at lists.berlios.de>
>     > https://lists.berlios.de/mailman/listinfo/opensim-dev
>     <https://lists.berlios.de/mailman/listinfo/opensim-dev>
>     > _______________________________________________
>     > Opensim-dev mailing list
>     > Opensim-dev at lists.berlios.de <mailto:Opensim-dev at lists.berlios.de>
>     > https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>     ------------------------------------------------------------------------
>     Make distant family not so distant with Windows Vista® + Windows
>     Live™. Start now!
>     <http://www.microsoft.com/windows/digitallife/keepintouch.mspx?ocid=TXT_TAGLM_CPC_VideoChat_distantfamily_012008>
>
>     _______________________________________________
>     Opensim-dev mailing list
>     Opensim-dev at lists.berlios.de <mailto:Opensim-dev at lists.berlios.de>
>     https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>
>
>
> -- 
> ===================================
> The wind
> scours the earth for prayers
> The night obscures them
> ------------------------------------------------------------------------
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>