Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First of all, I'm not async expert at all, I just investigated the topic once. IMHO if you're using XAMPP then you're loosing the posibility of doing long polling because Apache uses thread/processes (depending on configuration) for each request.</p> <p>What you need, is non-blocking web server, like <a href="http://www.tornadoweb.org/" rel="noreferrer">Tornado</a>, that allows splitting requests into two parts, of which the second one is fired on some event, but meanwhile server can accept subsequent inbound requests.</p> <p>Example from <a href="http://www.tornadoweb.org/documentation" rel="noreferrer">Tornado documentation</a> /<a href="http://creativecommons.org/licenses/by/3.0/" rel="noreferrer">license</a>/:</p> <pre><code>class MainHandler(tornado.web.RequestHandler): @tornado.web.asynchronous def get(self): http = tornado.httpclient.AsyncHTTPClient() http.fetch("http://friendfeed-api.com/v2/feed/bret", callback=self.async_callback(self.on_response)) def on_response(self, response): if response.error: raise tornado.web.HTTPError(500) json = tornado.escape.json_decode(response.body) self.write("Fetched " + str(len(json["entries"])) + " entries " "from the FriendFeed API") self.finish() </code></pre> <p>-- as far as I know this is not possible under Apache - in which fetch is regular part of request handler, which of course block until it's complete - so what you end with is frozen thread or process.</p> <p>Another famous library for doing non-blocking services in Python is <a href="http://twistedmatrix.com/trac/" rel="noreferrer">Twisted</a>, but I don't know much about it, only that it also is able to help you in handling a lot of connections with only one thread/process.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to implement Comet server side with Python?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTomasz Zielinski
    1. USTomasz Zielinski
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to implement Comet server side with Python?
      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. COThanks for your response. Just want to confirm. Is it true that Apache stick one thread/process for each HTTP request?
      singulars
      1. PO
      1. USMorgan Cheng
    2. COYes, as far as I know (long time mod_wsgi + Django user) that's correct.
      singulars
      1. PO
      1. USTomasz Zielinski
 

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