Joseph Spiker spikerj
  • Joined on 2025-11-03
spikerj commented on issue spikerj/spikersoft-issues#633 2026-07-17 14:18:16 +00:00
[Go-Live Checklist][Security] Rotate + Bao-migrate the dev-environment secrets before production

Reclassified per spikerj (2026-07-17): this is an isolated dev environment, so the hardcoded secrets carry no production exposure and the 24 SonarQube findings have been ACCEPTED (not false-positiv…

spikerj closed issue spikerj/spikersoft-issues#651 2026-07-17 14:15:16 +00:00
[Reader][Offline] IndexedDB offline book store (schema + CRUD foundation)
spikerj closed issue spikerj/spikersoft-issues#650 2026-07-17 14:15:15 +00:00
[Reader][Perf] EPUB page prefetch/LRU + fix dead ngsw api-books cache group
spikerj commented on issue spikerj/spikersoft-issues#651 2026-07-17 14:15:10 +00:00
[Reader][Offline] IndexedDB offline book store (schema + CRUD foundation)

Resolved in spikersoft-angular PR #224 (offline store) + PR #225 (download service), both merged to master. BookOfflineStoreService (IndexedDB schema/CRUD, atomic deleteBook, sha256 staleness) +…

spikerj commented on issue spikerj/spikersoft-issues#650 2026-07-17 14:15:07 +00:00
[Reader][Perf] EPUB page prefetch/LRU + fix dead ngsw api-books cache group

Resolved in spikersoft-angular PR #223 (merged to master). EpubPageCacheService (LRU + prefetch±5 + in-flight dedupe) wired into epub-reader.loadPage; ngsw api-books (dead /Book*) replaced…

spikerj commented on issue spikerj/spikersoft-issues#649 2026-07-17 14:15:04 +00:00
[Reader][Social] Community badge opens the sidebar on Chapters, not the Community tab

Resolved in spikersoft-angular PR #222 (merged to master). The toolbar Community badge now fires a one-shot token so the sidebar jumps to the Community tab (index computed from file type), plus…

spikerj closed issue spikerj/spikersoft-issues#649 2026-07-17 14:14:55 +00:00
[Reader][Social] Community badge opens the sidebar on Chapters, not the Community tab
spikerj commented on issue spikerj/spikersoft-issues#633 2026-07-17 14:14:55 +00:00
[Go-Live Checklist][Security] Rotate + Bao-migrate the dev-environment secrets before production

Partial progress (PR #357, merged): the CodeExecution appsettings.Example.json no longer carries live secrets — the real prod RabbitMQ password and the live Production Seq ApiKey it leaked are…

spikerj commented on issue spikerj/spikersoft-issues#649 2026-07-17 14:14:55 +00:00
[Reader][Social] Community badge opens the sidebar on Chapters, not the Community tab

Resolved in spikersoft-backend PR #358 (merged to master). RedisClusterState's three derived node projections now materialize once into backing fields instead of re-filtering+re-allocating per…

spikerj opened issue spikerj/spikersoft-issues#652 2026-07-17 14:12:42 +00:00
[Backend] RedisClusterState derived projections re-filter+re-allocate on every access (SonarQube S2365 x3)
spikerj opened issue spikerj/spikersoft-issues#651 2026-07-17 14:07:11 +00:00
[Reader][Offline] IndexedDB offline book store (schema + CRUD foundation)
spikerj opened issue spikerj/spikersoft-issues#650 2026-07-17 13:52:16 +00:00
[Reader][Perf] EPUB page prefetch/LRU + fix dead ngsw api-books cache group
spikerj opened issue spikerj/spikersoft-issues#649 2026-07-17 13:46:16 +00:00
[Reader][Social] Community badge opens the sidebar on Chapters, not the Community tab
spikerj commented on issue spikerj/spikersoft-issues#648 2026-07-17 09:26:45 +00:00
[Backend] Final dead-code slice + AVIF failure diagnostics + Reader S927 renames (SonarQube S1144/S1481/S927 residue)

Follow-up PR #354 also merged (4/4 green) — the two S1481 cascades from the parameter removals are resolved, with the UpdateDockingTimers side effect preserved and documented in-code. The backend…

spikerj closed issue spikerj/spikersoft-issues#648 2026-07-17 08:46:16 +00:00
[Backend] Final dead-code slice + AVIF failure diagnostics + Reader S927 renames (SonarQube S1144/S1481/S927 residue)
spikerj commented on issue spikerj/spikersoft-issues#648 2026-07-17 08:46:16 +00:00
[Backend] Final dead-code slice + AVIF failure diagnostics + Reader S927 renames (SonarQube S1144/S1481/S927 residue)

Resolved in spikersoft-backend PR #353 (merged, 30/30 checks green). Full details in the ticket body; the smell-family triage's self-serviceable backlog is now fully drained. Closing.

spikerj opened issue spikerj/spikersoft-issues#648 2026-07-17 08:04:32 +00:00
[Backend] Final dead-code slice + AVIF failure diagnostics + Reader S927 renames (SonarQube S1144/S1481/S927 residue)
spikerj commented on issue spikerj/spikersoft-issues#647 2026-07-17 08:00:10 +00:00
[Backend] Remove 12 genuinely dead private parameters (SonarQube S1172) — the residue after the family's triage

Resolved in spikersoft-backend PR #352 (merged, 28/28 checks green): the 12 verified-dead private parameters plus the fully-dead members the S1144 pass confirmed (FindChainAnchor, the Lean…

spikerj closed issue spikerj/spikersoft-issues#647 2026-07-17 08:00:10 +00:00
[Backend] Remove 12 genuinely dead private parameters (SonarQube S1172) — the residue after the family's triage
spikerj commented on issue spikerj/spikersoft-issues#646 2026-07-17 07:47:56 +00:00
[GameServer][Bug] Hierarchical A* never worked: region identity collapsed to (0,0,0) via a placeholder IntToRegion — long-range pathfinding fell back to straight lines through obstacles

Resolved in spikersoft-backend PR #351 (merged, 7/7 checks green). Region tuples are now the abstract-search queue element directly — the placeholder IntToRegion that collapsed every dequeued…