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? …
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 …
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 …
My last post looked at some abstractions that might do good things for me, but as with any design decision (or even design think-hard-about) it’s a good idea to validate it. Even if it’s not possible to prove correct, it can at least be possible to determine it’s not a …
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 …
Unlike at work, where ‘operations’ means ‘keeping Production from tipping over’, here I mean ‘what things do we want to be able to do with this application?’ In database terms, we want the full range of CRUD actions: Create, Read, Update, and Delete records. This includes any other artifacts (such …
As is sadly typical during my A-Z Blog Challenge runs, I’m struggling in the middle. Ah well, it’s the weekend, time to catch up! In a recent post I said that now that I’ve got a sense of the column types and their configuration, it’s time to get specific about …
Often during the A-Z Blog Challenge I use ‘M Day’ as a ‘Midpoint Check-In’, listing the posts up to this point. This time I think I’ll summarize my current design position. Overall, I have a sense of where I’m going and how to get there, but there is much that …
I was planning to show how various entities might be defined, using the attribute declarations described yesterday… but it’s been a rough week. Instead, I’ve been cleaning up some of my libraries, and found some features I hadn’t considered that I’d very much like to see in my graphical user …
Yes, taking the easy route on naming the “K Day” post. There’s enough thinking in this one I don’t feel bad about it. Yesterday I looked at the data types available in calibre for custom columns , and made a few notes about how I might handle column definition. Time …
