Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I wish I had not set a bounty for this, because I stumbled upon the answer a few days later and it is really simple.</p> <p>Here is URL to call if you want a definition to <strong>love</strong>:</p> <blockquote> <p><a href="http://www.google.com/dictionary/json?callback=a&amp;sl=en&amp;tl=en&amp;q=love">http://www.google.com/dictionary/json?callback=a&amp;sl=en&amp;tl=en&amp;q=love</a></p> </blockquote> <p>You will get a response stream containing JSONP, with the following contents ("prettified" for learning purposes, API returns all in one line):</p> <pre><code>a( { "query":"love", "sourceLanguage":"en", "targetLanguage":"en", "primaries":[ { "type":"headword", "terms":[ { "type":"text", "text":"love", "language":"en", "labels":[ { "text":"Noun", "title":"Part-of-speech" } ] }, { "type":"phonetic", "text":"/ləv/", "language":"und" }, { "type":"sound", "text":"http://www.gstatic.com/dictionary/static/sounds/de/0/love.mp3", "language":"und" } ], "entries":[ { "type":"related", "terms":[ { "type":"text", "text":"loves", "language":"und", "labels":[ { "text":"plural" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"An intense feeling of deep affection", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"babies fill parents with intense feelings of \x3cem\x3elove\x3c/em\x3e", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"their \x3cb\x3e\x3cem\x3elove\x3c/em\x3e for\x3c/b\x3e their country", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"A deep romantic or sexual attachment to someone", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"it was \x3cem\x3elove\x3c/em\x3e at first sight", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"they were both \x3cb\x3ein \x3cem\x3elove\x3c/em\x3e with\x3c/b\x3e her", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"we were slowly \x3cb\x3efalling in \x3cem\x3elove\x3c/em\x3e\x3c/b\x3e", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"A personified figure of \x3cem\x3elove\x3c/em\x3e, often represented as Cupid", "language":"en" } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"A great interest and pleasure in something", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"his \x3cb\x3e\x3cem\x3elove\x3c/em\x3e for\x3c/b\x3e football", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"we share a \x3cb\x3e\x3cem\x3elove\x3c/em\x3e of\x3c/b\x3e music", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"Affectionate greetings conveyed to someone on one\x27s behalf", "language":"en" } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"A formula for ending an affectionate letter", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"take care, lots of \x3cem\x3elove\x3c/em\x3e, Judy", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"A person or thing that one \x3cem\x3eloves\x3c/em\x3e", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"she was \x3cb\x3ethe \x3cem\x3elove\x3c/em\x3e of his life\x3c/b\x3e", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"their two great \x3cem\x3eloves\x3c/em\x3e are tobacco and whiskey", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"A friendly form of address", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"it\x27s all right, \x3cem\x3elove\x3c/em\x3e", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"Used to express affectionate approval for someone", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"don\x27t fret, there\x27s a \x3cem\x3elove\x3c/em\x3e", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"(in tennis, squash, and some other sports) A score of zero; nil", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"\x3cem\x3elove\x3c/em\x3e fifteen", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"he was down two sets to \x3cem\x3elove\x3c/em\x3e", "language":"en" } ] } ] } ] }, { "type":"headword", "terms":[ { "type":"text", "text":"love", "language":"en", "labels":[ { "text":"Verb", "title":"Part-of-speech" } ] }, { "type":"phonetic", "text":"/ləv/", "language":"und" }, { "type":"sound", "text":"http://www.gstatic.com/dictionary/static/sounds/de/0/love.mp3", "language":"und" } ], "entries":[ { "type":"related", "terms":[ { "type":"text", "text":"loved", "language":"und", "labels":[ { "text":"past participle" } ] }, { "type":"text", "text":"loves", "language":"und", "labels":[ { "text":"3rd person singular present" } ] }, { "type":"text", "text":"loving", "language":"und", "labels":[ { "text":"present participle" } ] }, { "type":"text", "text":"loved", "language":"und", "labels":[ { "text":"past tense" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"Feel a deep romantic or sexual attachment to (someone)", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"do you \x3cem\x3elove\x3c/em\x3e me?", "language":"en" } ] } ] }, { "type":"meaning", "terms":[ { "type":"text", "text":"Like very much; find pleasure in", "language":"en" } ], "entries":[ { "type":"example", "terms":[ { "type":"text", "text":"I\x27d \x3cem\x3elove\x3c/em\x3e a cup of tea, thanks", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"I just \x3cem\x3elove\x3c/em\x3e dancing", "language":"en" } ] }, { "type":"example", "terms":[ { "type":"text", "text":"a fun-\x3cem\x3eloving\x3c/em\x3e girl", "language":"en" } ] } ] } ] } ] } ,200,null) </code></pre> <p>Google Dictionary API returns in the form of a callback function (JSONP). Before you can process the JSON within the function call, you have to strip out the callback function data. </p> <p>That means removing everything before the first <code>{</code> and everything after the last <code>}</code>. </p> <p>After this you are done! That's all information you need and it's basically the same (actually a little more!) information when you search Google for <code>define love</code>.</p>
    singulars
    1. This table or related slice is empty.
    1. POGoogle's "define: " through an API?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAdrian Carneiro
    1. USAdrian Carneiro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGoogle's "define: " through an API?
      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. VTUpMod
    1. COFrom the JSON response above, what does **\x3cb\x3e\x3cem\x3elove\x3c/em\x3e** means?
      singulars
      1. PO
      1. USabhilashca
    2. COSame Question, Please Define \x3cb\x3e\x3cem\x3elove\x3c/em\x3e? this is unwanted string and I want to remove all this type of codes/string. Is there any list avilable of this type of codes so we can erase all of them from our output. Thanks
      singulars
      1. PO
      1. USMuhammad Saqib
    3. COThanks for this! I was considering paying the $100 a month that the Oxford English Dictionary charge for their API! And WordNik's API is creaky.
      singulars
      1. PO
      1. USLee Probert
 

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