Fixed #

• Schema tab stuck on "Loading…" — when schema DDL was already cached from another view (table data in "both" scope, search tab), the Schema tab never rendered the cached content; now uses cache-first rendering so the tab displays immediately
• "Ask in English" crashes with loadSchemaMeta is not defined — the NL modal, table-view column-type loader, and cell-edit module all called loadSchemaMeta at runtime but the function was scoped inside app.js and never reachable from the bundled TS modules; extracted into a shared schema-meta.ts module with proper imports

Improved #

• DB Diff tab shows setup guide instead of error jargon — when the comparison database is not configured, the panel now explains what the feature does and shows a collapsible "How to enable" section with a code example; buttons are hidden until the feature is active, instead of showing developer-facing error messages after clicking
• Quieter debug console for stale tables — when a table is listed in sqlite_master but has been dropped since the last metadata fetch, the server now logs a one-line warning instead of a full stack trace; snapshot capture skips failed tables instead of aborting

Maintenance

• README screenshots — added 10 feature screenshots (Tables, Table Data, Schema, Index, Size, Perf, Health, Import, Ask in English, Light Mode) in an HTML grid with captions; renamed files from random hashes to descriptive names; added Screenshots link to TOC

---

Fixed #

• Stale tables persist after project switch — switching Flutter projects reloaded the webview HTML but localStorage kept pinned tables, nav history, table state, SQL history, bookmarks, and analysis results from the previous project; now detects when the server origin changes and purges all project-specific storage while preserving user preferences (theme, sidebar state)
• False-positive "missing table" errors on empty database — when the database had no tables (app never run, or server connected to an empty DB), every Dart table class was flagged with an Error-level missing-table-in-db diagnostic; now detects the empty-DB condition and suppresses individual missing-table errors while still flagging genuinely missing tables in partially populated databases

Maintenance

• File modularization — split 3 files exceeding 300-line limit: dashboard chart-clipboard logic, ER diagram SVG helpers, and panel test fixtures each extracted into dedicated modules
• Final IIFE extraction — moved last 4 inline init blocks (initPiiMaskToggle, initSearchToggle, setupCellValuePopupButtons, setupChartResize) into their feature modules; removed 70 unused imports; app.js reduced to 926-line init-only glue
• Test coverage — added tests verifying extracted helpers compose correctly into webview script output
• Test coverage — 22 contract tests for server-origin storage clearing: state constant, persistence function wiring, key targeting, UI-preference preservation, call ordering in app.js, and bundle integration

---

Version bump for publication.

---

Fixed stale data after switching servers, restored broken heartbeat and polling controls, and added Log Capture session export so Drift Advisor diagnostics flow into your capture sessions automatically. log

Fixed #

• Wrong project tables after server switch — webview panel showed stale tables from the previous project when the debug server changed; now detects host/port changes and fully reloads content from the new server
• Retry targeted wrong server — the Retry button in the webview used the original server endpoint instead of the current one after a server switch; now always uses the panel's current host/port
• Heartbeat reconnection stopped working — heartbeat reconnection silently dropped back to no-op stubs instead of resuming polling; now wired correctly at startup
• Polling toggle missing — the masthead pill click handler and keep-alive toggle stopped responding; restored

Added #

• Log Capture session export — when both extensions are installed and driftViewer.integrations.includeInLogCaptureSession is full (the default), session end now writes structured metadata (query stats, anomalies, schema summary, health, diagnostic issues) into the Log Capture session and a {session}.drift-advisor.json sidecar file; set to header for lightweight headers only, or none to opt out entirely
• Log Capture extension API — getSessionSnapshot() is now available on context.exports so Log Capture's built-in provider can request a snapshot directly without the file fallback
• Session file fallback — .saropa/drift-advisor-session.json is written at session end for tools and scenarios where the extension API is unavailable

Maintenance

• esbuild bundling — all web JS/TS assets bundled into a single bundle.js via esbuild; Dart server plumbing collapsed from 4 cached fields / 4 script tags to 1
• Full JS modularization — app.js decomposed from 6882-line monolith to 915-line init glue; 23 TypeScript modules extracted; shared state centralized in state.ts with typed exports
• SCSS modularization — style.scss decomposed from 2184 lines to 28-line import hub with 17 feature partials; migrated from deprecated @import to @use
• Connection diagnostic logging — all connection state transitions, poll cycles, heartbeat, and keep-alive events now emit [SDA] prefixed console.log entries for browser dev tools tracing

---

Type badges on columns, random data sampling, health scores, query cost analysis, and a pile of UI polish. log

Added #

• Column type icons (Website) — data table column headers now show a compact type badge (e.g. TEXT, INT, REAL, BLOB) sourced from schema metadata; full type in tooltip
• Table definition type icons (Website) — table definition panel now shows a fixed-width icon column with type glyphs (# integer, T text, .# real, etc.) plus 🔑 PK and 🔗 FK badges for quick visual scanning
• Data sampling (Website) — Sample button in the pagination bar loads a random sample of rows via ORDER BY RANDOM() LIMIT N
• Health score (Website) — anomaly scan results now show a 0–100 health score with letter grade (A–F) and a severity breakdown summary
• Query cost analysis (Website) — EXPLAIN output now shows an estimated cost rating (Low/Medium/High) with operation counts (full scans, index lookups, subqueries, sorts, temp storage) and a collapsible raw plan detail view

Fixed #

• App logo not appearing (Website) — replaced corrupted inlined base64 PNG (~185 lines) with a CDN-hosted URL using the same jsDelivr + @main fallback pattern as CSS/JS assets

Changed #

• Query history expanded (Website) — SQL history limit increased from 20 to 200 entries, matching the VS Code extension

• Collapsible table definition (Website) — table definition panel above the data grid is now collapsible (collapsed by default), matching the query builder pattern; self-contained in table-def-toggle.js

• Masthead pill (Website) — combined the version badge and connection status into a single header pill showing logo · version · Online/Offline; styles extracted to _masthead.scss partial, HTML extracted to _buildMastheadPill() method

• Connection status terminology (Website) — renamed "Live" to "Online" throughout the web viewer for clarity

• Sidebar toggle arrow (Website) — arrow is now larger, right-aligned, and points left instead of down for clearer collapse affordance

• FAB opens upward (Website) — floating action button menu now fans upward from the trigger, with items right-aligned against the trigger edge

• Share moved to FAB (Website) — Share button relocated from the header bar into the FAB menu as the first action item

• FAB modularized (Website) — FAB styles extracted to _fab.scss partial, FAB UI logic extracted to self-contained fab.js module

• Premium theme effects (Website) — Showcase and Midnight themes now have real glassmorphism (backdrop-filter blur on header, sidebar, cards), animated gradient backgrounds, rainbow shimmer borders on expanded cards, floating glow orb (Midnight), entrance animations, and gradient buttons; removed broken CDN dependency on nonexistent drift-enhanced.css; all four themes are always available without external network requests

• Monospace font upgrade (Website) — switched to JetBrains Mono via Google Fonts CDN; centralized font stack into a single --font-mono CSS custom property for easy future changes

• Responsive toolbar (Website) — tools toolbar no longer wraps to a second row; text labels progressively hide at three breakpoints (1100px, 900px, 700px) leaving icon-only buttons with tooltips at narrow widths

Added #

• Column visibility toggle (Extension) — SQL Notebook results now have a "Columns" button to show/hide individual columns, with a dropdown chooser and "Show All" reset
• Row filter toggle (Extension) — SQL Notebook filter bar now has a "Matching/All" toggle to switch between showing only matching rows and showing all rows
• Responsive ER diagram (Extension) — ER diagram automatically re-fits to the panel when the window is resized, debounced to avoid flicker
• Export index analysis (Extension) — Index Suggestions panel has a new "Export Analysis" button that exports as JSON, CSV, or Markdown to clipboard or file
• Copy chart to clipboard (Extension) — Dashboard chart widgets now have a clipboard button in the header that copies the chart as a PNG image
• JSON export (Website) — Export panel now offers "Table JSON" alongside the existing CSV download
• Import history log (Website) — Import panel tracks all import operations during the session in a collapsible history list showing time, table, format, row count, and errors

Fixed #

• Acronym column name mismatch detection — When Drift's camelCase-to-snake_case splits acronyms like UUID into u_u_i_d, but the database uses uuid, the advisor now reports a single column-name-acronym-mismatch diagnostic instead of a confusing missing-column-in-db / extra-column-in-db pair. The message explains the root cause and suggests both fix options (rename getter or .named() override)
• Anomaly detector: reduced false positives — Numeric outlier detection now skips timestamp columns (created_at, *_date, etc.), sort/ordering columns (sort_order, position, rank, etc.), and year/founded columns. Added a log-scale fallback so distributions spanning orders of magnitude (e.g., currency exchange rates, engagement scores) are no longer flagged. Outlier messages now identify which end (min/max) is the problem and by how many σ
• Slow-query and N+1 false positives on table definitions — Runtime performance diagnostics (slow-query-pattern, n-plus-one) moved from the performance category to runtime so users can disable them independently of schema checks. Server-internal queries (no caller location) are now downgraded from Warning to Information severity. When caller location is available, diagnostics pin to the call site at full Warning severity. Slow-query messages include row count; N+1 messages hint at batching via JOIN/IN for high repeat counts

---

Super FAB menu, app logo in the tab bar, and premium theme effects that actually look dramatic now. log

Added #

• Super FAB menu — Sidebar toggle, theme cycle, and PII mask moved from the header into a floating action button in the bottom-right corner. Click the gear icon to expand; click outside or press Escape to dismiss
• App logo in tab bar — Replaced the "Saropa Drift Adviser" text header with the app logo, positioned inline with the tab buttons

Fixed #

• Showcase/Midnight themes now show dramatic visual effects — The premium themes had nearly-opaque backgrounds (75-85% alpha) that made glassmorphism invisible. Completely rewritten with floating ambient orbs, glass shimmer sweeps, card entrance animations with blur-to-clear, rainbow borders visible at rest, dramatic hover lifts, animated gradient buttons, and backgrounds at 25-35% alpha so the frosted glass effect is unmistakable
• Sticky header preserved in premium themes — The enhanced CSS was overriding position: sticky with position: relative on the header, causing it to scroll away instead of staying fixed

---

Fixed the changelog — 2.17.2 had accidentally overwritten the 2.17.1 entry. Both versions are now listed correctly below. log

Maintenance

• Publish pipeline: store propagation polling — After publishing, the pipeline now polls pub.dev, VS Code Marketplace, and/or Open VSX APIs until the new version is visible (30 s interval, 10 min max). Timeout is non-fatal

---

Midnight theme, draft conflict detection, masked CSV export, clipboard paste import, and a wave of false-positive fixes across diagnostics. log

Added #

• Midnight theme (CDN-only) — A fourth theme option: deep navy dark mode with periwinkle accents, glassmorphic panels, animated gradient background, and rainbow side borders. Uses the saropa.com dark palette (#1a1d2b / #2c3350 / #8fa8ff). Degrades gracefully to the base dark theme when the CDN is unavailable
• Draft conflict detection — When restoring saved pending edits from a previous session, the extension now checks each edit's original value against the live database. Warns if rows were changed or deleted since the draft was saved, with the option to restore anyway or discard
• BLOB columns blocked at the DOM level — BLOB columns are now visually non-editable (double-click is silently ignored) rather than requiring a server round-trip rejection. Table headers carry data-col-type attributes for client-side detection
• Copy migration SQL — Database comparison panel now has a "Copy Migration SQL" button that fetches the DDL migration preview and copies it to the clipboard
• Clickable ER diagram tables — Double-click a table node in the ER diagram to open its data view. Drag detection prevents accidental navigation while repositioning
• Masked CSV export — New "CSV (PII masked)" option in the extension export picker. Heuristic column-name detection masks emails, phones, SSNs, passwords, tokens, secrets, API keys, and addresses
• Clear table / clear all — Web viewer now shows "Clear rows" and "Clear all tables" buttons when write access is enabled. Executes via the batch edits endpoint in a single transaction with double-confirmation
• Clipboard paste import — Web viewer import panel has a "Paste" button that reads from the clipboard and auto-detects CSV, TSV, or JSON format
• Configurable slow-query threshold — Performance panel now has a threshold input (default 100 ms) that is passed as a query parameter to the server. Recent queries color-coding adapts dynamically

Changed #

• Light theme is now the default — The web viewer defaults to light mode when no saved preference or OS/VS Code hint is detected. Previously defaulted to dark
• Light and showcase palettes overhauled — Both light themes now use the saropa.com design system: slate-blue text (#242b4a), blue-tinted borders (rgba(143, 168, 255, ...)), multi-layer composited shadows, larger border radii (8/12/16px), and hover lift effects
• Theme cycle expanded to four — With enhanced CSS loaded, the toggle cycles Light → Showcase → Dark → Midnight. Without CDN, it toggles Light ↔ Dark
• Smart premium upgrade — When enhanced CSS loads with no saved preference, OS dark-mode users get Midnight automatically; light-mode users get Showcase

Fixed #

• Removed blob-column-large diagnostic — The unconditional "may cause memory issues" warning on every BLOB column has been removed. Developers choose BLOB storage deliberately; the type-only check was unactionable noise. The "Profile Column" command remains available from other diagnostic providers for on-demand column analysis
• Anomaly false positives on valid wide-range columns — The numeric outlier detector no longer flags coordinate columns (lat/lng/lon/latitude/longitude), version/revision columns, or any column whose data naturally spans a wide range. Replaced the naive 10× average heuristic with 3-sigma (standard deviation) statistical analysis, plus name-based skips for known domain patterns
• False positive diagnostics in non-Drift projects — The extension no longer fires missing-table-in-db and extra-table-in-db diagnostics in workspaces that don't use Drift. Three fixes: (1) diagnostics now skip scanning when pubspec.yaml lacks drift or saropa_drift_advisor; (2) the Dart parser ignores class … extends Table patterns inside /// doc comments, // line comments, and /* */ block comments; (3) extra-table-in-db reports against the primary schema file instead of an arbitrary first match
• Saved premium theme restored after CDN loads — If a user saved Showcase or Midnight but the CDN hadn't loaded yet, initTheme degraded them (Showcase→Light, Midnight→Dark). When the enhanced CSS finally loaded, markEnhancedReady did not restore the saved premium theme. Now it does
• No-PK table gate uses error, not warning — Opening the bulk edit panel on a table without a primary key now shows showErrorMessage (blocking, unmissable) instead of showWarningMessage (dismissible)
• Commit failure message includes rollback context — Error now states the statement count and confirms the transaction was rolled back, making it clear pending edits are preserved for retry
• Table cells carry raw values for editing — Report table <td> elements now include data-raw-value attributes so the inline editing script correctly distinguishes NULL from the text "NULL"
• N+1 false positive on activity/log tables — The N+1 query detector now only counts SELECT operations. Write operations (INSERT, UPDATE, DELETE) are inherently per-record and were incorrectly inflating the hit count, causing false warnings on tables like activities that receive frequent independent writes from user actions
• Index suggestion false positives (missing-id-index, missing-datetime-index) — Three fixes: (1) the _id heuristic now only fires when a matching table exists in the database (e.g. user_id fires if users table exists, but api_id, swapi_id, wikidata_id are suppressed); (2) the datetime heuristic now checks the Dart column type and skips non-datetime types like BoolColumn (fixes is_free_time being flagged as a datetime column); (3) both heuristic codes downgraded from Information to Hint severity so they appear as faded text rather than cluttering the Problems panel

---

Showcase theme, webview panels for all command output, sidebar column counts, and reliable theme activation. log

Added #

• Showcase theme (CDN-only) — A third theme option for the web viewer with glassmorphism frosted-glass panels, animated pastel gradient backgrounds, rainbow side border accents, drop shadows, staggered entrance animations, and purple accent colors. The theme is the default when the enhanced CDN stylesheet loads and cycles between Showcase → Dark → Light via the header toggle. When the CDN is unavailable, the viewer falls back to the existing dark/light two-way toggle with no visual regression

Removed #

• Schema Search sidebar panel removed — The dedicated Schema Search webview panel has been removed. Use VS Code's built-in tree filter (funnel icon or type-to-filter) in the Database panel instead. The Global Search command in Drift Tools remains available for cross-table search

Changed #

• Database tree shows column count — Table items now display "3 cols, 42 rows" instead of just "42 rows", making table shape visible at a glance
• Command Palette titles cleaned up — All 106 commands now use VS Code's category field ("Saropa Drift Advisor") instead of embedding the prefix in each title, following VS Code extension conventions
• All command output now uses webview panels — Ten commands that previously used the VS Code top bar (quick picks, input boxes, info messages) for displaying results or collecting multi-step input now open dedicated webview panels instead. Index suggestions, anomaly detection, and performance baselines render in rich sortable/filterable tables. Annotation, compare rows, data breakpoint, snapshot changelog, import dataset, and export dataset commands now collect all inputs in a single form view with Ctrl+Enter support, replacing sequential top-bar prompts
• Tables heading now collapses sidebar horizontally — Clicking the "Tables" heading in the sidebar collapses the entire sidebar panel to the left (same as the header chevron button) instead of vertically collapsing the table list upward

Fixed #

• Showcase theme now activates reliably — The enhanced CSS load detection used a 3-second timeout that nulled the onload callback, permanently locking out the showcase theme if the CDN was slightly slow or the browser never fired onload for <link> elements (VS Code webview, some WebKit builds). Replaced with an idempotent markEnhancedReady() function called by both onload and a polling fallback that checks link.sheet every 250ms for up to 10 seconds
• Debug server now survives Flutter hot restart without a SocketException — previously required a full cold restart to reconnect the VS Code extension
• Anomaly scanner no longer flags empty strings in nullable text columns — if the schema says the field is optional, empty strings are a valid design choice, not a data quality warning
• "Run CREATE INDEX Now" quick fix removed — the action always failed because the debug server only allows read-only SQL; the "Copy CREATE INDEX SQL" action remains and is now the preferred quick fix for all index suggestions

---

Dashboard tab renamed for clarity, and web UI assets now load reliably on Flutter Windows desktop. log

Changed #

• Dashboard tab renamed to "Saropa Drift Dashboard" — The VS Code webview tab previously showed the generic title "Dashboard"; it now displays "Saropa Drift Dashboard" for clarity when multiple editor tabs are open.

Fixed #

• Web UI blank on Flutter Windows desktop — The web viewer's CSS and JS failed to load on Flutter desktop apps because the asset resolver couldn't locate the package directory. Now uses multiple resolution strategies with in-memory caching, so the web UI loads reliably on all Flutter platforms.

• Server diagnostic messages invisible in Flutter console — [SDA] diagnostic messages now appear in the standard Flutter run console and IDE debug terminal, not just Dart DevTools.

Maintenance

• Asset resolution internals — Four resolution strategies now run in sequence: (1) Isolate.resolvePackageUri with an asset-existence probe to reject pub-cache paths, (2) .dart_tool/package_config.json ancestor walk to locate the declared rootUri, (3) ancestor walk from Directory.current, and (4) ancestor walk from Platform.resolvedExecutable. Assets are cached in memory on first resolution so subsequent requests skip disk I/O.

• Error logger dual output — DriftDebugErrorLogger log and error callbacks now call both developer.log() and print(), and log exact file paths probed with existence and byte counts.

---

Eliminates false-positive diagnostics across index, FK, empty-table, and anomaly checks, and fixes blank Web UI caused by MIME-blocked CDN fallback. log

Fixed #

• missing-fk-index false positive on audit timestamp and _id columns — The missing-fk-index diagnostic fired on created_at, updated_at, and _id-suffixed columns that have no foreign key relationship, labeling them "FK column" in the Problems panel. Index suggestions from the server's three heuristics (true FK, _id suffix, date/time suffix) now produce distinct diagnostic codes: missing-fk-index (Warning) for actual FK columns, missing-id-index (Information) for _id columns, and missing-datetime-index (Information) for date/time columns. Each code has an accurate message and all three retain Copy/Run SQL quick-fix actions.

• empty-table false positive on legitimately empty tables — The empty-table data-quality diagnostic fired on every table with 0 rows, flooding the Problems panel with false positives in fresh or development databases. Empty tables are a valid state (user-data, cache, static-data tables all start empty), so the diagnostic has been removed entirely. The empty-table code, its code-action quick fixes (Generate Seed Data / Import Data), and its entry in the diagnostic code registry have all been deleted.

• Anomaly scanner false positive on boolean columns with skewed distributions — The potential_outlier numeric heuristic fired on boolean columns stored as INTEGER 0/1 when the true-percentage was low (e.g., 9% → max(1) > avg(0.09) × 10). Boolean-typed columns (BOOLEAN, BOOL, BIT) are now excluded from numeric outlier detection, and a binary-domain guard (min == 0 && max == 1) catches Drift BoolColumn values stored as INTEGER.

• no-foreign-keys false positive on intentionally isolated tables — The no-foreign-keys best-practice diagnostic fired on every table that had an id column and at least one other column but no FOREIGN KEY constraints, producing dozens of false positives on tables intentionally designed without FKs (import caches, config stores, static data, audit logs). The check now only flags tables that have _id columns matching a known table name (e.g. user_id when a users table exists) but lack FK constraints — catching genuine "forgot references()" mistakes. Tables referenced by other tables via inbound FKs are also skipped, since they already participate in the relational graph.

• missing-table-in-db false positive on tables with consecutive uppercase letters — dartClassToSnakeCase() grouped acronyms as single tokens (e.g. DC → dc), but Drift splits every uppercase letter individually (DC → d_c). Tables like SuperheroDCCharacters were flagged as missing even though they existed under the Drift-generated name superhero_d_c_characters. The converter now matches Drift's per-letter splitting.

• Anomaly scanner false positives on nullable columns — _detectNullValues() flagged NULLs in columns declared .nullable(), producing up to 13 spurious warnings per table. NULL detection now only scans NOT NULL columns, where NULLs indicate genuine constraint violations (data corruption, direct SQL inserts, failed migrations). Severity changed from threshold-based warning/info to always error.

• Web UI blank for pub.dev consumers — CDN fallback silently killed by MIME mismatch — When the debug server could not find web assets on disk (typical for separate projects using the package from pub.dev), it returned 404 with Content-Type: text/plain. Combined with Dart's default X-Content-Type-Options: nosniff header, both Firefox and Chrome MIME-blocked the response, which suppressed the <link>/<script> onerror callback. The multi-CDN fallback chain never fired — the page loaded blank with no CSS or JS. The 404 path now uses the expected content type (text/css or application/javascript) so browsers do not MIME-block it; the 404 status alone triggers onerror reliably.

---

NOTE: This changelog version was corrupted - it may not have been deployed

Fixed #

• Web UI blank in Firefox — CDN fallback never fired after local 404 — The onerror attribute on <link> and <script> elements does not reliably fire in Firefox when the server returns HTTP 404 with the correct MIME type (text/css, application/javascript). The multi-CDN fallback chain (_sda_fb) was dead code in practice. CSS and JS are now inlined directly into the HTML response when the package root is resolved on disk (zero extra requests, works offline). When local files are unavailable, the HTML references jsDelivr CDN URLs directly via a fetch-based JS loader instead of the broken onerror mechanism.

Changed #

• Loading overlay shows startup diagnostics — The loading screen now displays the package version, asset source (local/CDN), and per-asset load status instead of an uninformative "Loading…" message. Errors use distinct red styling.

---

Fixes silent command failures and missing user feedback, adds annotation previews and removal commands, and moves bookmarks to the tree toolbar. log

Fixed #

• Go to Column/Table Definition did nothing with no feedback — tree-view context-menu commands silently swallowed errors and gave no progress indication. Now shows a progress notification during search, surfaces errors via toast, and falls back to opening the table class when the specific column getter pattern isn't matched. Also excludes .g.dart / .freezed.dart from the search for faster results.

• pub.dev publish failed for v2.14.0 — The pubspec screenshots path was changed from assets/banner_v2.png to extension/icon_1024.png, but .pubignore excludes the entire extension/ directory. pub.dev rejected the upload with "Screenshot extension/icon_1024.png is missing from archive." Restored the screenshot path to assets/banner_v3.png, which lives in the non-excluded assets/ directory.

• Query Cost command failed to register — driftViewer.analyzeQueryCost was registered in both health-commands and query-cost-commands, causing a "command already exists" error on every activation. Removed the duplicate proxy registration.

• Warning toasts had no actionable buttons — 11 showWarningMessage calls told users to check settings, docs, or output channels but gave no way to get there. Every warning that references a destination now includes a one-click button (Retry, Open Settings, View Docs, Open Output, etc.).

• Annotation creation gave no user feedback — After completing the annotation quick-pick and text input, the command silently returned with no toast, no tree change visible if disconnected, and no indication the annotation was saved. All annotation commands now show a confirmation info message (e.g. "Annotation added to column 'users.email'.").

Changed #

• Annotation preview in Database Explorer tree — Tree items now show the actual annotation emoji and note text (truncated at 40 chars) instead of the old generic "· 1 note" / "· 📌" placeholders. Multiple annotations show "+N more" suffix.

• Bookmarks button moved to tree toolbar — The "Open Bookmarks" command is now a visible $(bookmark) icon in the Database Explorer title bar instead of buried in the ... overflow menu.

Added #

• Remove annotations from tree context menu — Right-click a table or column → "Remove Annotations" with a modal confirmation. Table removal clears all annotation kinds (table, column, row) in a single pass.

• Clear All Annotations command — Available in the Database Explorer ... menu. Confirms before wiping all annotations.

---

Stops false-positive slow-query warnings from internal analytics, fixes connection errors in non-Drift projects, and makes the web UI much more reliable when assets can't be found locally. log

Fixed #

• False-positive slow-query diagnostics — Internal analytics queries (anomaly detection, index suggestions, size analytics) were being reported as slow user queries in the Performance panel. These internal queries are now excluded from performance data.

• Connection-error diagnostic firing on non-Drift workspaces — The extension no longer tries to connect to a debug server in projects that don't use Drift.

• Notification messages drop redundant "Saropa Drift Advisor:" prefix — Warning and error toasts no longer start with the extension name; VS Code already shows the source.

• Web UI blank when local assets unavailable — When the server couldn't find CSS/JS on disk (common for pub.dev consumers), the web viewer loaded blank with no error. Now falls back to CDN automatically, and shows a clear error message if all sources fail.

Changed #

• Connection-error diagnostic downgraded to Warning — Connection errors are now Warning severity (was Error), reflecting that a missing server is an operational state, not a code defect. Quick fix actions: "Retry Connection", "Don't Show Connection Warnings", and "Open Connection Settings."

Added #

• Loading overlay with error state — A loading screen shows "Loading Drift Advisor..." until assets load. If loading fails, it updates to a clear error message with instructions.

Maintenance

• In-memory asset cache — style.css and app.js are read once and served from memory, eliminating per-request disk I/O.

• Multi-CDN fallback chain — CSS and JS onerror handlers try version-pinned jsDelivr (@v{version}), then @main. All sources exhausted dispatches a sda-asset-failed custom event.

• Asset MIME mismatch fix — _sendWebAsset no longer sends HTTP 200 with text/plain when file-read fails; failures fall through to a clean 404 so onerror CDN fallback fires. _resolvePackageRootPath validates that the resolved root contains web assets before accepting it.

---

Fixes several broken commands and stuck webviews, and removes duplicate Quick Actions from the Database tree. log

Changed #

• Removed duplicate Quick Actions from Database tree — The "Quick Actions" collapsible group in the Database Explorer duplicated every command already in the "Drift Tools" panel. Removed the redundant group so tool commands appear only in Drift Tools.

Fixed #

• "Browse all tables" link in Schema Search did nothing — Browse results were being overwritten by server-discovery updates. Now browse-all results persist until the user types, changes filters, disconnects, or encounters an error.

• 11 commands missing from Command Palette — disableDiagnosticRule, clearRuntimeAlerts, copySuggestedName, and 8 other commands now appear in the Command Palette as expected.

• Schema Search stuck on "Waiting for the extension" forever — The Schema Search panel now initializes reliably instead of silently dropping the first connection message.

• Query Cost Analysis command failed to register — The command silently failed with only a warning toast; now registers correctly.

• Web UI blank when running from the example app — Asset resolution failed in the example app context, serving 404s that browsers blocked silently. Now resolves assets correctly.

Maintenance

• Exhaustive command-wiring tests — Two new tests verify that every command declared in package.json is registered at activation (forward check) and that every registered command is declared (reverse check). Any future wiring breakage now fails the test suite before publication.

• Example app upgraded — The example's landing screen now displays a compact status header with server state and URL, a table overview with row counts, and a recent-posts list.

---

Fixes the invisible server-startup banner on Android (third regression) and makes disconnected sidebar buttons actually clickable. log

Fixed #

• Server startup banner invisible on Android (third regression) — Commit 086152f replaced print() with ctx.log() to satisfy avoid_print, routing the banner through developer.log() which does not produce I/flutter lines on Android. The server was starting but the user saw no output. Restored print() with lint ignores and an anchored comment explaining why print() is the only correct choice. Server startup errors (e.g. port in use) are now also printed visibly instead of only going through developer.log().

• VS Code: buttons do nothing when disconnected — The Database tree returned an empty array when no server was connected, forcing VS Code to show a viewsWelcome overlay with markdown command: links. These links silently fail in some VS Code forks/versions — no output, no toast, no error. The tree now always returns real TreeItem rows with .command properties (Retry Discovery, Diagnose, Troubleshooting, Connection log, Select Server, etc.) so every action is a clickable tree item that works reliably in all hosts.

Changed #

• Discovery output log is much more verbose — Every scan cycle now logs its start, result (ports found or empty scan count), and when the next scan is scheduled. Previously only state transitions were logged, leaving long silent gaps during the 3s→30s search/backoff cycle.

---

Fixes a Windows-only hang where fetch never completes, permanently locking the Database tree. log

Fixed #

• Database tree permanently stuck on Windows — On some Windows builds, a network request could hang forever due to a Node.js bug, locking the Database tree on "Could not load schema" with no recovery. Added multiple safety timeouts so the tree always recovers, even if the underlying bug is triggered.

---

Fixes a batch of reliability issues — stuck Database tree, broken mutation tracking — and polishes sidebar loading states. log

Fixed #

• Database tree stuck on “Could not load schema” after discovery — The tree could silently drop concurrent refresh calls during server discovery, leaving it permanently stale. Refresh calls are now queued so the tree always loads when a server is found.

• Web UI failed on Flutter iOS/Android — Asset requests crashed on mobile embedders. The server now handles this gracefully and falls back to CDN as expected.

• ”Open URL” on server-detected toast didn't select the server — Choosing Open URL when discovery finds a Drift debug server now also selects that host:port as the active server. Previously the sidebar could stay on the wrong port or none.

• Mutation tracking not detecting changes — INSERT/UPDATE/DELETE statements were not being classified correctly, so mutation tracking and live updates were silently broken. Now works reliably.

• App stalling with multiple connected clients — Idle mutation long-poll timeouts were flooding the VM service log, which could stall the app. Idle timeouts are now silent.

Improved #

• Tables sidebar loading — While the table list loads, shimmer skeleton rows appear under the Tables heading. Failed loads show an error message in the same block.

• Database sidebar when schema fails to load — The explorer now lists a warning row and troubleshooting commands as clickable tree items (Refresh, Diagnose, Troubleshooting, Select Server, etc.) instead of relying on markdown links that some editors ignore.

Maintenance

• Missing command declarations — commitPendingEdits and editTableData were registered in source but not declared in contributes.commands.

• Mutation SQL regex fix — INSERT/UPDATE/DELETE patterns used literal \\s / \\b in raw Dart strings instead of regex character classes.

• doc/API.md — Run SQL from links — Documents the web viewer GET /?sql= deep link alongside POST /api/sql, with query-parameter reference and stable anchor IDs.

---

Clearer table row counts, inline table column definitions, a more polished Size analytics panel, and a lighter Dart package. The VS Code extension adds offline Database tree from persisted schema, sidebar-to-Dart navigation, and a command to scan Drift table definitions without a connected server. log

Changed #

• Smaller Dart package footprint — The package no longer bundles duplicate web UI assets as Dart string constants. When local assets are unavailable, the web viewer loads from CDN automatically — no change to your workflow, just a smaller dependency.

Improved #

• Table definition on table tabs (debug web UI) — Opening a table shows a Table definition block above the query builder and grid: each column’s SQLite type plus PK / NOT NULL flags (from schema metadata). The same block appears when Search uses schema and table data (“both”) and a table is loaded.

• Web UI table row counts — In the sidebar, Tables browse grid, Search table picker, and Import dropdown, counts appear as comma-separated numbers in parentheses (e.g. (1,643)), without the word “rows”; numbers use muted color and align to the right beside the table name.

• Size tab (debug web UI) — Summary cards use comma-grouped numbers where appropriate; the Pages card shows total bytes with a dimmed page_count × page_size line; index names use smaller type; the Columns column is right-aligned. Table names in the breakdown link to open that table in a tab. Revisiting the Size tab in the same session reuses the last successful analyze (no automatic re-fetch); Analyze still refreshes on demand. Read-only metrics have hover tooltips (including journal mode / wal and PRAGMA-backed fields).

• Busy spinners on slow actions (debug web UI) — Primary and toolbar buttons that wait on the server (e.g. Size/Index/Health analyze, Perf update, Run SQL / Explain, migration preview, share, import, query builder run) show an inline spinner beside the progress label; existing error handling and disabled-state behavior are unchanged.

• Ask in English (debug web UI) — Replaces the full-width bright text row with an Ask in English… control that opens a modal: multiline question, dark-themed Generated SQL (preview) that updates as you type (debounced), and Use to copy into the main SQL editor. Cancel, Escape, or the backdrop close without changing the main editor. NL conversion errors stay in the modal so they do not replace SQL run errors below the editor.

• Sidebar panel toggle (debug web UI) — Header Sidebar control collapses the full left column (search + table list) so the main panel can use the full width; collapsed state is stored in localStorage. Removed the redundant sidebar line that only pointed users to the Export tab (export downloads are unchanged on that tab).

• Header chrome (debug web UI) — Shorter mask and live-status labeling where it reduces clutter; theme button tooltip names the mode you switch to on click.

VS Code extension #

• Schema Search panel (disconnected) — Now shows troubleshooting actions (Open in Browser, Retry, Refresh sidebar UI, Forward Port, Select Server, etc.) instead of a blank welcome overlay. Distinguishes “no saved schema in this workspace” vs “saved schema available.”

• Offline Database tree — New setting driftViewer.database.allowOfflineSchema (default on): when the server is unreachable, the tree repopulates from last-known persisted schema; status shows “Offline — cached schema.”

• Go to Dart definitions from sidebar — Context menu and Schema Search result clicks open the Drift table/column definition in the workspace; falls back to revealing the table in the Database tree.

• Scan Dart schema definitions (offline) — New command Saropa Drift Advisor: Scan Dart Schema Definitions lists Drift Table classes, columns, keys, and indexes from workspace .dart files. No debug server required. Setting driftViewer.dartSchemaScan.openOutput controls auto-opening the output channel.

• Schema Search when “connected” but schema missing — Schema Search keeps the help banner visible (Retry, Diagnose, Scan Dart sources, etc.) until the Database tree has actually loaded table data.

• Schema Search webview readability — Always-visible header, fallback colors when theme variables are missing, visible search field borders, and smoother startup transitions.

---

Sidebar stays actionable when HTTP/VM says “connected” but the schema tree cannot load, and Schema Search recovers if the webview script never reaches the ready handshake. log

Fixed #

• Blank Database section with a false “connected” state — driftViewer.serverConnected could be true (discovery or VM) while health / schemaMetadata failed, so the tree had no roots and the disconnected welcome stayed hidden. The extension now sets driftViewer.databaseTreeEmpty from the tree provider and shows a dedicated viewsWelcome with refresh, diagnose, and help links until the tree loads.

• Schema Search panel stuck empty — The host now forces delivery of connection state after a short timeout when the embedded script never posts ready, the script wraps init in try/finally so ready always fires, and the webview registers a dispose handler for the timer. The wildcard * activation event was removed (use onStartupFinished and explicit hooks) to avoid invalid-manifest behavior in some hosts.

• Refresh / About toolbar commands during activation — driftViewer.aboutSaropa and driftViewer.refreshTree register immediately after bootstrap and tree creation so title-bar actions work even if a later activation step fails before the bulk command registration pass.

• Schema Search view visibility — The Schema Search sidebar entry is no longer hidden when driftViewer.enabled flips late; it stays declared like the Database view so the webview can render during startup.

---

No-blank sidebar startup fallback and safer command availability during activation. log

Fixed #

• No-blank sidebar startup fallback — Activation now includes startup/view/workspace hooks so connection commands register before users click them, and disconnected welcome text no longer depends on pre-set context keys. Schema Search also has a fallback welcome block with direct actions (Refresh UI, Retry, Diagnose, Troubleshooting, web help), preventing empty panes during activation races.

• Database header icons no longer fail in partial activation contexts — About / About Saropa now resolve extension file paths via extensionUri with a safe fallback to the hosted docs URL, so the icon commands do not throw when path metadata is unavailable.

---

Faster disconnect detection, batch apply for pending cell edits with foreign-key–aware ordering, bulk-edit panel, and authenticated server discovery. log

Fixed #

• Schema Search disconnected banner never appeared — The banner now shows reliably when the server is not connected, with controls disabled until connection is confirmed.

• Cell update numeric parsing now fails safely — Invalid numeric values now return clear validation errors instead of risking parse exceptions.

Added #

• Batch apply pending data edits — New command Apply Pending Edits to Database sends all pending edits in a single transaction. Requires writeQuery to be configured.

• Bulk edit panel — Edit Table Data opens a dashboard to preview SQL, apply, undo, or discard pending edits. Available from the Database table context menu.

• FK-aware apply order — Pending edits are automatically ordered: deletes (child tables first), then updates, then inserts (parents first), respecting foreign key relationships.

Improved #

• Less SQLite contention — Server discovery and schema fetching are much lighter on your database — fewer queries, sequential prefetch, and a 90s schema cache TTL.

• Authenticated discovery — Port scans now pass the Bearer auth token, so discovery works when the debug server requires authentication.

Changed #

• Faster disconnect detection — Lost server is detected in ~20s (was ~45s).

• Quieter discovery log — Suppressed noisy per-cycle port scan messages.

Maintenance

• Batch transaction failure logging — Rollback and transaction exceptions are both logged for /api/edits/apply diagnostics.

• VM Service batch apply + health — ext.saropa.drift.applyEditsBatch and getHealth now mirror HTTP endpoint capabilities.

---

Fixes web UI failing on Flutter emulators and Schema Search getting stuck on load. log

Fixed #

• Web UI blank on Flutter emulators — On Android/iOS emulators the web viewer's CSS and JS failed to load. The server now serves assets from memory when the filesystem is unreachable.

• Schema Search panel stuck on loading indicator — The panel could silently drop its first connection message and never leave the loading state. Now uses a ready-handshake so state is always delivered.

• Drift Tools "no data provider" on activation — The Drift Tools sidebar section could fail to appear if another registration step threw first. Now always registers reliably.

Improved #

• Troubleshooting: Schema Search diagnostics — "Diagnose Connection" output now includes Schema Search state with actionable warnings. The Troubleshooting panel has a new section for "Schema Search panel stuck on loading indicator."

Maintenance

• Published package missing web UI assets — .pubignore contained an unanchored web/ pattern that excluded assets/web/ from the published package. Fixed by anchoring to /web/ (root only).

• Schema Search registered before command wiring — WebviewViewProvider is now created in setupProviders instead of inside registerAllCommands, preventing permanent loading indicators if command registration fails.

---

More reliable connection UI and Schema Search, plus web UI no longer errors during flutter test. log

Fixed #

• Web UI assets error during flutter test — The debug server no longer returns HTTP 500 when running under the test VM; falls back to discovering the package root from the working directory.

Improved #

• Connection UI and Schema Search resilience — Sidebar connection state is now more accurate, combining HTTP discovery and VM Service signals. Schema Search gains connection labels, action links (Output log, Retry, Diagnose, Refresh UI), and auto-retry on transient failures. New commands: Show Connection Log, Refresh Connection UI, Diagnose Connection. Discovery is less likely to drop a server during brief interruptions.

Maintenance

• Publish script: working-tree prompt — Clearer messaging about uncommitted changes, per-target git add scope, and analysis-only mode.

• Publish script: version sync — Dart analysis now auto-syncs server_constants.dart with pubspec.yaml version before format/tests.

---

Mutation Stream with column-value filtering, merged issues API for Saropa Lints integration, and web UI assets now load locally with CDN fallback. log

Added #

• Mutation Stream (VS Code) — Added a semantic event feed openable from the Drift Tools status menu / Database → Quick Actions, with column-value filtering (schema column dropdown + match value).

• Merged issues endpoint — Index suggestions and data-quality anomalies are now available in a single request via GET /api/issues. Enables Saropa Lints and other integrations to fetch all issues at once.

• Health capabilities — Health endpoint now includes a capabilities array so clients can detect feature support and fall back gracefully on older servers.

Improved #

• Mutation Stream UX — Debounced filter inputs, added a schema-loading placeholder, and made pause/resume feel immediate.

Fixed #

• Web UI loaded from CDN even when local assets were available — The viewer now loads CSS/JS from the debug server first (works offline), falling back to CDN only on failure.

• About / About Saropa / Save Filter "command not found" — These commands now work even before a Dart file has been opened.

Maintenance

• Pipeline: saropa_lints report colocation — Lint scan report is now copied into the same reports/YYYYMMDD/ folder as the run's summary report.

• VM Service getIssues RPC — ext.saropa.drift.getIssues returns the same merged issues list as the HTTP endpoint.

• doc/API.md — Documented Issues endpoint, issue object fields, and health capabilities.

• Log Capture integration internals — Session-end flow deduplicated; shared helpers exported from bridge module.

---

Table tabs, self-contained Search tab, collapsible sidebar, ~97% query spam reduction, shared schema cache, and zero runtime dependencies. log

Fixed #

• Commands silently failed with no feedback — Every sidebar and welcome-view button now shows a user-facing error or warning toast instead of swallowing failures silently.

• Search tab performance issues — Fixed a recursive fetch loop (4 duplicate requests per count update), filter re-fetching on every keystroke (now uses cached data), and shared pagination state bleeding between Search and Tables tabs.

• Search toolbar button didn't open the Search tab — The toolbar Search button now correctly opens the Search tab before focusing its input.

• ER diagram columns only visible in first table — Column text in the diagram was pushed off-screen for every table except the first. Now renders correctly.

• Schema Search hung on "Searching…" forever — Browse and search operations now have bounded timeouts. A "Server not connected" banner and Retry button appear on failure.

• Table names with special characters crashed — Table names containing quotes, brackets, or backslashes no longer cause DOMException errors.

• Stale tabs after database changes — When a table is dropped or renamed, its tab is automatically closed instead of becoming an orphaned error state.

Changed #

• NULL cell indicator — Table cells with NULL database values now display a dimmed, italic "NULL" label instead of blank space, matching DBeaver/DataGrip/pgAdmin convention.

• Zero runtime dependencies — Removed the crypto dependency. Apps no longer pull in any third-party packages, reducing install size and attack surface.

Added #

• Web UI: pin tables to top of sidebar — Hovering a table in the sidebar reveals a push-pin icon. Clicking it pins the table to the top of the list; clicking again unpins it. Pinned state persists via localStorage and auto-prunes stale entries when tables are dropped. Accessible: keyboard focus ring, aria-pressed toggle, visible on touch devices.

• Web UI: table tabs — Clicking a table name (sidebar or browse panel) opens it in its own closeable tab. Multiple table tabs can be open simultaneously; clicking an already-open table switches to its tab. The Tables tab now shows a browse-all grid of clickable table cards with row counts.

• Web UI: collapsible sidebar table list — The "Tables" heading in the sidebar is now a toggle that collapses/expands the table list. State persists across page reloads via localStorage. Supports keyboard activation (Enter/Space) and ARIA attributes.

• Web UI: self-contained Search tab — The Search tab now has its own inline controls (table picker, search input, scope selector, row filter) and loads data independently from the Tables tab. Includes debounced input handling and match navigation.

• Web UI: Size tab Rows column — The Rows column in the Size analytics table now has a minimum width and nowrap to prevent the bar chart from squeezing the row count number.

• Extension: schema cache and performance options — Shared in-memory schema cache so tree, Schema Search, ER diagram, and other features reuse one fetch. New settings: driftViewer.schemaCache.ttlMs (cache TTL), driftViewer.schemaCache.persistKey (stale-while-revalidate on startup), driftViewer.database.loadOnConnect (lazy tree loading), driftViewer.lightweight (skip badges and auto-capture for low-powered machines), driftViewer.schemaSearch.timeoutMs and driftViewer.schemaSearch.crossRefMatchCap.

• Web UI: connection banner improvements — When the server is unreachable, the banner now shows a live countdown ("Next retry in Xs"), the current retry interval (e.g. "Retrying every 5s"), attempt count, and "(max interval)" at 30s. A Retry now button triggers an immediate health check and resets backoff; a 1s ticker keeps the countdown accurate. Duplicate in-flight health checks are avoided so Retry does not race with the automatic heartbeat.

Improved #

• Web UI: accessibility — Proper heading landmarks, semantic buttons, and :focus-visible styles on sidebar toggle and search toolbar buttons (WCAG 2.4.7).

• ~97% query spam reduction — For a 40-table database, a refresh cycle drops from ~160 queries to ~2. Eliminates massive "Drift: Sent" console spam when logStatements is enabled.

• Search input debounce — Search and filter inputs are now debounced to prevent floods of network requests on large tables.

Maintenance

• SDK constraint raised to >=3.9.0 <4.0.0 — Enables Dart 3.6 digit separators, Dart 3.7 wildcard variables and tall formatter, and Dart 3.8 null-aware collection elements.

• Dart 3.8 null-aware map elements — QueryTiming.toJson() uses 'error': ?error syntax.

• .firstOrNull simplifications — Replaced manual empty-check patterns across multiple files.

• Digit separators — Applied to numeric literals for readability.

• Dart 3.7 tall formatter — All 47 Dart files reformatted.

• New lints enabled — unnecessary_underscores, prefer_digit_separators.

• Dev dependencies — saropa_lints ^9.5.2 → ^9.8.1, test ^1.25.0 → ^1.30.0.

• Extracted shared createClosableTab() helper — Eliminates ~35 lines of duplicated DOM construction.

• Server discovery error logging — Port scan failures now logged to the Output channel.

• Troubleshooting panel message routing — Webview button actions now surface rejected command promises.

---

For older versions (2.5.0 and prior), see CHANGELOG_ARCHIVE.md.