QLime Features

Object-Relational mapping features of QLime

• Table - class mapping:

  At the simplest level, a relation maps directly to a Python class.

• Intuitive search/filter syntax:

  Use class level attributes to construct filters for searching the database. You can limit, offset or sort while searching.

• Loosely coupled to the data source:

  Like Python, you do not specify the list of attributes or types in the class. Just connect a Python class to a data source and certain attributes will automatically be persisted.

• Lazy attributes:

  You can specify certain columns as lazy which means they are only loaded from the database when accessed.

• Join semantics:

  • One to one joins
  • One to many joins
  • Lazy and non-lazy joins
  • Joined objects are updateable
  • Joined objects retain identity
  • Self joins (join a table to itself)

• Miscellaneous

  • Lock objects within a transaction for updating.
  • Use auto-increment database columns.
  • Objects roll back to their previously commited state on transaction rollbacks.

Supported Databases

• Version 0.6.0 supports:
  • PostgreSQL (via PyPGSql).
  • Firebird (via KInterbasDB)
• Upcoming version supports:
  • PostgreSQL via both psycopg and PyPGSql
  • SQLite via pysqlite

Other Data Sources

The QLime API is versatile enough to allow access to non-database sources as well. A CSV file data reader is included in QLime.