[Opensim-dev] Thoughts on UUID

[liu xiaolu]

One more thing about UUID's data type in Database,
MySQL:
UUID is "Binary(16)" in assets table, and "varchar(36)" in other tables.
MSSQL:
All UUIDs are "varchar(36)".

* I have been a long time confused with hyphenated, non-hyphenated UUIDs,
now is much better, but still, I have some suggestions about UUID:

1. at least the data type of UUID in different tables should be unified.
(MySQL)
2. binary(16) is more suitable than varchar(n)
3. varchar(32) is better than varchar(36)


2008/4/10, Kyle Hamilton <aerowolf at gmail.com>:
>
> Why not derive OSUUID from LLUUID, with the additional attribute
> [serializable], provide an implicit conversion operator that provides
> LLUUID, and provides a constructor from LLUUID?  Is LLUUID sealed or
> something?
>
> (even if it is, at least should be able to provide an implicit
> conversion and constructor to reduce the impact of LLUUID on the
> codebase here.)
>
> -Kyle H
>
>
>
> On Wed, Apr 9, 2008 at 11:14 AM, Sean Dague <sean at dague.net> wrote:
> > One of the things that I ran into today is how many places LLUUID ends
> >  up in our code base from libsecondlife.  While not always a problem it
> >  does lead to some oddness.
> >
> >   * libsecondlife is a required link for lots of classes that just need
> a
> >    UUID
> >   * LLUUID is not serializable, which causes us some pain
> >   * LLUUID has changed a couple of times in the past, causing us grief
> >
> >  It seems like it would be a good idea to replace LLUUID as much as
> >  possible with our own OSUUID (I put a sample in
> >  OpenSim/Framework/OSUUID.cs).  It would look very similar to LLUUID
> >  (which is basically just a wrapper on System.Guid), but be
> >  [Serializable].  It would also mean that we could drop a lot of
> >  libsecondlife references.  I think that would be required for Stefan's
> >  OpenSim.Model idea.
> >
> >  Thoughts?
> >
> >  This will be a lot of work if we decide to do it, and a couple of days
> >  of brutal instability to do a swap out like this, as we can't get rid
> of
> >  LLUUID entirely (we need it when we get to packet generation I think).
> >
> >  Discussion on this one would be appreciated.  Definitely wouldn't want
> >  to make any changes like this without full agreement from everyone.
> >
> >    -Sean
> >
> >  --
> >  __________________________________________________________________
> >
> >  Sean Dague                                       Mid-Hudson Valley
> >  sean at dague dot net                            Linux Users Group
> >  http://dague.net                                 http://mhvlug.org
> >
> >  There is no silver bullet.  Plus, werewolves make better neighbors
> >  than zombies, and they tend to keep the vampire population down.
> >  __________________________________________________________________
> >
>
> > -----BEGIN PGP SIGNATURE-----
> >  Version: GnuPG v1.4.6 (GNU/Linux)
> >
> >  iD8DBQFH/QeiSamXem9TdyYRAs+VAJ9Vds9RzmfxTiy2/swosyCwjY4rWACeLEMq
> >  MKoDpHQOEc+oJYGMU2arhQ4=
> >  =KysI
> >  -----END PGP SIGNATURE-----
>
> >
> > _______________________________________________
> >  Opensim-dev mailing list
> >  Opensim-dev at lists.berlios.de
> >  https://lists.berlios.de/mailman/listinfo/opensim-dev
> >
> >
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>



-- 
Liu Xiaolu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080410/e6bb586d/attachment-0001.html>