Django-like abstract database API for non-Django projects

Question

I love the abstract database API that comes with Django, I was wondering if I could use this (or something similar) to model, access, and manage my (postgres) database for my non-Django Python projects.

Answer 1

What you're looking for is an object-relational mapper (ORM). Django has its own, built-in.

To use Django's ORM by itself:

• Using the Django ORM as a standalone component
• Use Django ORM as standalone
• Using settings without setting DJANGO_SETTINGS_MODULE

If you want to use something else:

• What are some good Python ORM solutions?

Answer 2

Popular stand-alone ORMs for Python:

• SQLAlchemy
• SQLObject
• Storm

They all support MySQL and PostgreSQL (among others).

Answer 3

I especially like SQLAlchemy with following tools:

• Elixir (declarative syntax)
• Migrate (schema migration)

They really remind me of ActiveRecord.