Wuast94/intro-skipper-pgsql
1
0
Fork 0
Code Issues Pull requests Projects Releases 16 Packages Wiki Activity Actions
16 releases 94 tags
  • v0.6.0 df6f2f8d71

    v0.6.0
    All checks were successful
    Release / Check if release needed (push) Successful in 5s
    Details
    Release / Release (push) Successful in 2m9s
    Details
    Stable

    Wuast94 released this 2026-06-07 15:15:25 +02:00 | 33 commits to pgsql since this release

    Bug Fixes

    • Fix

    • Fix2

    • Fix3

    • Use dotnet publish to include all runtime dependencies

    • Exclude design-time DLLs and enable dynamic loading

    • Db

    • Db2

    • Db3

    • Db4

    • Db5

    • Use pgsql plugin id in dashboard

    • Migrate legacy pgsql fingerprint cache

    Features

    • Native PostgreSQL provider for Intro Skipper

    • Initial pgsql plugin release

    • Exclude Jellyfin framework assemblies from plugin package

    • Adopt upstream cache dashboard for pgsql

    Miscellaneous

    • Bump Microsoft.NET.Test.Sdk from 18.4.0 to 18.5.1 (#759)

    • Bump github/codeql-action from 4.35.2 to 4.35.3 (#758)

    • Bump github/codeql-action from 4.35.3 to 4.35.4 (#764)

    • Bump coverlet.collector from 10.0.0 to 10.0.1 (#766)

    • Bump github/codeql-action from 4.35.4 to 4.35.5 (#765)

    • Bump github/codeql-action from 4.35.5 to 4.36.0 (#770)

    • Bump Microsoft.NET.Test.Sdk from 18.5.1 to 18.6.0 (#775)

    • Bump github/codeql-action from 4.36.0 to 4.36.1 (#774)

    • Update deps

    • Add plugin fork management to build system

    • Update manifest for v1.10.11.17

    • Update manifest for v1.10.11.17 [skip ci]

    • Trigger release

    • Pull Jellyfin packages from Forgejo NuGet registry to match unsigned server build

    • Bundle meta.json with assemblies whitelist in release zip

    Other

    • Avoid SQLite param limit in CleanTimestampsAsync

    Prevent exceeding SQLite parameter limits by batching deletions. Introduces SqliteParameterBatchSize (500) and updates CleanTimestampsAsync to load distinct segment episode IDs, compute stale IDs, and delete them in chunks. Adds a test (CleanTimestampsAsync_DoesNotExceedSqliteVariableLimit_WhenEpisodeListIsLarge) that creates a large episode set (~33k), verifies only retained segments remain, and includes helper logic to clean up temporary SQLite files.

    • Migrate legacy fingerprint cache to DB (#754)

    Co-authored-by: rlauuzo 46294892+rlauuzo@users.noreply.github.com

    • Release v1.10.11.19

    • Migrate all legacy detection cache files (#755)

    • Extend legacy cache migration to silence/keyframes/blackframes

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Rename legacy detection cache migration

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Use actual legacy cache paths during migration

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Simplify legacy detection cache migration helpers

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Reduce legacy migration log noise

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Parse legacy detection cache files once

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Optimize legacy detection cache scan

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Simplify legacy detection filename parsing

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Cap AnalysisPercent at 50 (#752)
    • Cap AnalysisPercent at 50 to prevent excessive processing

    Co-authored-by: rlauuzo 46294892+rlauuzo@users.noreply.github.com

    • Clamp AnalysisPercent lower bound

    Co-authored-by: rlauuzo 46294892+rlauuzo@users.noreply.github.com

    • Centralize AnalysisPercent bounds

    Co-authored-by: rlauuzo 46294892+rlauuzo@users.noreply.github.com

    • Centralize analysis setting defaults

    Co-authored-by: rlauuzo 46294892+rlauuzo@users.noreply.github.com

    • Inline SQLite PRAGMA command text

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    Co-authored-by: rlauuzo 46294892+rlauuzo@users.noreply.github.com
    Co-authored-by: Kilian von Pflugk github@jumoog.io
    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Fix credits analysis failures on large seasons and add intro/credits overlap guard (#757)
    • Fix 1000-episode analysis, add intro/credits overlap guard, and tests

    Agent-Logs-Url: https://github.com/intro-skipper/intro-skipper/sessions/e39b4730-0be1-4ce7-8a6f-fe5f3bd0741a

    Co-authored-by: AbandonedCart 1173913+AbandonedCart@users.noreply.github.com

    • Merge three UpdateTimestampAsync tests into a single Theory

    Agent-Logs-Url: https://github.com/intro-skipper/intro-skipper/sessions/e39b4730-0be1-4ce7-8a6f-fe5f3bd0741a

    Co-authored-by: AbandonedCart 1173913+AbandonedCart@users.noreply.github.com

    • Potential fix for pull request finding 'Call to 'System.IO.Path.Combine' may silently drop its earlier arguments'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Potential fix for pull request finding 'Inefficient use of ContainsKey'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Potential fix for pull request finding 'Call to 'System.IO.Path.Combine' may silently drop its earlier arguments'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Potential fix for pull request finding 'Call to 'System.IO.Path.Combine' may silently drop its earlier arguments'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Apply suggestions from code review

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Potential fix for pull request finding 'Call to 'System.IO.Path.Combine' may silently drop its earlier arguments'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    Co-authored-by: copilot-swe-agent[bot] 198982749+Copilot@users.noreply.github.com
    Co-authored-by: AbandonedCart 1173913+AbandonedCart@users.noreply.github.com
    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Update branding with a more "fitting" color scheme (#768)

    • Some mildly modern refreshed branding

    • Add matching icon assets

    • fix icon centering and update SVG file

    • Update README.md to use current logo

    • Use hashes for analysis state and probe audio time (#767)

    • Use hashes for analysis state and probe audio time

    Added targeted config hashes for analysis results and detection cache entries.
    Stale automatic segments are cleaned and reanalyzed when relevant settings change.
    User/editor-provided segments are still preserved and still override analysis.
    Added optional ProbeAudioDuration setting using ffprobe so credits fingerprinting can use actual audio duration instead of inflated container runtime.
    Added the dashboard toggle under FFmpeg settings.
    Removed the old “settings changed means globally AnalyzeAgain” behavior in favor of hash-based freshness.

    • Fix error CS1620 and error SA1122

    • Patched ConfigHasher.cs so invariant formatting helper receives separate FormattableString parts

    • Update IntroSkipper/FFmpegWrapper.cs

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • OnSettingsChanged now updates _config and sets Plugin.Instance.AnalyzeAgain = true again

    • Potential fix for pull request finding 'Call to 'System.IO.Path.Combine' may silently drop its earlier arguments'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Update IntroSkipper/FFmpegWrapper.cs

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • Revert "Potential fix for pull request finding 'Call to 'System.IO.Path.Combine' may silently drop its earlier arguments'"

    This reverts commit 2cbfec7f1d29c3abf0372e875ae6b57c623e3637.

    • Update IntroSkipper/FFmpegWrapper.cs

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>

    • TryReadJsonCache now accepts rows with an empty ConfigHash as legacy-compatible,

    • HasCachedFingerprint again treats empty ConfigHash rows as valid legacy DB cache entries

    Co-authored-by: capy-ai[bot] <230910855+capy-ai[bot]@users.noreply.github.com>
    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • [skip actions] update copyright headers to SPDX format across all files

    • Release v1.10.11.20

    • Fix ConfigHash and migrations (including legacy) (#777)

    • Add ConfigHash legacy schema compatibility handling

    • Backfill missing ConfigHash columns for legacy SQLite schemas

    • Potential fix for pull request finding 'Generic catch clause'

    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>

    • Address code review: generalize ColumnExists and fix connection lifecycle in EnsureConfigHashColumns

    • Fix formatted string in a SQL statement

    • Avoid hardcoding table-specific PRAGMA statements in ColumnExists

    • Fix the security issue that was reintroduced

    • Improve migrations for startup reliability

    • Fix the reintroduced reintroduced security issue

    • Applied the CI fix and the magic-number cleanup.

    • Migration artifacts no longer reference AnalysisMode or IntroSkipper.Data

    Co-authored-by: copilot-swe-agent[bot] 198982749+Copilot@users.noreply.github.com
    Co-authored-by: TwistedUmbrellaX 1173913+AbandonedCart@users.noreply.github.com
    Co-authored-by: Copilot Autofix powered by AI <223894421+github-code-quality[bot]@users.noreply.github.com>
    Co-authored-by: TwistedUmbrellaX twistedumbrella@gmail.com

    • Fix legacy database initialization order (#780)

    • Fix legacy database initialization order

    • Document legacy DB initialization order

    Downloads