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.