Monday, 6 April 2009

Database

I am keeping the information in a database in a .list format which is easy to read and write from. I could have used an Access or Oracle database but they would be to slow due to the abundance of features that I would not use. I need a very simple format to hold the actual ToDo List data, defining number, category number and the date.

An entry would look something like this:
5||Feed Tarantulas|6|20122009
The first number is the defining number, the text after the || is the actual ToDo List item, the third number after the ToDo List item is the category code which gives it a colour. The colour is bought up from a Categories .list file. The numbers after the category number is the date.

The categories .list file will look like this:

0|#0000FF|Business
1|#00FF00|Financial
2|#FF00FF|Education
3|#CC6600|Recreation
5|#9900FF|Shopping
6|#666600|Chores
7|#009999|Other

I have chosen eight categories which would cover any common type of ToDo List entry.

This is the simplest form of a database and is very easy to view, maintain and update without any third-party software.

No comments:

Post a Comment