<html><body>
<p>+1 for form 2. From my experience with SNMP OIDs, long string of numbers=bad for most humans.<br>
<br>
Kurt R Taylor <br>
<br>
(Kurt Stringer)<br>
<a href="http://opensimulator.org">http://opensimulator.org</a><br>
International Business Machines, Corp.<br>
<br>
<img width="16" height="16" src="cid:2__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt="Inactive hide details for Sean Dague <sean@dague.net>">Sean Dague <sean@dague.net><br>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td style="background-image:url(cid:3__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="40%">
<ul>
<ul>
<ul>
<ul><b><font size="2">Sean Dague <sean@dague.net></font></b><font size="2"> </font><br>
<font size="2">Sent by: opensim-dev-bounces@lists.berlios.de</font>
<p><font size="2">06/13/2008 08:00 AM</font>
<table border="1">
<tr valign="top"><td width="168" bgcolor="#FFFFFF"><div align="center"><font size="2">Please respond to<br>
opensim-dev@lists.berlios.de</font></div></td></tr>
</table>
</ul>
</ul>
</ul>
</ul>
</td><td width="60%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<div align="right"><font size="2">To</font></div></td><td width="100%"><img width="1" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<font size="2">opensim-dev@lists.berlios.de</font></td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<div align="right"><font size="2">cc</font></div></td><td width="100%"><img width="1" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
</td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<div align="right"><font size="2">Subject</font></div></td><td width="100%"><img width="1" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""><br>
<font size="2">[Opensim-dev] standardizing on uuid string formats</font></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="58"><img width="1" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""></td><td width="336"><img width="1" height="1" src="cid:4__=09BBFEF4DFDE7FDE8f9e8a93df938@us.ibm.com" border="0" alt=""></td></tr>
</table>
</td></tr>
</table>
<br>
<tt>We have 3 serialization formats for a UUID<br>
* XXXXXXYYYYYYZZZZZZ....<br>
* XXXXXX-YYYYYY-ZZZZZZ....<br>
* binary packed version (used in the mysql assets table exclusively)<br>
<br>
This is definitely confusing. One of the reasons that we got here is<br>
that there never was really a defined standard, and things grew and<br>
changed over time. One of the reasons that we are still here is that<br>
until recently, doing database migrations between formats would have<br>
been a lot of crazy logic. I'm hoping that the Migration support I just<br>
put in (and switched both SQLite and MySQL over to) should fix part 2.<br>
<br>
So, back to part 1. I think we should declare a standard, and work<br>
towards getting everything in that standard. My suggestion, and<br>
preference here is form 2: XXXXXX-YYYYYY-ZZZZZZ... for the following<br>
reasons.<br>
* It's very user readable, and like the format that people have come to<br>
expect in the client viewer. As people like looking at their data in<br>
both xml and in the database, making it make more sense to them is<br>
probably a good thing<br>
* It's the native string format for LLUUID and GUID (system built in).<br>
Using another format means lots of converting back and forth. <br>
* It also occured to me this morning that the extra string in every <br>
conversion might account for some of our extra overhead.<br>
<br>
All opinions on the table are valid. I firmly believe that anything<br>
that gets our data more self consistant will help with maintainability<br>
in the project. Please throw in your views, and I'll queue this up for<br>
future work.<br>
<br>
-Sean<br>
<br>
-- <br>
__________________________________________________________________<br>
<br>
Sean Dague Mid-Hudson Valley<br>
sean at dague dot net Linux Users Group<br>
</tt><tt><a href="http://dague.net">http://dague.net</a></tt><tt> </tt><tt><a href="http://mhvlug.org">http://mhvlug.org</a></tt><tt><br>
<br>
There is no silver bullet. Plus, werewolves make better neighbors<br>
than zombies, and they tend to keep the vampire population down.<br>
__________________________________________________________________<br>
</tt><i>(See attached file: signature.asc)</i><tt>_______________________________________________<br>
Opensim-dev mailing list<br>
Opensim-dev@lists.berlios.de<br>
</tt><tt><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev">https://lists.berlios.de/mailman/listinfo/opensim-dev</a></tt><tt><br>
</tt><br>
</body></html>