metamod 0.0.2

ORM that uses __slots__ (for memory saving), plain DBAPI2 connections (to not break threading) and assumes the user knows SQL

overview

metamod stands for ‘metaclass models’.

• lightweight ORM (about 200 lines)

• uses python’s __slots__ so instances are lightweight and classes are self-documenting

vs other ORMs

The goal here is to be a thin layer on SQL. We want to wrap simple, well-understood and often-repeated actions like:

• create table

• insert

• simple select statements (where field=value)

Database writes are emitted as raw SQL that you can pass to a cursor. Database reads operate on a cursor (but not on a connection; you manage your connections yourself).

We don’t want to:

• generate complex SQL statements, especially for joins

• provide any type conversions (adapt / mogrify); we’ll trust psycopg2 or pymysql for that

• normalize behavior across different DBs

• hide connections & pooling behind classes

See github page for examples.