Skip to content

Update screenshots and fix DuckDB migration ordering#318

Merged
erikdarlingdata merged 8 commits intomainfrom
dev
Feb 26, 2026
Merged

Update screenshots and fix DuckDB migration ordering#318
erikdarlingdata merged 8 commits intomainfrom
dev

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • Updated README screenshots for Resource Overview and Query Performance
  • Added new Graphical Plan Viewer screenshot
  • Fixed DuckDB migration ordering after archive-and-reset (skip migrations on fresh/reset databases)

Test plan

  • All 6 Lite.Tests pass
  • Build succeeds
  • CI pipeline

🤖 Generated with Claude Code

erikdarlingdata and others added 8 commits February 26, 2026 08:14
…ering

- NocHealth: session_id is smallint in DMVs, use Convert.ToInt32 instead
  of reader.GetInt32 to avoid "Unable to cast System.Int16 to System.Int32"
- DuckDbInitializer: run CREATE TABLE before ALTER TABLE migrations so
  migrations don't fail against nonexistent tables after archive-and-reset

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Fix Int16 cast and DuckDB migration ordering
The previous fix (PR #313) moved CREATE TABLE before migrations, but
migrations v2/v6/v7/v8 DROP TABLE IF EXISTS then expect CREATE TABLE
to follow — so tables were created then immediately dropped.

Correct fix: skip migrations entirely on fresh/reset databases (v0).
When existingVersion is 0, there's nothing to migrate — just create
tables with the current schema and stamp the version.

Fixes CI test failures: InitializeAsync_CreatesAllTables,
InitializeAsync_CreatesIndexes.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
for 2.0 release
…ering

Fix DuckDB migration ordering after archive-and-reset
- Point Resource Overview and Query Performance to new screenshots
- Add Graphical Plan Viewer screenshot showcasing missing index
  suggestions, operator warnings, and cost analysis

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit c29d011 into main Feb 26, 2026
3 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant