Crazy Accounting

From Makers Local 256
Jump to: navigation, search

Creator:
Jim Shoe
Status:
Brain Storming
Born On:
17:08, 18 September 2007 (CDT)
Last Updated:
08:12, 31 October 2008 (CDT)

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 |
 ----------------------------