Here’s a familiar kind of growing pain:
Suppose I’ve been working with a “flat” TiddlyWiki design — a glorified spreadsheet:
- 60 tiddlers, each representing a student
- 6 fields for each tiddler, in which to track student’s assignment grades.
Then an awkward moment happens: After entering and working with data for a while in this “flat” model, I realize each of those data “points” (field values) deserves a tiddler. (Say, I realize I want to record qualitative comments, submission date, and even the content of what was submitted for each assignment.) So, I now want a project with 360 “atomic” tiddlers (plus the 60 per-student tiddlers, which will still serve as summary nodes). And… I want not to lose my data.
Surely there’s a word for this kind of “growing pain” in data handling. It’s adding a dimension, like “exploding” a 2-D graph into a 3-D graph – exactly what distinguishes a “flat file” database from a relational database.
If I had an infinitely patient employee (or perhaps if I knew how to recruit ChatGPT to work effectively with json data), I’d just say:
For each assignment field of each student tiddler, create one new “submission” tiddler. Come back to me with 360 tiddlers that look like this:
title: OldTiddlerTitle_FieldName
text: OldFieldValue
Have you encountered this hurdle, mid-project? Is there anything like a general solution for this task?
-Springer