Making Open Badges Self-Contained: Denormalization and Air-Gapped Credentials @ChuckSeverance
Making Open Badges Self-Contained: Denormalization and Air-Gapped Credentials  @ChuckSeverance
Uploaded November 2026 | Updated November 2026, 3 days ago
In this episode of AI Coding with Dr. Chuck, I work on making published Open Badges in Tsugi completely self-contained.

The existing badge implementation still depends on live course data, including Lessons content and other relational information. That creates a long-term problem: courses should eventually be retired, student activity should not be retained forever, and a published credential should remain valid even after the original course environment is gone.

The solution is deliberate denormalization. When a badge is published, Tsugi now captures the information needed to render and verify that badge into the badge record itself, including accomplishments and other evidence that previously came from live course data.

I also work through badge image preservation. Instead of depending indefinitely on an external image file, the system stores badge images separately using SHA-256 for deduplication and can transparently fall back to the stored image if the original file disappears.

The goal is an “air gap” between a published credential and the rest of the learning platform: the course, learner account, lesson structure, and original files can eventually disappear while the badge remains complete and verifiable.

Topics include:

Open Badges
Badge denormalization
Long-lived digital credentials
Credential portability
Learner privacy
Relational database design
Data retention
SHA-256
Binary image storage
Database BLOBs
Idempotent migrations
Backfilling existing records
Fallback image storage
Tsugi
Open Badges 3
LinkedIn credentials
AI-assisted software development
Making Open Badges Self-Contained: Denormalization and Air-Gapped CredentialsHow to Winterize a Sea-Doo Speedster (2006) | Drill Pump & RV Antifreeze MethodShelby visits Mari Winery and shares a Charcuterie tray #aussie #dogcation #spoiledpup2AM Bathrobe Coding With AI — Building Page History - Master ProgrammerAI Coding: Tsugi Accessibility Fixes with Wave and Cursor.AIBuilding LTI 1.3 Names and Roles with AI – A 4 AM Silent Coding SessionAfter the Experiment: What Actually Worked (Vibe Coding #4)Shelby at TraverseCityHorseShows at getting impatient #dogcation #horsejumping #aussie #spoiledpupTwas the night before Christmas - Playing catch with an Aussie #dog #aussie #snowDJ 29.05 JavaScript Network Events with Fetch and Promises (6:26)Refactoring Tsugi Settings into a Real Controller with Cursor AIInstalling KVAdmin.py Client and Server on Deno Deploy
Chuck Severance |

Making Open Badges Self-Contained: Denormalization and Air-Gapped Credentials

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER