Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There have been a couple attempts at this. The question is: do you want actual GUIDs, or just random numbers that <em>look</em> like GUIDs? It's easy enough to generate random numbers.</p> <pre><code>function guid() { function s4() { return Math.floor((1 + Math.random()) * 0x10000) .toString(16) .substring(1); } return s4() + s4() + '-' + s4() + '-' + s4() + '-' + s4() + '-' + s4() + s4() + s4(); } </code></pre> <p>However, note that such values <strong>are not genuine GUIDs</strong>.</p> <p><strong>Note</strong>: the provided code snippet does not follow RFC4122 which requires that the version (<code>4</code>) has to be integrated into the generated output string. <strong>Do not use this answer</strong> if you need compliant GUIDs.</p> <p>Use:</p> <pre><code>var uuid = guid(); </code></pre> <h1>Demo:</h1> <p><div class="snippet" data-lang="js" data-hide="true" data-console="false" data-babel="false"> <div class="snippet-code snippet-currently-hidden"> <pre class="snippet-code-js lang-js prettyprint-override"><code>function guid() { return s4() + s4() + '-' + s4() + '-' + s4() + '-' + s4() + '-' + s4() + s4() + s4(); } function s4() { return Math.floor((1 + Math.random()) * 0x10000) .toString(16) .substring(1); } document.getElementById('jsGenId').addEventListener('click', function() { document.getElementById('jsIdResult').value = guid(); })</code></pre> <pre class="snippet-code-css lang-css prettyprint-override"><code>input { font-family: monospace; }</code></pre> <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;button id="jsGenId" type="button"&gt;Generate GUID&lt;/button&gt; &lt;br&gt; &lt;input id="jsIdResult" type="text" placeholder="Results will be placed here..." readonly size="40"/&gt;</code></pre> </div> </div> </p>
    singulars
    1. This table or related slice is empty.
    1. POCreate GUID / UUID in JavaScript?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRobert Harvey
    1. USJohn Millikin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCreate GUID / UUID in JavaScript?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COActually, the RFC allows for UUIDs that are created from random numbers. You just have to twiddle a couple of bits to identify it as such. See section 4.4. Algorithms for Creating a UUID from Truly Random or Pseudo-Random Numbers: http://www.rfc-archive.org/getrfc.php?rfc=4122
      singulars
      1. PO
      1. USJason DeFontes
    2. COEssentially, this is the solution I use - the purpose for which I use it is simple enough that it's sufficient for my needs, though I could see it causing problems for people that have more technical demands. I suppose someone could hit the server for a GUID, depending on the specific need...
      singulars
      1. PO
      1. USJason Bunting
    3. COCould someone explain this code to me? It looks like the S4 function tries to get a random hex number between 0x10000 and 0x20000, then outputs the last 4 digits. But why the bitwise or with 0? Shouldn't that be a noop? Also, is the 0x10000 to 0x20000 just a hack to avoid having to deal with leading 0's?
      singulars
      1. PO
      1. USCory
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload