Flask with Django ORM

app.py

'''
Run the following commands (bc. gists don't allow directories)

pip install flask django dj-database-url psycopg2

mkdir -p app/migrations
touch app/__init__.py app/migrations/__init__.py
mv models.py app/
python manage.py makemigrations
python manage.py migrate
DJANGO_SETTINGS_MODULE=settings python app.py

visit http://localhost:5000
See https://docs.djangoproject.com/en/1.11/topics/settings/#either-configure-or-django-settings-module-is-required for documentation
'''

from flask import Flask
from django.apps import apps
from django.conf import settings

apps.populate(settings.INSTALLED_APPS)

from app.models import Hit

app = Flask(__name__)

@app.route("/")
def index():
    return str(Hit.objects.count())

if __name__=='__main__':
    app.run(debug=True)

manage.py

#!/usr/bin/env python
import os, sys

if __name__ == "__main__":
    os.environ.setdefault("DJANGO_SETTINGS_MODULE", "settings")
    from django.core.management import execute_from_command_line
    execute_from_command_line(sys.argv)

models.py

from django.db import models
from django.contrib.postgres.fields import JSONField

class BaseModel(models.Model):
    created_at = models.DateTimeField(auto_now_add=True, null=True)
    updated_at = models.DateTimeField(auto_now=True, null=True)

    def attributes(self):
        return self.__dict__

    class Meta:
        abstract = True

class Hit(BaseModel):
    data = JSONField(null=True)

settings.py

import dj_database_url

DATABASES = { 'default': dj_database_url.config(default='postgres://localhost/py_example_app') }

INSTALLED_APPS = ( 'app', )

SECRET_KEY = 'REPLACE_ME'

smart guys

I have done something similar, now facing issues in threads(each flask thread spawning one DB connection, then not closing it after transaction).Running out of Postgres threads.
Flask
Django ORM
Waitress

I have made some modification for the project structure.
See from my fork

@ashishk1996

I also noticed the same behaviour in a slight variation of this. I solved by adding an after_request decorator to the Flask app:

from django.db import close_old_connections

@app.after_request
def after_request_func(response):
    close_old_connections()
    return response

As a sidenote, you can check the current number of DB connections (postgres) with:

SELECT count(*) FROM pg_stat_activity;