This value depends on the traffic of your site, the more traffic the more seconds to retain the connection, I&#39;d recommend setting a relatively small value like `60` and tuning it accordingly to the usage pattern.

&lt;br/&gt;&lt;br/&gt;

Edit (2018):&lt;br/&gt;&lt;br/&gt;
Like @jcyrss pointed out, this method has its quirks, for future reference I&#39;d recommend handing out pooling to something like pgbouncer instead.

Not as simple as &quot;the more traffic the more seconds to retain the connection&quot;.

It also depend on how you run Django. 

Now, one popular way to launch Django in gunicorn+greenlet(evenlet or gevent). And if you set CONN_MAX_AGE to 60 (even 5 in my case), you may get complain &#39;too many connections&#39; from DB server.


See this for details.

https://github.com/benoitc/gunicorn/issues/996

https://serverfault.com/questions/635100/django-conn-max-age-persists-connections-but-doesnt-reuse-them-with-postgresq 



I am using `IIS 8` on `Windows 8.1`. I have an `XML` file an I need to have it accessed through *(servername)/(path)*

*(path)* is predefined by someone else and does not contain an extension. I tried the simple solution of removing the .xml file the file name, but `IIS returns HTTP Error 404.3 - Not Found`

In the *&quot;Physical Path&quot;* returned with the error is the correct file path, which when I copy-paste to Run opens the correct file.

Please let me know if this is possible.



IIS: How to serve a file without extension?

I am using Django 1.6 with Mysql.

I have these models:

    class Student(models.Model):
         username = models.CharField(max_length=200, unique = True)

    class Score(models.Model)
         student = models.ForeignKey(Student)
         date = models.DateTimeField()
         score = models.IntegerField()

I want to get the latest score record for each student.  
I have tried:

    Score.objects.values(&#39;student&#39;).annotate(latest_date=Max(&#39;date&#39;))

and:

    Score.objects.values(&#39;student__username&#39;).annotate(latest_date=Max(&#39;date&#39;))

as described [Django ORM - Get the latest record for the group][1]
but it did not help.


  [1]: https://stackoverflow.com/questions/17887075/django-orm-get-latest-record-for-group

Django orm get latest for each group

Django 1.6 now supports [`CONN_MAX_AGE` to pool database connections](https://docs.djangoproject.com/en/1.11/ref/settings/#conn-max-age).

By default, the value is 0 (no pooling).  What is a sensible value for this option?

What is a good value for CONN_MAX_AGE in Django?

<p>Django 1.6 now supports <a href="https://docs.djangoproject.com/en/1.11/ref/settings/#conn-max-age" target="_blank" rel="noopener noreferrer"><code>CONN_MAX_AGE</code> to pool database connections</a>.</p>
<p>By default, the value is 0 (no pooling).  What is a sensible value for this option?</p>


I am trying to run statsd/graphite which uses django 1.6.

While accessing graphite URL, I get django module error

&gt;   File &quot;/opt/graphite/webapp/graphite/urls.py&quot;, line 15, in &lt;module&gt;
&gt;      from django.conf.urls.defaults import *
&gt;     ImportError: No module named defaults


However, I do not find **defaults** django package inside `/Library/Python/2.7/site-packages/django/conf/urls/`

Please help fixing this issue.

Django import error - no module named django.conf.urls.defaults

I&#39;m reading up that most people do `from django.conf import settings` but I don&#39;t undertstand the difference to simply doing `import settings` in a django project file. Can anyone explain the difference?

What&#39;s the difference between `from django.conf import settings` and `import settings` in a Django project

Restarting the Django server displays the following error:

    this port is already running....

This problem occurs specifically on Ubuntu and not other operating systems. How can I free up the port to restart the server?


Django Server Error: port is already in use

I am new to Django and pretty new to Ajax. I am working on a project where I need to integrate the two. I believe that I understand the principles behind them both, but have not found a good explanation of the two together. 

Could someone give me a quick explanation of how the codebase must change with the two of them integrating together?

For example, can I still use the `HttpResponse` with Ajax, or do my responses have to change with the use of Ajax? If so, could you please provide an example of how the responses to the requests must change? If it makes any difference, the data I am returning is JSON. 



How do I integrate Ajax with Django applications?

My simple Django app worked fine in debug mode (`manage.py runserver`), and works under WSGI+Apache on my dev box, but when I pushed to EC2 I began receiving intermittent (10-80% of the time) errors of `Bad Request (400)` for any URLs I try to view (whether in my app or in the Django admin.

Where can I find debug information about this? Nothing appears in `/var/log/apache2/error.log`, even with `LogLevel=info`. I have checked versions, logged the Request environment (cf. [ModWSGI Debugging Tips](https://code.google.com/p/modwsgi/wiki/DebuggingTechniques#Displaying_Request_Environment)) and see no major differences.

The one remaining thought I had is, I&#39;m using the mod_wsgi from Ubuntu 12.04 (libapache2-mod-wsgi 3.3-4build1) which was built against Python 2.7.1; I have Python 2.7.3. And Django is 1.6, which is newer than the Ubuntu Precise version. I hesitate to start building packages from source since it&#39;s so hard to clean up and these seem like minor version changes...

**Thank you for your help.**


*(For reference, here are the Apache config and WSGI apps)*

### Apache config (000-default)

    &lt;VirtualHost *:80&gt;
        ServerAdmin webmaster@localhost
        DocumentRoot /var/www
        WSGIScriptAlias /rz /usr/local/share/rz/rz.wsgi
        ...


### rz.WSGI app

    import os
    import sys
    import django.core.handlers.wsgi
    import pprint

    path = &#39;/usr/local/share/rz&#39;
    if path not in sys.path:
    	sys.path.insert(0, path)
    
    os.environ[&#39;DJANGO_SETTINGS_MODULE&#39;] = &#39;rz.settings&#39;
    
    class LoggingMiddleware:
    	def __init__(self, application):
    		self.__application = application
    
    	def __call__(self, environ, start_response):
    		errors = environ[&#39;wsgi.errors&#39;]
    		pprint.pprint((&#39;REQUEST&#39;, environ), stream=errors)
    
    		def _start_response(status, headers, *args):
    			pprint.pprint((&#39;RESPONSE&#39;, status, headers), stream=errors)
    			return start_response(status, headers, *args)
    
    		return self.__application(environ, _start_response)
    
    application = LoggingMiddleware(django.core.handlers.wsgi.WSGIHandler())

Debugging Apache/Django/WSGI Bad Request (400) Error

Every socket of MySQL Database will have defaults connections as 100 but I am looking for any way to increase the number of possible connections &gt; 100 to a socket connection of MySQL Database.


How to increase MySQL connections(max_connections)?

I installed Postgres with this command

    sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev

Using `psql --version` on terminal I get `psql (PostgreSQL) 9.3.4`

then I installed ``pgadmin`` with

    sudo apt-get install pgadmin3

Later I opened the UI and create the server with this information

![enter image description here][1]


but this error appear


![enter image description here][2]

how can I fix it?

  [1]: http://i.stack.imgur.com/89CrA.png
  [2]: http://i.stack.imgur.com/ClRbk.png

How to connect Postgres to localhost server using pgAdmin on Ubuntu?

Is there a command in PostgreSQL to select active connections to a given database?

`psql` states that I can&#39;t drop one of my databases because there are **active connections to it**, so I would like to see what the connections are (and from which machines)

How to list active connections on PostgreSQL?

For the properties:

    Persist Security Info=true

and

    Persist Security Info=false

Can you tell me what is the difference between them, and if I don&#39;t put it in my connection what will happen?

    connect.ConnectionString = &quot;Provider=Microsoft.ACE.OLEDB.12.0;
                                Data Source=C:/Users/Nourah/Downloads 
                                /Phase3/Salary.accdb; 
                                Persist Security Info=False;&quot;;

Persist Security Info Property=true and Persist Security Info Property=false

With the two classes below, I&#39;ve tried connect to a MySQL database. However, I always get this error:

&lt;blockquote&gt;
Wed Dec 09 22:46:52 CET 2015 WARN: Establishing SSL connection without server&#39;s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn&#39;t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to &#39;false&#39;. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
&lt;/blockquote&gt;


This is the test class with the `main` method:

    public class TestDatabase {
    
    	public static void main(String[] args) {
    		Database db = new Database();
    		try {
    			db.connect();
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    		db.close();
    	}
    }

This is the `Database` class:

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    
    public class Database {
    	
    	private Connection con;
    	
    	public void connect() throws Exception{
    		
    		if(con != null) return;
    		
    		try {
    			Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
    		} catch (ClassNotFoundException e) {
    			throw new Exception(&quot;No database&quot;);
    		}
    		
    		String connectionURL = &quot;jdbc:mysql://localhost:3306/Peoples&quot;;
    		
    		con = DriverManager.getConnection(connectionURL, &quot;root&quot;, &quot;milos23&quot;);		
    	}
    	
    	public void close(){
    		if(con != null){
    			try {
    				con.close();
    			} catch (SQLException e) {
    				e.printStackTrace();
    			}
    		}
    	}
    }
	



Warning about SSL connection when connecting to MySQL database

Django 1.6 proposes `@transaction.atomic` as part of the rehaul in the transaction management from 1.5.

I have a function which is called by a Django management command which is in turn called by cron, i.e. no HTTP request triggering transactions in this case. Snippet:

    from django.db import transaction
    
    @transaction.commit_on_success
    def my_function():
        # code here

In the above code block [`commit_on_success`](https://docs.djangoproject.com/en/1.6/topics/db/transactions/#django.db.transaction.commit_on_success) uses a single transaction for all the work done in `my_function`.

Does replacing `@transaction.commit_on_success` with `@transaction.atomic` result in the identical behaviour? `@transaction.atomic` [docs state](https://docs.djangoproject.com/en/3.0/topics/db/transactions/#django.db.transaction.atomic):

&gt; Atomicity is the defining property of database transactions. atomic
&gt; allows us to create a block of code within which the atomicity on the
&gt; database is guaranteed. If the block of code is successfully
&gt; completed, the changes are committed to the database. If there is an
&gt; exception, the changes are rolled back.


I take it that they result in the same behaviour; correct?

Content Type	Original Author	Original Content on Stackoverflow
Question	Brendan Nee	View Question on Stackoverflow
Solution 1 - Django	MGP	View Answer on Stackoverflow
Solution 2 - Django	Jcyrss	View Answer on Stackoverflow

What is a good value for CONN_MAX_AGE in Django?

Django Problem Overview

Django Solutions

Solution 1 - Django

Solution 2 - Django

Django orm get latest for each group

IIS: How to serve a file without extension?

Attributions