Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Short answer: Yes, you can achieve that with web services.</p> <p>Web services are only a facade to your system - they can expose (or not) any behavior you want to. If you have security concerns, you'll have to approach them anyway in both methods.</p> <p>Personally, I'd use a RESTful approach as its usually simpler to implement and use. From Wikipedia:</p> <blockquote> <p>A RESTful web service (also called a RESTful web API) is a simple web service implemented using HTTP and the principles of REST. It is a collection of resources, with four defined aspects:</p> <ul> <li>the base URI for the web service, such as <a href="http://example.com/resources/" rel="nofollow">http://example.com/resources/</a></li> <li>the Internet media type of the data supported by the web service. This is often JSON, >XML or YAML but can be any other valid Internet media type.</li> <li>the set of operations supported by the web service using HTTP methods (e.g., GET, >PUT, POST, or DELETE).</li> <li>The API must be hypertext driven.[11]</li> </ul> </blockquote> <p>So you'd have a URL, say <code>http://mywebsite.com/users</code> and perform HTTP actions (<code>GET</code>, <code>PUT</code>, etc) on them. A <code>GET</code> request on <code>/users/17</code> could return user 17, for instance, while a <code>POST</code> request on it would update said user.</p> <p>As for login, when your users "log in" you would call a GET method that sends username:password (probably encrypted) and returns a login token. Every time the user executes an action, you would send said token with the request as an additional parameter.</p>
    singulars
    1. This table or related slice is empty.
    1. POMaking a web service, which approach?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMarcelo
    1. USMarcelo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COOkey, so users will able to log in thorugh a REST webservice too? Then after they are authenticated and authorized I return a boolean or something? Do they need to have internet connectivity as long as they are connected?
      singulars
      1. PO
      1. USLuckyLuke
    2. COPjotr, in a REST webservice you would not have a 'proper' login - will update the answer.
      singulars
      1. PO
      1. USMarcelo
    3. COOkey, so do I need to change the code and do something with token in every method then? Or are there frameworks etc I can use?
      singulars
      1. PO
      1. USLuckyLuke
 

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