jamcalli/Pulsarr v0.8.5

on GitHub

Changes

🛠️ Bug Fix Release - SQLite Dashboard Statistics Fix

Overview

Hotfix for SQLite users experiencing "Failed to fetch dashboard statistics" errors after upgrading to v0.8.4. The dashboard would fail to load with an internal server error.

Key Updates

SQLite Compatibility Fix (fixes #841)

• Root cause: SQLite's GROUP_CONCAT(DISTINCT col, separator) syntax is invalid - DISTINCT aggregates can only have one argument
• Solution: Replaced with JSON_GROUP_ARRAY(DISTINCT col) for SQLite and JSON_AGG(DISTINCT col) for PostgreSQL
• Affected functions: getMostWatchlistedShows, getMostWatchlistedMovies in dashboard statistics

Technical Improvements

• Added WatchlistAggregateRow type for cleaner query result handling
• Eliminated field-level type casts in favor of properly typed query results

Migration & Compatibility

Docker users

docker pull lakker/pulsarr:latest

Manual installation

git pull origin master
npm install
npm run build
npm run start:prod

No database migrations required.

Full Changelog: v0.8.4...v0.8.5
Docker Image: lakker/pulsarr:0.8.5

• Fix: SQLite Dashboard Statistics Fix (#843) @jamcalli
• fix(analytics): use JSON_GROUP_ARRAY for SQLite user aggregation (#842) @jamcalli

🔄 Dependencies

• chore(deps): update docker/setup-buildx-action digest to 8d2750c (#826) @renovate[bot]
• chore(deps): update react (#829) @renovate[bot]
• fix(deps): update dependency lucide-react to ^0.562.0 (#832) @renovate[bot]

Docker

docker pull lakker/pulsarr:0.8.5

Contributors

@jamcalli, @renovate[bot] and renovate[bot]