Good Idea Charles :D<br><br>for instance, the binary representations of these magnitudes tend to have far fewer digits until they get relatively large, and do specious punctuation. They also tend to be far faster in processing.<br>
<br>However, for whatever reason, the rest of the world seems to have settled on the dash-formatted representation; anytime we touch the rest of the world at the UUID, we will need to transcribe on the fly.<br><br>Cheers<br>
Hiro/daTwitch<br><br><div class="gmail_quote">On Fri, Jun 13, 2008 at 8:55 AM, Charles Krinke <<a href="mailto:cfk@pacbell.net">cfk@pacbell.net</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;">+1 to XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX<br><br>I find myself looking at console logs of all five servers and looking at the mysql and SQLite prompt for issues so the human readable one is my vote.<br>
<br>Perhaps you can give an example in the code of each of the three cases so we can look all think about how to make this least traumatic?<br><font color="#888888"><br>Charles</font><div><div></div><div class="Wj3C7c"><br>
<br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Sean Dague <<a href="mailto:sean@dague.net" target="_blank">sean@dague.net</a>><br>To: <a href="mailto:opensim-dev@lists.berlios.de" target="_blank">opensim-dev@lists.berlios.de</a><br>
Sent: Friday, June 13, 2008 6:00:52 AM<br>Subject: [Opensim-dev] standardizing on uuid string formats<br><br>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><a href="http://dague.net" target="_blank">http://dague.net</a> <a href="http://mhvlug.org" target="_blank">http://mhvlug.org</a><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></div></div></div></div></div></div><br>_______________________________________________<br>
Opensim-dev mailing list<br>
<a href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>===================================<br>The wind<br>scours the earth for prayers<br>The night obscures them