insight‑charts

Overview

insight‑charts processes insight records from Navidrome and generates Vega-Lite charts.

Charts implemented so far

• Operating system distribution
• Number of instances over time
• File systems used for music files
• File systems used for data files
• Player types/clients used

Requirements

• Deno runtime
• SQLite database with Navidrome insights data

Installation

git clone https://github.com/yourusername/insight-charts.git
cd insight-charts

Using Deno tasks (recommended)

development; auto‑reloads on file change
deno task dev
produce a standalone native binary in ./insight‑charts
deno task build

Configuration

Environment variables

| Variable | Purpose | Example | | -------------------- | ---------------------------------------------------------------------------- | ---------------------------------- | | INSIGHTDBPATH | Path to the SQLite database. Required if --db-path flag is not passed. | INSIGHTDBPATH=./db/insights.db | | INSIGHTOUTPUTDIR | Folder where chart JSON files will be written. | INSIGHTOUTPUTDIR=./charts | | INSIGHTVERBOSE | Enable timestamped log lines (1, true, yes). | INSIGHTVERBOSE=1 |

A sample file (.env.example) is provided; copy it to .env and adjust:

cp .env.example .env
...edit as needed...

Usage

Using only environment variables

INSIGHTDBPATH=./db/insights.db \
INSIGHTOUTPUTDIR=./charts \
deno run -ERW main.ts

Compiled binary

After deno task build:

./insight-charts -d ./db/insights.db -o ./charts -v

Options

| Flag | Description | Default | | ------------------------- | ------------------------------------- | ------- | | -d, --db-path <path> | Path to the SQLite database | — | | -o, --output-dir <path> | Output directory for chart JSON files | . | | -v, --verbose | Prepend date & time to log messages | off | | --help | Show built‑in help | — |

View the visualisations

deno task serve

Docker

Build

docker build -t insight-charts .