Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>Please note this is outdated answer. Recent ways of doing that is: websockets, server-send events. Nice example of that is Firebase. You can find simple code example in: <a href="https://github.com/laithshadeed/wsk-feedback" rel="nofollow noreferrer">https://github.com/laithshadeed/wsk-feedback</a>. In this example you will see that updating firebase will send event to the browser via websocket, then the UI will update. </p> </blockquote> <p>This is called Comet/Reverse Ajax/HTTP server push <a href="http://en.wikipedia.org/wiki/Comet_(programming)" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/Comet_(programming)</a>. They are many techniques for doing this as well as many existing frameworks to do it for you.</p> <p>There are many answers in SO about Comet <a href="https://stackoverflow.com/search?q=comet">https://stackoverflow.com/search?q=comet</a></p> <p>Simple implementation would be javascript setTimeout and setInterval to check server status, with trigger/stored procedure on mysql.</p> <p>For depth dive into Comet. There are two cool books about this:</p> <p><a href="http://rads.stackoverflow.com/amzn/click/1590599985" rel="nofollow noreferrer">Comet and Reverse Ajax 2008 By Dave Crane</a></p> <p><img src="https://i.stack.imgur.com/UpmLF.jpg" alt="Comet and Reverse Ajax Cover Image"></p> <p><a href="http://rads.stackoverflow.com/amzn/click/0596806159" rel="nofollow noreferrer">Chapter 4 (River of Content) - Building the Realtime User Experience 2010 By Ted Roden</a></p> <p><img src="https://i.stack.imgur.com/RE0cf.jpg" alt="Building the Realtime User Experience Cover image"></p> <blockquote> <p><strong>Update</strong>: You may look to the newer techniques in HTML5 like <a href="http://www.html5rocks.com/en/tutorials/eventsource/basics/" rel="nofollow noreferrer">Websockets and Server-sent</a> Events, although IE does not support them well, at the moment Server-sent events is <a href="http://caniuse.com/#feat=eventsource" rel="nofollow noreferrer">not supported in IE</a> and Web Sockets only <a href="http://caniuse.com/#feat=websockets" rel="nofollow noreferrer">supported in IE10</a></p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. PORefresh content automatically if the database changes
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USLaith Shadeed
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORefresh content automatically if the database changes
      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. COI think I'm going for setTimeout and setInterval. Thanks a lot :)
      singulars
      1. PO
      1. USH Bellamy
 

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