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 ...I've upgraded my Building Skills in Python to cover the 2.5 release. It didn't take as long as I'd anticipated.
The new features list for Python 2.5 is mercifully short. I did a fair amount of reorganization to consolidate some things that had grown or split needlessly.
Changes …
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 ...