v0.2.3

What's Changed

• Improvement/tests rewrite by @davistdaniel in #17
• Safer processing of databases, check for empty dataframes before and during computation of stats.

Full Changelog: v0.2.2...v0.2.3

v0.2.2

Performance

• Much faster page reload after the Docker container’s initial startup.

Fix

• Resolved an issue where database initialization and data processing were executed twice due to auto-reload behavior as described in #14

Refactoring

• Extracted client activity and queries-over-time plots into dedicated functions in plot module.

What's Changed

• Fix/page reload by @davistdaniel in #15

Full Changelog: v0.2.1...v0.2.2

v0.2.1

• Added brief descriptions under plots.
• CI builds docker images for multi-platform support (linux/amd64,linux/arm64). Thanks to @bolausson for raising the issue (#12).

What's Changed

• Improvement/plot descriptions by @davistdaniel in #13

Full Changelog: v0.2.0...v0.2.1

v0.2.0

UI changes

• Added two new visualizations : top-domains-top-clients-scatter (irrespective of blocked or allowed), heatmaps for day-hour stats:

Refactoring

• Refactored the project into a modular, installable package : piholelongtermstats, installable via PyPi.

What's Changed

• Feature/new visualizations by @davistdaniel in #11

Full Changelog: v0.1.5...v0.2.0

v0.1.5

Fix

• Fixed a bug where the max available date in the UI was not updated on refresh.
• Some refactoring.

What's Changed

• Improvement/phlts tests by @davistdaniel in #9

Full Changelog: v0.1.4...v0.1.5

v0.1.4

Combine multiple databases

• Added functionality to combine multiple databases and visualize combined stats. Provide multiple databases by listing their paths as a comma-separated string.

Regex based exclusion of domains

• Added functionality for regex-based exclusion of domains before computing stats. Use flag ignore_domains or environment variable PIHOLE_LT_STATS_IGNORE_DOMAINS.

• Thanks to @jamespo for trying this feature before release.

What's Changed

• Feature/multiple dbs by @davistdaniel in #7
• Feature/regex ignore by @davistdaniel in #8

Full Changelog: v0.1.3...v0.1.4

v0.1.3

Configurable Top Domains

Added --n_domains parameter to control how many top domains are shown in plots
Set via command line using --n_domains or PIHOLE_LT_STATS_NDOMAINS environment variable
Default: 10 top domains

UI

Minor changes to CSS
Explicit deletion of initial layout after render.

v0.1.2

General improvements

• Reduced Memory Footprint
• Data is now pre-aggregated hourly before visualization
• Removed intermediate dataframe references
• Should handle much larger datasets without running out of memory
• Handle database decode errors when reading from Pi-hole FTL database
• Fixed x-axis label overflow on domain plots - long domain names now truncated with ellipsis

Timezone

• Added --timezone parameter to display all timestamps in your local timezone
• Supports any IANA timezone (e.g., America/New_York, Europe/Berlin)
• Can be set via PIHOLE_LT_STATS_TIMEZONE environment variable or --timezone
• Default remains UTC for backward compatibility

Configurable Top Clients

• Added --n_clients parameter to control how many top clients are shown in plots
• Set via command line or PIHOLE_LT_STATS_NCLIENTS environment variable
• Default: 10 clients

UI changes

• Removed frequency dropdown
• Chart layouts with horizontal legends

Full Changelog: v0.1.1...v0.1.2

v0.1.1

v0.1.1:

Added reload functionality from within the UI
Fixed some of the memory leaks
Added custom date range functionality
Some other UI changes

Full Changelog: v0.1.0...v0.1.1

v0.1.0

This is the first release of PiHoleLongTermStats : A dashboard built with Dash and Plotly to explore long-term DNS query data from a Pi-hole v.6 FTL database file. Visualize allowed vs blocked domains, top clients, and query trends over time.

🧰 Features

• 🗂️ Info cards : Query stats, Activity stats, Day and Night stats
• 📈 Interactive charts for query trends and client behavior
• 🔍 Filter queries by client
• 🌐 View top blocked/allowed domains
• 📅 Analyze queries over a custom number of past days

What's Changed

• Move Dependency handling to use UV and add in new docker image by @lukepoo101 in #1

New Contributors

• @lukepoo101 made their first contribution in #1

Full Changelog: https://github.com/davistdaniel/PiHoleLongTermStats/commits/v0.1.0