wjones/pgsql-jellyfin
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • df035a069d fix logging development wjones 2026-07-08 15:44:42 -04:00
  • 4e6bf45701 Update logging configuration to set Microsoft.EntityFrameworkCore.Database.Command level to Error wjones 2026-07-08 15:17:19 -04:00
  • 2415f288f7 Refactor rebuild process and enhance service management in rebuild-solution.sh wjones 2026-07-08 14:45:49 -04:00
  • 94e46a04a7 remove publish test directories and update weekly monitoring script wjones 2026-07-08 14:22:22 -04:00
  • 0535515b11 Update Microsoft.Extensions.DependencyModel version and adjust project file references wjones 2026-07-08 14:06:04 -04:00
  • 401c24f599 Update package reference for Microsoft.Extensions.DependencyModel and modify restore command for Linux wjones 2026-07-08 14:04:07 -04:00
  • f52bd18ee3 Merge pull request 'commit' (#11) from development into main main wjones 2026-07-08 13:59:25 -04:00
  • 41e737f3ec commit wjones 2026-07-08 13:46:27 -04:00
  • 2dc2c40beb Merge pull request 'Development' (#10) from development into main wjones 2026-07-08 13:30:34 -04:00
  • aca106bfe9 correct Unhandled exception. System.IO.FileNotFoundException: Could not find file '/opt/jellyfin/ServerSetupApp/index.mstemplate.html'. wjones 2026-07-08 13:28:06 -04:00
  • 72081ca13d commit changes to project file wjones 2026-07-08 13:13:46 -04:00
  • 9c9ad0f88e update projec t file to include wwwroot in publish output wjones 2026-07-08 12:51:11 -04:00
  • 90fb90d0be Add files for web ui wjones 2026-07-08 12:44:58 -04:00
  • 7a9981b872 feat: disable default content items in project file wjones 2026-07-08 12:35:11 -04:00
  • 2ba6c44ae8 fix: comment out unused custom.css references in project file wjones 2026-07-08 12:32:40 -04:00
  • 31d8aa1fc4 feat: include wwwroot content in output directory for preservation wjones 2026-07-08 12:29:25 -04:00
  • 39cc8697c7 Merge pull request 'Development' (#9) from development into main wjones 2026-07-08 12:15:51 -04:00
  • d6cd89ecd0 feat: add directory checks for log and config directories in rebuild script wjones 2026-07-08 12:14:47 -04:00
  • dce22a558f fix: remove unnecessary blank line before error logging in PostgresDatabaseProvider wjones 2026-07-08 12:00:50 -04:00
  • 1abf61a05f Add PostgresSubprocessException and refactor database initialization logic wjones 2026-07-08 11:53:36 -04:00
  • 4f651fc239 feat: enhance logging configuration with async file logging for SQL commands wjones 2026-07-07 17:26:23 -04:00
  • 421a8cc092 fix: implement exponential backoff strategy for concurrency exceptions in SaveChangesAsync wjones 2026-07-07 11:31:47 -04:00
  • 9bcb8501ab Add scripts for PostgreSQL migration and SQLite removal; update project references wjones 2026-07-07 10:59:40 -04:00
  • bf51bff748 feat: add conditional VACUUM ANALYZE support with thresholds to performance monitor script wjones 2026-07-07 09:28:41 -04:00
  • 8d3f014b29 fix: remove duplicate description for VACUUM ANALYZE in performance report script wjones 2026-07-07 09:02:51 -04:00
  • e7c8d202cc Merge branch 'main' of https://gitea.wpjones.com/wjones/pgsql-jellyfin wjones 2026-07-07 09:02:38 -04:00
  • c5c5937978 Update .gitignore and remove old weekly report files; enhance performance monitor script with VACUUM ANALYZE option wjones 2026-07-07 08:58:53 -04:00
  • 96150a54e3 Merge pull request 'feat: add conditional VACUUM ANALYZE support to weekly monitoring scripts' (#8) from wpjonesnh-dead-tuple-vacuum into main wjones 2026-07-07 08:34:19 -04:00
  • aa0ad68251 Merge pull request 'Development' (#7) from development into main wjones 2026-07-07 08:33:47 -04:00
  • 81f8a702de feat: add conditional VACUUM ANALYZE support to weekly monitoring scripts wpjonesnh-dead-tuple-vacuum wjones 2026-07-07 08:31:33 -04:00
  • b475a8264a feat: add PostgresPeriodicTuner for periodic database maintenance and optimize NoWarn settings wjones 2026-07-07 08:29:35 -04:00
  • 4a408dc625 Use execution strategy in UpdateInheritedValues wjones 2026-06-10 12:09:55 -04:00
  • b2d7513cf2 updating sql file for database creation wjones 2026-05-11 14:45:48 -04:00
  • 315b7e0bd0 fix: ensure UTC date handling for Live TV extras in database insert wjones 2026-05-04 13:57:32 -04:00
  • 4ccd84342b feat: implement migration tracking and history management for PostgreSQL wjones 2026-05-04 12:47:12 -04:00
  • e67c191843 Add comprehensive documentation for PostgreSQL schema conversion wjones 2026-05-04 10:16:17 -04:00
  • 3e5d29225a Refactor SQLite Database Provider wjones 2026-05-03 09:39:00 -04:00
  • e1f7a4bee9 Refactor database configuration and migrations for PostgreSQL support wjones 2026-04-30 18:47:48 -04:00
  • 9fc10226c9 feat: implement migration to split MediaStreamInfos into AudioStreamDetails and VideoStreamDetails wjones 2026-04-30 17:48:49 -04:00
  • 372d97885f Merge pull request 'Add JSON config, DB-backed library options, and docs' (#6) from development into main wjones 2026-04-30 19:58:25 +00:00
  • 57d6342524 Optimize PostgreSQL dead tuple handling for media scans wjones 2026-04-30 15:52:37 -04:00
  • 6d5282208b Merge branch 'development' of https://gitea.wpjones.com/wjones/pgsql-jellyfin into development wjones 2026-04-30 13:28:18 -04:00
  • f246d2ad39 update create database schema sql file wjones 2026-04-30 13:28:09 -04:00
  • 189c7edcf6 Merge pull request 'WebSocket Token Authentication' (#5) from feature/websocket-token-auth into development wjones 2026-04-30 16:49:53 +00:00
  • 4ba580a761 feat: WebSocket token authentication via api_key query parameter feature/websocket-token-auth wjones 2026-04-30 12:42:50 -04:00
  • e81c127514 Add JSON config, DB-backed library options, and docs wjones 2026-04-30 12:25:24 -04:00
  • dff8539e8b Merge pull request 'Add EnableRetryOnFailure to handle transient connection failures (57P01 terminating connection)' (#4) from development into main wjones 2026-04-30 12:49:03 +00:00
  • bad167656a Reduce log noise for WebSocket authentication failures - downgrade to Debug level wjones 2026-04-29 08:30:54 -04:00
  • 786c61ba09 Fix 12 code analysis errors in MediaEncoding projects - use LoggerMessage source generators and specific exception types wjones 2026-04-29 08:24:34 -04:00
  • aead802df6 Add troubleshooting section for 57P01 connection termination errors wjones 2026-04-29 08:13:31 -04:00
  • dd7c38fb5d Add EnableRetryOnFailure to handle transient connection failures (57P01 terminating connection) wjones 2026-04-29 08:12:44 -04:00
  • bb309a5120 Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/assessment.csv wjones 2026-04-13 19:19:34 +00:00
  • 96c85f95c5 Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/assessment.json wjones 2026-04-13 19:19:26 +00:00
  • 254569237d Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/assessment.md wjones 2026-04-13 19:19:17 +00:00
  • c5d1033680 Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/execution-log.md wjones 2026-04-13 19:19:07 +00:00
  • 41368c2dbc Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/plan.md wjones 2026-04-13 19:18:59 +00:00
  • 35923c59e0 Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/Risk Management Strategies.md wjones 2026-04-13 19:18:52 +00:00
  • 35a3634c34 Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/scenario.json wjones 2026-04-13 19:18:42 +00:00
  • 2d68b4fda0 Delete .github/upgrades/scenarios/new-dotnet-version_02bc64/tasks.md wjones 2026-04-13 19:18:33 +00:00
  • 8e62b84a31 Delete .idea/.idea.Jellyfin/.idea/encodings.xml wjones 2026-04-13 19:15:29 +00:00
  • f8f407c8bd Merge pull request 'update ignore file' (#3) from pgsql_testing_branch into main wjones 2026-04-13 19:14:26 +00:00
  • 613d499fab commit ignore file wjones 2026-04-13 15:13:38 -04:00
  • 769f2a804a commit gitignore wjones 2026-04-13 15:12:48 -04:00
  • ee2aa8c13c Merge pull request 'Add placeholder item handling and related unit test for deletion' (#2) from pgsql_testing_branch into main wjones 2026-04-13 19:10:24 +00:00
  • 945226050f Merge pull request 'PostgreSQL: replace EF migrations with SQL-first initialization, fix connection handling, and update setup docs' (#1) from upgrade-to-NET11 into main wjones 2026-04-13 19:07:14 +00:00
  • 41e8477673 Refactor code structure for improved readability and maintainability wjones 2026-04-13 14:57:37 -04:00
  • eccb1359c8 Add placeholder item handling and related unit test for deletion wjones 2026-04-13 11:01:59 -04:00
  • 45dc885cd5 Update publish profile to Linux x64; refresh scenario time wjones 2026-03-10 17:08:43 -04:00
  • 73d3c0f733 Add jellyfin-ffmpeg requirements and recommendations to README wjones 2026-03-10 14:54:05 -04:00
  • 2183ed4d63 Add comprehensive README with Linux dependencies and PostgreSQL configuration guide wjones 2026-03-10 14:20:16 -04:00
  • e6e7c49888 Fix EnsureDatabaseExistsAsync to respect ConnectionString from configuration - was still using localhost default wjones 2026-03-10 13:47:50 -04:00
  • 7deb7c1432 Fix SA1513 StyleCop error - add blank line after closing brace wjones 2026-03-10 13:01:12 -04:00
  • 077f10a4af Fix connection configuration - respect ConnectionString and individual options from database.xml wjones 2026-03-10 12:55:49 -04:00
  • a872ebc640 commit database_design wjones 2026-03-09 15:24:01 -04:00
  • 43e866f446 Add schema directories to gitignore - ignore database dumps recursively wjones 2026-03-09 15:16:06 -04:00
  • e790f84ace Re-enable database creation check to prevent crash when database doesn't exist wjones 2026-03-08 11:31:08 -04:00
  • caa30d8b88 Remove CREATE DATABASE from schema script - database already created via config wjones 2026-03-08 11:27:30 -04:00
  • bb9329736f Fix password masking error - password not in args anyway wjones 2026-03-08 11:19:28 -04:00
  • d4426fe0f6 Use psql subprocess to execute schema script - handles psql meta-commands wjones 2026-03-08 11:13:39 -04:00
  • 7657caa960 Fix database initialization detection - check for TABLES not just schemas wjones 2026-03-08 11:07:16 -04:00
  • ac1c2c6c82 CRITICAL FIX: Also disable database migrations in JellyfinMigrationService - was running InitialCreate wjones 2026-03-08 10:50:00 -04:00
  • 2209f0e1c0 COMPLETE REWRITE: Remove ALL migration code, implement pure SQL script initialization wjones 2026-03-07 13:29:23 -05:00
  • 7e2c08499b Document automatic empty database initialization feature wjones 2026-03-07 13:08:28 -05:00
  • 75acefe989 Add automatic SQL script execution for empty database initialization wjones 2026-03-07 13:07:44 -05:00
  • c4127e7749 Update README paths and disable EnsureCreatedAsync to prevent automatic schema creation wjones 2026-03-07 13:03:10 -05:00
  • 2d6e10e163 CRITICAL: Also disable EnsureCreatedAsync - it was bypassing migration tracking and creating schema wjones 2026-03-07 13:01:33 -05:00
  • 5c711bc235 Add database setup documentation for .NET 11 preview manual migration workflow wjones 2026-03-07 12:52:52 -05:00
  • 091114657b Disable EF Core migrations for .NET 11 preview - use manual SQL scripts instead wjones 2026-03-07 12:52:05 -05:00
  • 5202d72999 Fix ActivityLogs index creation - remove DO block for CONCURRENTLY support wjones 2026-03-07 12:37:46 -05:00
  • f47a544c7a Add manual SQL script for applying supplementary indexes migration wjones 2026-03-07 12:35:00 -05:00
  • a3d76901ed Merge pull request 'Remove fallback code for database index creation' (#19) from upgrade-to-NET11 into main wjones 2026-03-07 11:53:45 -05:00
  • f2ddde1747 Remove fallback code for database index creation wjones 2026-03-07 11:52:55 -05:00
  • 14964da5e8 Merge pull request 'upgrade-to-NET11' (#18) from upgrade-to-NET11 into main wjones 2026-03-07 11:38:10 -05:00
  • e7aa3024cb Refactor BaseItemRepository for ordered DTO materialization wjones 2026-03-07 11:32:56 -05:00
  • 2ba3335ca0 add .github directory to ignore file wjones 2026-03-07 10:31:09 -05:00
  • 3c5f94c242 Fix TV shows and movies listing - add default alphabetical ordering wjones 2026-03-07 10:11:07 -05:00
  • a1c9488c6c Fix library ordering - use ID-based lookup for reliable alphabetical sorting wjones 2026-03-06 18:08:53 -05:00
  • 26791b568b Fix TV show season ordering - use IndexNumber instead of SortName wjones 2026-03-06 17:52:47 -05:00
  • 7c032fe4e2 Complete .NET 11.0 upgrade and solution validation wjones 2026-03-06 10:00:45 -05:00
  • ff89f36120 Complete .NET 11.0 upgrade - all tiers validated wjones 2026-03-06 09:42:36 -05:00