Sunday, November 1, 2009

Playful time passing, computer geek style

database store {
  table tags {          /*
                         * Enumerates all tags in usage
                         */
    id        name;
  }
  table tasks {         /*
                         * Stores data for each todo with
                         * tags being a splitable string.
                         * Three date fields are used, marking
                         * when the item was set, completed, and
                         * a special 'mark' field, for things such
                         * as the do by then or piss off dilemma.
                         */
    id        tags       task       date_set    date_mark    date_done
   
  }
}



Just a simple structured annotation to the SQLite3 schemas that are in my brain at the moment.


Perhaps it would be more effective to encode the tags as a bitmask created from tags.id rows, mmm. The real question I suppose is can I actually insert the atribtrary data I want into an SQLite database and be able to query it without hitting any hard limits. Not that I'm likely to hit any there might be, lol.

No comments:

Post a Comment