Investigate using an ORM

[mwinokan]

• SQLAlchemy most popular
• Django ORM best featureset for migrations and web app, can it be used without Django itself?
• Pony easy to grasp but quite opinionated

comparison blog post

Django ORM without Django

example setup
Models docs

import django
from django.conf import settings

settings.configure(
    DATABASES={
        'default': {
            'ENGINE': '<your_engine>',
            'NAME': '<database_name>',
            'HOST': '<hostname_or_ip>',
            'PORT': '<port>',
            'USER': '<user>',
            'PASSWORD': '<super_secret_password>',   
        }
    },
    INSTALLED_APPS=[
        '<your_app>',
    ]
)
django.setup()