Sunday, February 10, 2008

Upgrades in the works

Now that the application give rudimentary services, I can work on making it useful an perhaps fun. The planned upgrades have to do with making taskTimer really Web 2.0. Currently, it's slightly web 2.0 because users access it through facebook. The advantage of using facebook is that it has great distribution and it has user accounts already set up. But essentially, there is no interaction between users and the contribution of users do not in someway contribute to a bigger whole.

Through the process of taskTimer, I was able to better able to understand how to integrate an application in facebook. The upgrades will only be an exercise in php programming (and perhaps some minor facebook variable accessing--to access friend networks for sharing etc). Rather than have one big table that holds all the information. I will introduce multiple tables to handle the expansion in scope.

create table times (taskID int,log datetime,code int,seconds int);

create table tasks (user int not null, taskID serial unique, description text, alarm int);

create table prefs (user int not null, friend int, permission int);

hmmmm....... just a minute.

No comments: