Simpycity¶

A simple DB Procedure/Query mapper.

About¶

Simpycity is a simple mapping system for PostgreSQL stored procedures and queries, enabling easy usage of PG procedures using standard Python call semantics.
Simpycity is available under the terms of the Lesser GPL.

Usage¶

• A Quick Tutorial
  • Function
  • Raw Query
  • Query
• Constructs
  • Construct
  • SimpleModel
• Configuration
• Using Simpycity with Pylons
• PythonSimpyCityPostgreSQL 101

Download¶

The current release version of Simpycity is 0.3.1, which can be downloaded from

• here (source)

Or, it's available on the PyPI index, via:

$ easy_install Simpycity

Version numbering is:

• X. - No meaning.
• .X. - API version - This is incremented every time an update breaks API compatibility. In this instance, we're on the 3rd major API revision.
• .X - Minor version: Incremented for new feature releases that don't break API compatibility.
• aX - Developer release version. This will increase as bugs are fixed and issues are resolved. No API-breaking changes will be made here.

Otherwise, you can access the SVN repository via:

svn co https://projects.commandprompt.com/public/simpycity/repo simpycity

Or, you can get the codebase straight from GitHub, via:

git clone git://github.com/commandprompt/Simpycity.git

We'll take all pull requests seriously and examine each one. Contributions are more than appreciated!

Contribute¶

Interested in contributing to Simpycity? Just subscribe to our mailing list!

• simpycity@lists.commandprompt.com

Patches are always welcome.