Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Since I was looking for some more in-depth answers, I decided to research the issue myself in depth. Please let me know if I've misunderstood anything.</p> <p>Some general recommendation are to use a separate webserver for handling media. By separate, I mean a webserver which is not running Django. This server can be for instance:</p> <ul> <li>Lighttpd (Lighty)</li> <li>Nginx (EngineX)</li> <li>Or some other light-weight server</li> </ul> <p>Then, for Django, you can go down different paths. You can either:</p> <ul> <li><p>Serve Django via <strong>Apache</strong> and:</p> <ul> <li><p><strong>mod_python</strong></p> <p>This is the stable and recommended/well documented way. Cons: uses a lot of memory.</p></li> <li><p><strong>mod_wsgi</strong></p> <p>From what I understand, mod_wsgi is a newer alternative. It appears to be faster and easier on resources.</p></li> <li><p><strong>mod_fastcgi</strong></p> <p>When using FastCGI you are delegating the serving of Django to another process. Since mod_python includes a python interpreter in every request it uses a lot of memory. This is a way to bypass that problem. Also there is some security concerns.</p> <p>What you do is that you start your Django FastCGI server in a separate process and then configures apache via rewrites to call this process when needed.</p></li> </ul></li> </ul> <p>Or you can:</p> <ul> <li><p>Serve Django <strong>without using Apache</strong> but with another server that supports FastCGI natively:</p> <p>(The documentation mentions that you can do this if you don't have any Apache specific needs. I guess the reason must be to save memory.)</p> <ul> <li><strong>Lighttpd</strong></li> </ul> <p>This is the server that runs Youtube. It seems fast and easy to use, however i've seen reports on memoryleaks.</p> <ul> <li><strong>nginx</strong></li> </ul> <p>I've seen benchmarks claiming that this server is even faster than lighttpd. It's mostly documented in Russian though.</p></li> </ul> <p>Another thing, due to limitations in Python your server should be running in forked mode, not threaded.</p> <p>So this is my current research, but I want more opinions and experiences.</p>
    singulars
    1. This table or related slice is empty.
    1. POCleanest & Fastest server setup for Django
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPeaches491
    1. USjamting
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCleanest & Fastest server setup for Django
      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. COThe mod_python module need not consume lots more memory. The view that it does has grown to be a bit of an urban myth, when reality is that the memory problems people were having were caused by how mod_python/Python had been installed and how Apache had been configured. The first issue was that in the past Python often wasn't installed with a shared library. This mean mod_python had to link it statically, causing local memory to be used due to address relocations. The other problem is people using prefork, which is better for PHP but sucks for Python.
      singulars
      1. PO
      1. USGraham Dumpleton
 

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