Kumar Chandrachooda - KC Star V9 Simplified

Part 1 26 Aug 2025 5 min read

The Version That Deletes the Cleverness

After nine versions of accumulating ambition, KC Star V9 Simplified does the rarest thing - it takes features away. No permission groups, no group cache, just direct permission lists. The README recommends starting here. Kicking off the series on the version I would actually deploy.

Part 2 27 Aug 2025 4 min read

Direct Permissions, No Groups

KC Star V9 Simplified's schema is four permission tables and five seeded personas - full access, online-only, store-only, delivery-and-quotes, commission-only. GetFilteredSalesData takes an employee and returns exactly their slice. Permissions you can read in one table.

Part 3 27 Aug 2025 4 min read

A Permission Gate Inside Every Measure

KC Star V9 Simplified puts the permission check inside the measure calculation itself - a HasPermission call in the CASE that computes each aggregate. Read-time filtering, column masking, and an access level the view derives on the fly. The whole model, inlined.

Part 4 28 Aug 2025 5 min read

Caching Calculations, Not Permissions

V9 cached yes/no permission answers and inherited a revocation-staleness hazard. V9 Simplified caches finished calculation results instead - keyed on the employee's permission list, so a permission change changes the key and the stale entry is simply never hit. A better choice about what to cache.

Part 5 29 Aug 2025 5 min read

The Wishlist — Four Engines I Haven't Built

KC Star's wishlist folder holds four future engines - a multi-engine measures platform, multi-tenancy, predictive monitoring, and automated maintenance - all marked research phase, one with 500 lines of not-ready reference SQL. An honest look at the roadmap, and which one I'd build first.

Part 6 29 Aug 2025 6 min read

Nine Versions Later — What the Star Taught Me

From an inverted foundation to the version I'd deploy, KC Star evolved through ten explicit releases in the open. The retrospective on all of it - what versioning a schema publicly taught me about drift, variants, bugs as motivations, and simplicity as the real destination.

KC Star V9 Simplified — The Version I'd Deploy