Difference between revisions of "Crazy Accounting"

Revision as of 23:15, 20 September 2007

Description

As a learning experience I want to write a basic accounting program to keep up with where my money. First I am going to write the program in C/C++, then hopefully move to PHP, Ruby, Perl, Jave or what ever else I want.

Features

• Storage is going to be on MYSQL, because many languages have API's. Oh and I already know how to do this in C/C++ and MYSQL.
• Have redundant MYSQL serves. Check local machine first, then a server on the net.
• Export data as XML.
• Graphs, Pie Charts, Tag Clouds, and other cool stuff like that.
• iPhone native app, widget or something.
• Easy to use for geektools.
• Auto fill in data from other transactions.

Status

• Created the wiki, and added some first build thoughts.--JimShoe 17:08, 18 September 2007 (CDT)
• I got C and Mysql linked and working together. I have the debit and credit insert statemets working. Going to have to move tags to their own table, but that will be later. --JimShoe 23:15, 20 September 2007 (CDT)

First Build (Augusta)

Features in Augusta

• MYSQL storage
• C/C++ command line application.

Database Storage
This is a rough idea of the scheme for Augusta.

Debit Table
 ----------------------------------
| key | Ammount | To | Date | tags |
 ----------------------------------

Credit Table
 ------------------------------------
| key | Ammount | From | Date | tags |
 ------------------------------------

Total Table
 ----------------------------
| key | Ammount | Time_Stamp |
 ----------------------------