# oldgeorsk/dlsite-management-tool architecture

> Architecture diagram of the GitHub repository oldgeorsk/dlsite-management-tool, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/oldgeorsk/dlsite-management-tool
- Repository: https://github.com/oldgeorsk/dlsite-management-tool

## Overview

DLsite Tool is a local web application for cataloguing audio-work folders, enriching records with DLsite metadata and metrics, and searching, analyzing, and exporting the library. The main workflow runs from the browser through the local server: scan a selected directory, persist discovered works, optionally fetch metadata or refresh metrics, then filter, inspect statistics, and export. The graph includes Everything-based path assistance and the job-progress layer. Some backend wiring is supported by the server’s indexed references rather than shown source excerpts; those links are cited to that excerpt or to the README’s documented workflow.

Main entry points: [`server.py`](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/server.py) (Local web server), [`dlsite_tool/models.py`](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/models.py) (Work records), [`static/app.js`](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/static/app.js) (Workbench UI), [`static/stats.js`](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/static/stats.js) (Overview UI)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web interface"]
  node_workbench["Workbench UI<br/>[app.js]"]
  node_overview_ui["Overview UI<br/>[stats.js]"]
  node_server["Local web server<br/>[server.py]"]
  node_jobs["Background jobs<br/>[jobs.py]"]
end

subgraph group_catalog["Library catalog"]
  node_scanner["Folder scanner<br/>[scanner.py]"]
  node_work_model["Work records<br/>[models.py]"]
  node_store[("SQLite library<br/>[db.py]")]
end

subgraph group_enrichment["Metadata enrichment"]
  node_scraper["DLsite fetcher<br/>[scraper.py]"]
  node_dlsite["DLsite service"]
end

subgraph group_discovery["Path discovery"]
  node_everything_worker["Everything worker"]
  node_everything_sdk["Everything SDK<br/>[everything.py]"]
  node_everything[("Everything index")]
  node_local_access["Local path access<br/>[local_access.py]"]
end

subgraph group_analysis["Search and export"]
  node_stats["Search and statistics<br/>[stats.py]"]
  node_exporter["Excel export<br/>[exporter.py]"]
end

node_user(("Library user"))

node_user -->|"uses"| node_workbench
node_user -->|"opens overview"| node_overview_ui
node_workbench -->|"requests"| node_server
node_overview_ui -->|"requests"| node_server
node_server -->|"starts scan"| node_scanner
node_server -->|"starts jobs"| node_jobs
node_server -->|"reads and writes"| node_store
node_server -->|"fetches metadata"| node_scraper
node_server -->|"queries library"| node_stats
node_server -->|"exports results"| node_exporter
node_server -->|"queries paths"| node_everything_worker
node_server -->|"handles paths"| node_local_access
node_scanner -->|"creates records"| node_work_model
node_store -->|"loads records"| node_work_model
node_scraper -->|"requests product data"| node_dlsite
node_everything_worker -->|"dispatches query"| node_everything_sdk
node_everything_sdk -->|"queries index"| node_everything
node_exporter -->|"exports fields"| node_work_model
node_stats -->|"filters records"| node_work_model

click node_workbench "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/static/app.js"
click node_overview_ui "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/static/stats.js"
click node_server "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/server.py"
click node_jobs "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/jobs.py"
click node_scanner "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/scanner.py"
click node_work_model "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/models.py"
click node_store "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/db.py"
click node_scraper "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/scraper.py"
click node_everything_worker "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/everything_worker.py"
click node_everything_sdk "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/everything.py"
click node_local_access "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/local_access.py"
click node_stats "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/stats.py"
click node_exporter "https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/exporter.py"

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_workbench,node_overview_ui,node_server,node_jobs,node_user toneBlue
class node_scanner,node_work_model,node_store toneAmber
class node_scraper,node_dlsite toneMint
class node_everything_worker,node_everything_sdk,node_everything,node_local_access toneRose
class node_stats,node_exporter toneIndigo
```

## Components

### Web interface

- [Workbench UI](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/static/app.js): `static/app.js`
- [Overview UI](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/static/stats.js): `static/stats.js`
- [Local web server](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/server.py): `server.py`
- [Background jobs](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/jobs.py): `dlsite_tool/jobs.py`

### Library catalog

- [Folder scanner](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/scanner.py): `dlsite_tool/scanner.py`
- [Work records](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/models.py): `dlsite_tool/models.py`
- [SQLite library](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/db.py): `dlsite_tool/db.py`

### Metadata enrichment

- [DLsite fetcher](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/scraper.py): `dlsite_tool/scraper.py`
- **DLsite service**

### Path discovery

- [Everything worker](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/everything_worker.py): `dlsite_tool/everything_worker.py`
- [Everything SDK](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/everything.py): `dlsite_tool/everything.py`
- **Everything index**
- [Local path access](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/local_access.py): `dlsite_tool/local_access.py`

### Search and export

- [Search and statistics](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/stats.py): `dlsite_tool/stats.py`
- [Excel export](https://github.com/oldgeorsk/dlsite-management-tool/blob/main/dlsite_tool/exporter.py): `dlsite_tool/exporter.py`

### Other components

- **Library user**

## Connections

- Library user → Workbench UI: uses (evidence: `README.md`)
- Library user → Overview UI: opens overview (evidence: `README.md`)
- Workbench UI → Local web server: requests (evidence: `README.md`)
- Overview UI → Local web server: requests (evidence: `README.md`)
- Local web server → Folder scanner: starts scan (evidence: `server.py`)
- Local web server → Background jobs: starts jobs (evidence: `server.py`)
- Local web server → SQLite library: reads and writes (evidence: `server.py`)
- Local web server → DLsite fetcher: fetches metadata (evidence: `server.py`)
- Local web server → Search and statistics: queries library (evidence: `server.py`)
- Local web server → Excel export: exports results (evidence: `server.py`)
- Local web server → Everything worker: queries paths (evidence: `server.py`)
- Local web server → Local path access: handles paths (evidence: `server.py`)
- Folder scanner → Work records: creates records (evidence: `dlsite_tool/scanner.py`)
- SQLite library → Work records: loads records (evidence: `dlsite_tool/db.py`)
- DLsite fetcher → DLsite service: requests product data (evidence: `README.md`)
- Everything worker → Everything SDK: dispatches query (evidence: `dlsite_tool/everything_worker.py`)
- Everything SDK → Everything index: queries index (evidence: `README.md`)
- Excel export → Work records: exports fields (evidence: `dlsite_tool/exporter.py`)
- Search and statistics → Work records: filters records (evidence: `dlsite_tool/stats.py`)
