# qwtel/sqlite-viewer-vscode architecture

> Architecture diagram of the GitHub repository qwtel/sqlite-viewer-vscode, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/qwtel/sqlite-viewer-vscode
- Repository: https://github.com/qwtel/sqlite-viewer-vscode

## Overview

SQLite Viewer is a VS Code extension for opening and inspecting SQLite files, including in VS Code for Web. The main workflow is file selection, custom-editor registration, document creation, database import into a worker, and presentation in the viewer UI. The README also documents virtualized scrolling, sorting, filtering, theme integration, and read-only/cached behavior; licensing commands are a separate capability. The core and webview implementation directories are present in the tree but were not sampled, so their internal responsibilities and links are shown only at directory level where documented or left unverified.

Main entry points: [`src/webWorker.ts`](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/webWorker.ts) (Worker Setup), [`src/sqliteEditorProvider.ts`](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/sqliteEditorProvider.ts) (Custom Editor Provider), [`src/extension.ts`](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/extension.ts) (Extension Activation), [`src/sqliteDocument.ts`](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/sqliteDocument.ts) (SQLite Document)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_integration["VS Code Integration"]
  node_extension["Extension Activation<br/>[extension.ts]"]
  node_commands["Extension Commands<br/>[commands.ts]"]
  node_editor_provider["Custom Editor Provider"]
  node_telemetry["Telemetry<br/>[extension.ts]"]
end

subgraph group_document["Document Lifecycle"]
  node_document_model["SQLite Document<br/>[sqliteDocument.ts]"]
  node_document_helpers["Document Utilities<br/>[util.ts]"]
end

subgraph group_runtime["Database Runtime"]
  node_worker_setup["Worker Setup<br/>[webWorker.ts]"]
  node_worker_transport["Worker Transport<br/>[worker_threads.ts]"]
  node_worker_runtime["Database Worker<br/>[worker.ts]"]
  node_core_db["SQLite Core"]
  node_worker_bundle["Worker Interface<br/>[workerBundle.ts]"]
end

subgraph group_viewer["Viewer Experience"]
  node_webview_transport["Webview Bridge<br/>[util.ts]"]
  node_viewer_ui["Viewer UI"]
end

subgraph group_licensing["Licensing"]
  node_license_service["License Service"]
  node_license_commands["License Commands<br/>[commands.ts]"]
end

node_user(("User"))
node_sqlite_file["SQLite File"]
node_vscode["VS Code"]

node_user -->|"opens file"| node_vscode
node_vscode -.->|"activates"| node_extension
node_extension -->|"registers editors"| node_editor_provider
node_extension -->|"registers commands"| node_commands
node_vscode -.->|"routes file"| node_editor_provider
node_editor_provider -->|"creates document"| node_document_model
node_document_model -->|"creates worker"| node_worker_setup
node_worker_setup -->|"selects worker API"| node_worker_transport
node_worker_setup -->|"imports database"| node_core_db
node_worker_setup -->|"reads file bytes"| node_sqlite_file
node_worker_setup -->|"returns interface"| node_worker_bundle
node_document_model -->|"uses worker interface"| node_worker_bundle
node_document_model -->|"uses utilities"| node_document_helpers
node_editor_provider -->|"uses webview collection"| node_webview_transport
node_editor_provider -.->|"serves viewer"| node_viewer_ui
node_user -.->|"inspects database"| node_viewer_ui
node_viewer_ui -.->|"uses themed UI"| node_vscode
node_commands -->|"requests registration"| node_license_service
node_extension -.->|"reports events"| node_telemetry

click node_extension "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/extension.ts"
click node_commands "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/commands.ts"
click node_editor_provider "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/sqliteEditorProvider.ts"
click node_document_model "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/sqliteDocument.ts"
click node_document_helpers "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/util.ts"
click node_worker_setup "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/webWorker.ts"
click node_worker_transport "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/o/worker_threads.ts"
click node_worker_runtime "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/worker.ts"
click node_core_db "https://github.com/qwtel/sqlite-viewer-vscode/tree/master/sqlite-viewer-core"
click node_worker_bundle "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/workerBundle.ts"
click node_webview_transport "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/util.ts"
click node_viewer_ui "https://github.com/qwtel/sqlite-viewer-vscode/tree/master/sqlite-viewer-vscode-page"
click node_license_commands "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/commands.ts"
click node_telemetry "https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/extension.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_extension,node_commands,node_editor_provider,node_telemetry,node_user toneBlue
class node_document_model,node_document_helpers,node_sqlite_file toneAmber
class node_worker_setup,node_worker_transport,node_worker_runtime,node_core_db,node_worker_bundle toneMint
class node_webview_transport,node_viewer_ui toneRose
class node_license_service,node_license_commands,node_vscode toneIndigo
```

## Components

### VS Code Integration

- [Extension Activation](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/extension.ts): `src/extension.ts`
- [Extension Commands](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/commands.ts): `src/commands.ts`
- [Custom Editor Provider](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/sqliteEditorProvider.ts): `src/sqliteEditorProvider.ts`
- [Telemetry](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/extension.ts): `src/extension.ts`

### Document Lifecycle

- [SQLite Document](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/sqliteDocument.ts): `src/sqliteDocument.ts`
- [Document Utilities](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/util.ts): `src/util.ts`

### Database Runtime

- [Worker Setup](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/webWorker.ts): `src/webWorker.ts`
- [Worker Transport](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/o/worker_threads.ts): `src/o/worker_threads.ts`
- [Database Worker](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/worker.ts): `src/worker.ts`
- [SQLite Core](https://github.com/qwtel/sqlite-viewer-vscode/tree/master/sqlite-viewer-core): `sqlite-viewer-core`
- [Worker Interface](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/workerBundle.ts): `src/workerBundle.ts`

### Viewer Experience

- [Webview Bridge](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/util.ts): `src/util.ts`
- [Viewer UI](https://github.com/qwtel/sqlite-viewer-vscode/tree/master/sqlite-viewer-vscode-page): `sqlite-viewer-vscode-page`

### Licensing

- **License Service**
- [License Commands](https://github.com/qwtel/sqlite-viewer-vscode/blob/master/src/commands.ts): `src/commands.ts`

### Other components

- **User**
- **SQLite File**
- **VS Code**

## Connections

- User → VS Code: opens file (evidence: `README.md`)
- VS Code → Extension Activation: activates
- Extension Activation → Custom Editor Provider: registers editors (evidence: `src/extension.ts`)
- Extension Activation → Extension Commands: registers commands (evidence: `src/extension.ts`)
- VS Code → Custom Editor Provider: routes file
- Custom Editor Provider → SQLite Document: creates document (evidence: `src/sqliteEditorProvider.ts`)
- SQLite Document → Worker Setup: creates worker (evidence: `src/sqliteDocument.ts`)
- Worker Setup → Worker Transport: selects worker API (evidence: `src/webWorker.ts`)
- Worker Setup → SQLite Core: imports database (evidence: `src/webWorker.ts`)
- Worker Setup → SQLite File: reads file bytes (evidence: `src/webWorker.ts`)
- Worker Setup → Worker Interface: returns interface (evidence: `src/webWorker.ts`)
- SQLite Document → Worker Interface: uses worker interface (evidence: `src/sqliteDocument.ts`)
- SQLite Document → Document Utilities: uses utilities (evidence: `src/sqliteDocument.ts`)
- Custom Editor Provider → Webview Bridge: uses webview collection (evidence: `src/sqliteEditorProvider.ts`)
- Custom Editor Provider → Viewer UI: serves viewer
- User → Viewer UI: inspects database
- Viewer UI → VS Code: uses themed UI
- Extension Commands → License Service: requests registration (evidence: `src/commands.ts`)
- Extension Activation → Telemetry: reports events (evidence: `src/extension.ts`)
