Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p><strong>JSON (JavaScript Object Notation) is a lightweight data-interchange format</strong>. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999. JSON is a text format that is completely language independent but uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python, and many others. These properties make JSON an ideal data-interchange language.</p> </blockquote> <p>Ref.: <a href="http://www.json.org/" rel="nofollow noreferrer">json.org</a></p> <p>An <strong>object</strong> is an unordered set of name/value pairs. An object begins with { (left brace) and ends with } (right brace). Each name is followed by : (colon) and the name/value pairs are separated by , (comma).</p> <p><a href="http://www.json.org/object.gif" rel="nofollow noreferrer">alt text http://www.json.org/object.gif</a></p> <p>An <strong>array</strong> is an ordered collection of values. An array begins with [ (left bracket) and ends with ] (right bracket). Values are separated by , (comma).</p> <p><a href="http://www.json.org/array.gif" rel="nofollow noreferrer">alt text http://www.json.org/array.gif</a></p> <p>A <strong>value</strong> can be a string in double quotes, or a number, or true or false or null, or an object or an array. These structures can be nested.</p> <p><a href="http://www.json.org/value.gif" rel="nofollow noreferrer">alt text http://www.json.org/value.gif</a></p> <p>A <strong>string</strong> is a collection of zero or more Unicode characters, wrapped in double quotes, using backslash escapes. A character is represented as a single character string. A string is very much like a C or Java string.</p> <p><a href="http://www.json.org/string.gif" rel="nofollow noreferrer">alt text http://www.json.org/string.gif</a></p> <p>A <strong>number</strong> is very much like a C or Java number, except that the octal and hexadecimal formats are not used. <a href="http://www.json.org/number.gif" rel="nofollow noreferrer">alt text http://www.json.org/number.gif</a></p> <p>Here is an example:</p> <pre><code>{ "menu": { "id": "file", "value": "File", "popup": { "menuitem": [{ "onclick": "CreateNewDoc()" }, { "value": "Open", "onclick": "OpenDoc()" }, { "value": "Close", "onclick": "CloseDoc()" }] } } } </code></pre> <p>And in XML the same thing would have been:</p> <pre><code>&lt;menu id="file" value="File"&gt; &lt;popup&gt; &lt;menuitem value="New" onclick="CreateNewDoc()" /&gt; &lt;menuitem value="Open" onclick="OpenDoc()" /&gt; &lt;menuitem value="Close" onclick="CloseDoc()" /&gt; &lt;/popup&gt; &lt;/menu&gt; </code></pre> <p>Ref.: <a href="http://www.json.org/" rel="nofollow noreferrer">json.org</a></p> <p>Hope you now get an idea of what is JSON.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat is JSON?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMr. Polywhirl
    1. USPatrick Desjardins
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is JSON?
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COAnyway, I do not get the point to do a war about it, I'll find the exact reference of the other website I found it once I finish the rush I have to complete at work. brb later... I let you edit the post if you feel that it's needed.
      singulars
      1. PO
      1. USPatrick Desjardins
    2. COThank you for adding the ref lines.
      singulars
      1. PO
      1. USMichael Haren
 

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