Imagination Helper

… sounds like some kind of weird meal preparation product. I haven’t completely stalled on #lore24, but it’s close. I started looking at my random table resolver, and got sidetracked. For a command line tool I wrote more than 25 years ago — in the late 1900s — it does …

Media Library: Thinking and Rethinking Identity and Redundancy.

My last post explored a few of my use cases and how they might work… and ended with a situation that puzzled me: how do I resolve the ‘original file name’ of a document file, when I have merged multiple copies of the same document (and file) from different sources? …

Media Library: Simulating Use Cases

A recent post included some quick validation of a tentative design… and failed it! I argue this is a successful validation exercise: if the ‘first-best results’ prove a design or implementation is correct, ‘second-best results’ find a problem before it matters. Second-best results are just fine by me, they me …

Media Library: Revising the Data Model

My previous post, Quick Validation, concluded almost immediately the more abstract model I was considering is not suitable for my purpose here. You might be wondering why. In a relational database, referential integrity is a critical consideration. Normally a table may contain fields defined as ‘pointing at another table’. These …

Media Library: Pondering Abstraction, Possible Disaster

In my last post, regarding Operations, at one point I started to write “and everything can have Tags”… when I realized that can happen, but takes a little extra work. What if they could, though? Early in this series when I wrote about data modeling I recognized that many entities …

Back to Top