quacken / finquick / README.rst

The default branch has multiple heads

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.

Building a browser interface to the JSON data is straightforward with AngularJS, a JavaScript framework with two-way databinding,

Getting Started

  • cd <directory containing this file>
  • $venv/bin/python 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.