Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>REST is (in a nutshell) a paradigm that resources should be accessible through a URI and that HTTP-like verbs can be used to manipulate them (that is to say, HTTP was designed with REST principles in mind). This is, say, in contrast to having one URI for your app and POSTing a data payload to tell the server what you want to achieve.</p> <p>With a rough analogy, a filesystem is usually RESTful. Different resources live at different addresses (directories) that are easy to access and write to, despite not being necessarily stored on disk in a fashion that reflects the path. Alternatively, most databases are <em>not</em> RESTful - you connect to the database and access the data through a declarative API, rather than finding the data by a location.</p> <p>As far as <em>what</em> the resource is - HTML, JSON, a video of a waterskiing squirrel - that is a different level of abstraction than adhering to RESTful principles.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs a REST request normally JSON output or something else?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMatt
    1. USMatt
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs a REST request normally JSON output or something else?
      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. VTAcceptedByOriginator
    1. COIt seems like a very, very loose standard if you we want to call it that. I guess I am trying to ask, why not just call it a HTTP request. Are well named URL's the basis for a particular architecture. When I look at the twitter API "web-service", it seems like just that, a HTTP GET request, JSON output with a well-named URI path? I guess I am being too pedantic about this.
      singulars
      1. PO
      1. USBerlin Brown
    2. COIt is indeed loose: more like a best practice than a strict set of rules. A key thing to understand is that the statement "a HTTP request" sort of encodes within it the RESTful principles that went into designing HTTP. It's such a common practice to address resources this way that it seems obvious to us now - but it wasn't always so. Many different data transfer mechanisms on the internet - like streaming video - are not RESTful. Can you imagine the world without URLs, where your browser has to understand a different data format for every server? Totally gross.
      singulars
      1. PO
      1. USMatt
    3. CO@BerlinBrown - actually, your not being pedantic enough! REST is based on HTTP, but the core of the specification has to do with *alot* more than the communication transport. I recommend reading [Fielding's original dissertation](http://www.ics.uci.edu/~fielding/pubs/dissertation/rest_arch_style.htm) on the subject, as a start. It describes key principles of uniform interfaces, representational state, statelessness, and other key RESTful principles.
      singulars
      1. PO
      1. USPerception
 

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