Posting challenges, usually time bound or on a particular topic or theme.
Revisiting a topic I’ve written about previously gives me an opportunity to reread older posts. In this case, I’ve written a fair bit of material that’s worth revisiting. The posts from the 2021 A-Z blog challenge show a lot of my thinking, a fair bit of how I thought things …
In the 2021 A-Z Blog Challenge I took a run at Divine Trappings. Something of a follow up to Polyhedral Pantheons, Divine Trappings are descriptive elements that might be applied to a deity (and their associated religions) based on the domains assigned to that deity. I didn’t quite finish the …
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 …
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 …
