Part 4 of 6 · 2 min read
Applying the framework
Think of applying the framework like running a new building design past the same four-point checklist used for every other building. No building on the block gets to skip the checklist.
In plain words: Consistency needs here are modest: a learner's progress being a few seconds stale after marking a module complete causes no real harm, unlike the payment or inventory examples used earlier in this level. Scale is comfortably within a single well-tuned relational instance for a platform of this kind; content tables are small, and even a large number of learners each generating a modest number of progress rows stays well within what one machine handles for years. The dominant query pattern is simple, indexed lookups, exactly what a relational database is built for, with no need for a specialized store. Team cost settles the question decisively: running one familiar relational database for both content and progress avoids adding an entirely separate system for a workload that does not need one.
A worked example. Applying the framework's four questions to this platform concludes, in order: eventual consistency is fine for progress, scale fits one instance for the foreseeable future, the pattern is ordinary indexed lookups, and one relational database keeps operational cost lowest.
The key lines. No new SQL; this is the decision framework from earlier in this level, applied here.
Consistency: progress tolerant of brief staleness -> no strong requirement
Scale: content small, progress moderate -> single instance is enough
Pattern: indexed lookups by learner or module -> relational fits natively
Team cost: one familiar system -> no new system justified yet
Framework application
A framework application is working through each of the established decision questions, in order, against a specific real system, rather than treating the system as a special case exempt from the usual reasoning.
Example: every answer above follows directly from the same four-question order introduced earlier in this level, applied to this platform's own numbers.