<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Bitstream Vera Sans";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.ecapple-style-span
{mso-style-name:ec_apple-style-span;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Just did a survey of the mysql database schemas…<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Most of the databases use the string form with dashes.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The asset database uses a binary representation for the “id”
field.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The land, prims, primshapes, and terrain databases all use
string with no dashes for UUID fields.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I personally prefer the dashed form as well (easy to read), and
I can’t believe the performance or space requirements are sufficiently
important (relatively) to suggest one format over another (feel free to
convince me that I’m wrong though). Consistency would also make it easier
to manage the databases (eg to write scripts that handle garbage collection). <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>--mic<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
opensim-dev-bounces@lists.berlios.de [mailto:opensim-dev-bounces@lists.berlios.de]
<b>On Behalf Of </b>Stefan Andersson<br>
<b>Sent:</b> Wednesday, January 16, 2008 9:31 AM<br>
<b>To:</b> opensim-dev@lists.berlios.de; Fox Diller<br>
<b>Cc:</b> libsl dev<br>
<b>Subject:</b> Re: [Opensim-dev] [libsl-dev] UUID format: dashed here to stay?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>I would definitively suggest we use the
default Guid.ToString() ie, with dashes.<br>
<br>
/Stefan<br>
<br>
<br>
<br>
<o:p></o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
<hr size=2 width="100%" align=center id="EC_stopSpelling">
</span></div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Date:
Wed, 16 Jan 2008 18:04:24 +0100<br>
From: hud@zurich.ibm.com<br>
To: fox@crystalstudio.ca<br>
CC: opensim-dev@lists.berlios.de; libsl-dev@openmv.org<br>
Subject: Re: [Opensim-dev] [libsl-dev] UUID format: dashed here to stay?<br>
<br>
Fox Diller wrote: <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
<div>
<div>
<div>
<p class=MsoNormal><span class=ecapple-style-span><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:black'>Oh, I'm sorry. Though, wouldn't
this be a perfect place for a ToString() function overload, something
like </span></span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=ecapple-style-span><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:black'>LLUUID.ToString(bool dashed) ?</span></span><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p>
</div>
</div>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>i
guess the question is just: is this going to be the format for the future and
does it justify updating existing DBs or is this going to change again...<br>
<br>
cheers,<br>
dirk<br>
<br>
<br>
<o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=ecapple-style-span><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:black'>Thoughts?</span></span><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span class=ecapple-style-span><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>.fox</span></span><span style='font-size:
10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'>
<div>
<div>
<div>
<div>
<div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>On
16-Jan-08, at 3:23 AM, dirk husemann wrote:<o:p></o:p></span></p>
</div>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Fox
Diller wrote: <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>I
would've thought that keeping them without dashes inside of libSL would be more
efficient? I mean, the dashes are just a visual cue, aren't they? Something
only to display formatted on the gui/console side of your application? <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>sorry,
i should have been more specific: the ToString() format changed from non-dashed
to dashed. <br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'><br>
.fox<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>On
Jan 16, 2008 2:21 AM, dirk husemann <<a href="mailto:hud@zurich.ibm.com">hud@zurich.ibm.com</a>>
wrote:<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Bitstream Vera Sans","serif"'>this
popped up on the opensim-dev list: the UUID format change a while ago to the
dashed format, is this going to stay? </span><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p>
<pre>-- <o:p></o:p></pre><pre>dr dirk husemann, pervasive computing, ibm zurich research lab<o:p></o:p></pre><pre>--- <a
href="mailto:hud@zurich.ibm.com">hud@zurich.ibm.com</a> --- +41 44 724 8573 --- SL: dr scofield<o:p></o:p></pre><pre> <o:p></o:p></pre></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'><br>
_______________________________________________<br>
libsl-dev mailing list<br>
<a href="mailto:libsl-dev@openmv.org">libsl-dev@openmv.org</a><br>
<a href="http://openmv.org/cgi-bin/mailman/listinfo/libsl-dev" target="_blank">http://openmv.org/cgi-bin/mailman/listinfo/libsl-dev</a><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><br>
<br clear=all>
<br>
-- <br>
-------------------------------------------<br>
Fox Diller/Kyle Polulak<br>
CEO 0775222 B.C. LTD. DBA<br>
Magrathean Technologies <br>
Surrey, British Columbia<br>
Canada<br>
Email: <a href="mailto:fox@magrathean.ca">fox@magrathean.ca</a><br>
Phone: +1.604.817.6942<br>
<a href="http://magrathean.ca/" target="_blank">http://magrathean.ca</a><br>
------------------------------------------- <o:p></o:p></span></p>
<pre style='text-align:center'>
<hr size=4 width="90%" align=center>
</pre><pre>_______________________________________________<o:p></o:p></pre><pre>libsl-dev mailing list<o:p></o:p></pre><pre><a
href="mailto:libsl-dev@openmv.org">libsl-dev@openmv.org</a><o:p></o:p></pre><pre><a
href="http://openmv.org/cgi-bin/mailman/listinfo/libsl-dev" target="_blank">http://openmv.org/cgi-bin/mailman/listinfo/libsl-dev</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
<pre>-- <o:p></o:p></pre><pre>dr dirk husemann, pervasive computing, ibm zurich research lab<o:p></o:p></pre><pre>--- <a
href="mailto:hud@zurich.ibm.com">hud@zurich.ibm.com</a> --- +41 44 724 8573 --- SL: dr scofield<o:p></o:p></pre><pre> <o:p></o:p></pre></div>
</blockquote>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
<pre style='text-align:center'>
<hr size=4 width="90%" align=center>
</pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>libsl-dev mailing list<o:p></o:p></pre><pre><a
href="mailto:libsl-dev@openmv.org">libsl-dev@openmv.org</a><o:p></o:p></pre><pre><a
href="http://openmv.org/cgi-bin/mailman/listinfo/libsl-dev" target="_blank">http://openmv.org/cgi-bin/mailman/listinfo/libsl-dev</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p>
<pre>-- <o:p></o:p></pre><pre>dr dirk husemann, pervasive computing, ibm zurich research lab<o:p></o:p></pre><pre>--- <a
href="mailto:hud@zurich.ibm.com">hud@zurich.ibm.com</a> --- +41 44 724 8573 --- SL: dr scofield<o:p></o:p></pre></div>
</body>
</html>