Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm just tell why you need to use WSGI-like servers :) but if you feel comfortable with using fcgi - just use it</p> <p>Short answer: WSGI (as protocol) is cool because <a href="http://www.python.org/dev/peps/pep-0333/" rel="nofollow noreferrer">its native</a></p> <p>Or if "You need to go deeper"(c)</p> <p>Next question "FastCGI vs WSGI-like servers?" </p> <p>Some answers here:</p> <ul> <li><a href="https://stackoverflow.com/questions/3937224/differences-and-uses-between-wsgi-cgi-fastcgi-and-mod-python-in-regards-to-py">Differences and uses between WSGI, CGI, FastCGI, and mod_python in regards to Python?</a></li> <li><a href="https://stackoverflow.com/questions/257481/whats-the-difference-between-scgi-and-wsgi">What&#39;s the difference between scgi and wsgi?</a></li> <li><a href="https://stackoverflow.com/questions/1747266/is-there-a-speed-difference-between-wsgi-and-fcgi">Is there a speed difference between WSGI and FCGI?</a></li> <li><a href="https://stackoverflow.com/questions/219110/how-python-web-frameworks-wsgi-and-cgi-fit-together">How Python web frameworks, WSGI and CGI fit together</a></li> </ul> <p>About gunicorn, uWSGI and cherokee, nginx. Dont mix them!</p> <p>nginx is web-server which can handle http requests and can send it to WSGI backend. ( But first of all it extremly fast for static content handling. ) And WSGI backend handle you django application.</p> <p>About cherokee, I think it handle the same tasks as nginx but I'm not work with it.</p> <p>And gunicorn, uWSGI are WSGI backend which run threads with django app and do <a href="http://projects.unbit.it/uwsgi/#CurrentCoreFeatures" rel="nofollow noreferrer">many other tasks</a></p> <p>And hmmm, <a href="http://unicorn.bogomips.org/PHILOSOPHY.html" rel="nofollow noreferrer">gunicorn say</a> that </p> <blockquote> <p>Being a server that only runs on Unix-like platforms, unicorn is strongly tied to the Unix philosophy of doing one thing and (hopefully) doing it well. Despite using HTTP, unicorn is strictly a backend application server for running Rack-based <strong>Ruby applications</strong>.</p> </blockquote> <p>I practice for my django apps nginx (latest stable from nginx.org repos)+uWSGI (from Debian stables) - works perfectly :)</p> <hr> <p>edited 18.05.2012</p> <p>Link to 2010 topic with comparing <a href="http://www.peterbe.com/plog/fcgi-vs-gunicorn-vs-uwsgi/" rel="nofollow noreferrer">fcgi gunicorn uWSGI</a></p> <blockquote> <p>fcgi (threaded) 640 r/s</p> <p>fcgi (prefork 4 processors) 240 r/s (*)</p> <p>gunicorn (2 workers) 1100 r/s</p> <p>gunicorn (5 workers) 1300 r/s</p> <p>gunicorn (10 workers) 1200 r/s (?!?)</p> <p>uwsgi (2 workers) 1800 r/s</p> <p>uwsgi (5 workers) 2100 r/s</p> <p>uwsgi (10 workers) 2300 r/s</p> <p>(* this made my computer exceptionally sluggish as CPU when through the roof)</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POWhat is the disadvantage of using Django's fastcgi server
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USnk9
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is the disadvantage of using Django's fastcgi server
      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. CO"FastCGI vs. WSGI" is the wrong question. FastCGI is a network protocol and WSGI is a Python calling convention. [flup](http://trac.saddi.com/flup) has a FastCGI-to-WSGI gateway. Django’s `runfcgi` command is actually based on flup, and thus uses WSGI. A better question is flup vs. uwsgi or flup vs. gunicorn.
      singulars
      1. PO
      1. USSimon Sapin
    2. COYou are right about "FastCGI vs. WSGI". Change in topic to WSGI-like. And I think battle `flup vs. uwsgi vs. gunicorn` win uWSGI. I'll try to provide some proofs soon.
      singulars
      1. PO
      1. USnk9
    3. COWell, who "wins" depends on what’s your criteria. I’m hosting a dozen sites with low traffic, so ease of maintenance and memory usage are more important *for me* than raw performance (which is dominated by database queries anyway.) uwsgi is not packaged in debian squeeze (the current stable), while flup and gunicorn are.
      singulars
      1. PO
      1. USSimon Sapin
 

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