Skip to main content

A set of tools which enhances ORMs written in Python with more features

Project description

Architect is a set of tools which enhances ORMs written in Python with more features and simplifies different database related complex tasks.



Architect has no required external dependencies except for the ORM it will be used with.


To install Architect, simply:

$ pip install architect


$ easy_install architect


Documentation is available at

Contacts and Support

I will be glad to get your feedback, pull requests, issues, whatever. Feel free to contact me for any questions.

Donations and Sponsorship

If you like this project and want to support it you have several options:

  1. Just give this project a star at the GitHub repository.
  2. Become a sponsor. Contact me via tepkeev at gmail dot com if you are interested in becoming a sponsor and we will discuss the terms and conditions.


PremiumSoft for supporting this project by providing Open Source License of Navicat.


0.6.0 (2020-11-14)


  • Peewee: Added support for 3.x branch (Issue #73)
  • Django: Added support for 3.x branch (Issue #76)


  • Backwards Incompatible: Peewee minimum supported version is 2.8.0
  • Backwards Incompatible: SQLObject minimum supported version is 3.5.0
  • Backwards Incompatible: Removed Python 2.6, 3.2, 3.3, 3.4 support


  • PostgreSQL: Tables with uppercase names weren’t partitioned correctly (Issue #58)

0.5.6 (2017-05-01)

  • Added: Support for testing all databases in one go using DB=all environmental variable
  • Fixed: Django: Unable to partition tables in multi database configuration without default database
  • Fixed: PostgreSQL: Failed to partition a table if a reserved keyword was used as a column name (turned out this wasn’t fixed properly in v0.5.4) (thanks to ra2er)

0.5.5 (2016-10-08)

  • Fixed: Django: Error handling with 1.10.x branch

0.5.4 (2016-07-04)

  • Added: Django: Issue #30 (Support for using database routers to determine correct database for a model in a multi database configuration)
  • Fixed: Peewee: Table partitioning was broken in Peewee >= 2.7.4 due to Peewee API changes
  • Fixed: PostgreSQL: Failed to partition a table if a reserved keyword was used as a column name

0.5.3 (2015-11-08)

  • Added: Tests are now built-in into source package distributed via PyPI
  • Fixed: Django: Issue #21 (Unable to partition a model with non-lazy translations)

0.5.2 (2015-07-31)

  • Fixed: PostgreSQL: Issue #14 (Error when trying to save a record into a table if partitioned column value had special characters inside, using string_firstchars and string_lastchars partition subtypes)
  • Fixed: PostgreSQL: Issue #11 (Error when trying to save a record into a table that was partitioned by a column that can be NULL, now if a column, that was used for partitioning, has NULL value it will be inserted into a special partition with _null postfix)
  • Fixed: SQLObject: Error when trying to partition a model with a field that has a default attribute set to some value

0.5.1 (2015-06-08)

  • Fixed: Issue #13 (MySQL support was broken in v0.5.0 released to PyPI)

0.5.0 (2015-05-08)

  • Added: Django: Issue #9 (Support for multiple databases)
  • Added: Support for custom features, see docs for details
  • Changed: dsn partition option renamed to db to cover more use cases
  • Changed: DsnParseError exception renamed to OptionValueError to cover more use cases
  • Fixed: Django: Error when trying to partition a model with Django <= 1.5 in debug mode
  • Fixed: “No module named” error when trying to specify model’s module with .py extension at the end in partition command

0.4.0 (2015-04-18)

  • Added: wheel support
  • Added: SQLObject ORM support
  • Added: PostgreSQL: New integer (thanks to Nikolay Yarovoy), string_firstchars (thanks to Dmitry Brytkov) and string_lastchars range partition subtypes, see docs for details
  • Changed: range partition option renamed to constraint to better suit new partition subtypes
  • Changed: PostgreSQL: Triggers refactoring and speedups, don’t forget to rerun partition command to apply new refactored triggers to the database
  • Fixed: architect.uninstall decorator wasn’t able to restore modified model methods under Python 3

0.3.0 (2015-04-05)

  • Added: Documentation rewritten from scratch
  • Added: Introduced completely new API (almost 80% of Architect code was rewritten from scratch). All functionality is now provided by an architect.install decorator which dynamically injects requested feature, e.g. partition, into a model under the architect namespace, e.g. model.architect.partition. No more mixins, inheritance and nested classes with settings that pollute model’s namespace. More information is available in the docs
  • Added: New operation feature which provide an abstraction layer to execute raw SQL statements which will work with any supported ORM, see docs
  • Fixed: Issue #8 (cannot import name string_literal error with PonyORM and PyMySQL if pymysql.install_as_MySQLdb() was used)
  • Fixed: Issue #7 (SQLite dummy backend was completely broken)
  • Fixed: Issue #4 (autocommit cannot be used inside a transaction error with Django if a model was used inside with transaction.atomic() block)
  • Fixed: Issue #2 (partition command was unable to find module with models to partition)
  • Fixed: Issue #1 (relation already exists error when trying to insert data into non-existent partition simultaneously from several queries) (thanks to Daniel Kontsek)

0.2.0 (2014-07-19)

  • Added: MySQL: Range partitioning support

0.1.0 (2014-07-13)

  • Initial release

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

architect-0.6.0.tar.gz (34.5 kB view hashes)

Uploaded source

Built Distribution

architect-0.6.0-py2.py3-none-any.whl (29.0 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page