sconemad

technology, scones, nonsense

Loading...

Profiles

Twitter

GitHub

Launchpad

Subscribe to my RSS Feed

Admin

Acow

Acow is a command line accounting application that I wrote as an experiment in the use of SQL (using MySQL in particular).

It is a relatively simple system, but supports multiple accounts and transactions between accounts.

Note that the application is entirely console based, however, it could be combined with a graphical frontend.

[wedge@regulus ~/projects/acow]$ ./acowc ls -a current
Listing transactions for account: current (ID=1)

    ID    DATE     PAYEE                              DEBIT    CREDIT   BALANCE
--------------------------------------------------------------------------------
     2 2009-10-20  bank loan                                    99.99     99.99
     3 2009-10-20  savings                             1.23               98.76
     5 2009-10-20  price busterz                       1.00               97.76
     6 2009-10-20  expensives r us                   100.00               -2.24
     7 2009-10-20  savings                                     200.00    197.76
--------------------------------------------------------------------------------

[wedge@regulus ~/projects/acow]$ ./acowc acc
    ID  NAME                             BALANCE
--------------------------------------------------------------------------------
     1  current                           197.76
     2  savings                          -155.56
--------------------------------------------------------------------------------

[wedge@regulus ~/projects/acow]$

Screenshot of acow in use

The first version of acow was written in perl using the DBI database module to connect to MySQL. I also wrote a C version which uses text files in place of a database to store the account details.

You can download acow v1.0.0 here.

Updated on 2010-03-03 17:14:56 +0000 | Requested on 2017-10-18 00:22:42 +0000