Crazy Accounting
From Makers Local 256
Creator: |
Overview
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.
- Password Vault, because I have to many passwords.
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 | ----------------------------