GnuCash PostgreSQL support

[Shane Litherland]

Thanks for sharing this :-)

I use PostgreSQL a bit with GIS and other records, and intend to play
with GNUcash in pg along the way too...

seeing how/what others wrote is handy for learning more tricks...
I am comfortable with SQL but using other means to implement (it and make it look pretty) like
Python or Ruby is new stuff to me. Be nice to see how others have made
use of the SQL option in GNUcash :-)

As others commented, I know the xml versions can still have things
written for custom reporting etc, but I've not delved into that because
I'm familiar with SQL but not with much else.

Managed to download the file OK, so will see how much I can glean from there :-)

Regards,
Shane.


> Hi Derek, hi all,
> the enclosed tgz-files contains the entire package. Theoretically, you have to enter the correct database name, user and password only. The application works under Rails 2.3.3 with  ruby 1.8.7. The application is not very sophistacted (I am not a developer at all) but good enough to see the annual balance. Basically, the app stores vaues of the transactions/splits in an array which is then rendered in the respective view. I don't track financial gains/losses by changes in stock prices in this app. It emphasis on income and expense. As I don't use the small business functionaliaty, nothing is considred in the app.
> 
> The initial view shows the results per account type per year as well as some expense vs income calculation. Below the main table you find a search section by which you can search the description of a transaction for a given income or expense account. There are two entry options so that you seach for two different strings in the same transaction description.
> 
> >From the start view you can then drill down into a more detailed view either per account type or per year and from there, to the single transaction.
> 
> Unpack the archive and 'cd konten_ror.app'. Prior to start the application, edit 'config/database.yml' and enter dbanme, username and password for 'development'. Then, start the webrick server by entering 'script/server'. Point your browser to 'http://localhost:3000/ausgaben/start'
> 
> 
> Good luck,
> Klaus
> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: gnucash_ror.tar.gz
> Type: application/octet-stream
> Size: 86188 bytes
> Desc: not available
> URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20120130/15b85746/attachment.obj>
> 

> *********************************************