finquick -- web app access to gnucash financial data
Support for SQL storage in GnuCash 2.4.10 allows reuse of the data using Web technologies, without extensive study of the GnuCash source code (which is upwards of 10MB, compressed).
Pyramid is "a small, fast, down-to-earth Python web application development framework." Building a RESTful JSON API to the GnuCash data is straightforward using SQLAlchemy SQL toolkit, which is conveniently packaged in the alchemy scaffold.
- cd <directory containing this file>
- $venv/bin/python setup.py develop to install dependencies in your development environment.
- $venv/bin/populate_finquick development.ini to initialize the database. I think this is not quite right.
- $venv/bin/pserve development.ini to start the server; it prints a web address at start-up; point your browser there.
Note Well I recommend using --no-site-packages when you set up a virual environment for finquick development, because zope.sqlalchemy seems to interact poorly with something otherwise, leading to the dreaded ImportError: No module named sqlalchemy.