The money quote was this "It’s not a big leap then for me to consolidate all three of those into one uber relationship table...".
The question was a good one because it involved the classic higher-order database relationship.
The canonical SQL relationships are binary equi-join relationships that can be …
more ...There aren't too many variations on the open-ended date range problem. We have a table of events or rules or policies that have start dates. Some have end dates, because they've been replaced or superseded. Others don't have end-dates because they apply for the foreseeable future.
There are two kinds …
more ...Background: I'm looking at parsing certain X12N messages. There's a Perl program on CPAN to do X12 parsing ; the program itself isn't useful, but the X12 messages are defined via INI files. There's also a Python X12 parser with the X12 messages defined via XML files. I don't really like …
more ...I hate to complain, but there's a Python syntax rule that has slightly cramped my style. The problem stems from a need to describe a really complex and extensible structure.
We need to describe X12N messages, which have a rather complex structure, and the structure can be customized. While the …
more ...See Sean McGrath's Spot the warning signs in configuration file design for thoughts on the ever-gnarly problem of how to provide a workable set of configuration parameters to a program.
A programming language has all the advantages as a language for encoding parameters. I see why it's rare -- too many …
more ...See Scott Ambler's article in Dr. Dobb's Journal , "Scaling Test-Driven Development ".
Recently, I'd seen some notes in SD Times on a similar theme, and blogged that in Not Quite Following the Book .
Ambler's point seems to be the same as Coplien's: "High-level architecture sketches created during your Iteration 0 envisioning …
more ...See Spolsky's Talks at Yale, Part 1 of 3 for a fairly typical summary of formal methods in software development. Here's the part RL liked: "Now, if the spec does define everything about how the program is going to behave, then, lo and behold, it contains all the information necessary …
more ...TP sent me this great link on MVC and related patterns. It's Ctrl-Shift-B's posting, Interactive Application Architecture Patterns . It is helpful at disentangling the distinctions between various kinds of model-view-controller, and model-view-presenter alternatives.
This is important because the terminology gets borrowed and adulterated sometimes. When we look at Struts , we …
more ...I can't find all of the Better Software Magazine articles on the Sticky Minds web site, so I can't provide a permalink. But look for "A Story About User Stories and Test Driven Development". It's good stuff, weighing out the good and bad features of "by-the-book" TDD.
more ...