aboutsummaryrefslogtreecommitdiff
path: root/src/Jellyfin.Database
AgeCommit message (Collapse)Author
44 hoursFix Playlist and Boxset query and count perfShadowghost
2026-04-19Merge remote-tracking branch 'upstream/master' into perf-rebasedShadowghost
2026-04-18Merge pull request #15355 from twsouthwick/twsouthwick-patch-1Bond-009
Enable jellyfin.db customized path
2026-03-08Optimize Search and NextUp queriesShadowghost
2026-03-05Fix review commentsShadowghost
2026-02-15Migrate PrimaryVersionId to GUID and fix assignmentShadowghost
2026-02-08Fix multiple version resolutionShadowghost
2026-02-07Fix BoxSet collapse handling and deletionShadowghost
2026-02-07Fix version resolution and scan handlingShadowghost
2026-02-07Optimize IndicesShadowghost
2026-01-31Optimize Validator and Filter PerformanceShadowghost
2026-01-18Add ImageInfo indexShadowghost
2026-01-18Fix EFcore readmeShadowghost
2026-01-18Don't use raw SQLShadowghost
2026-01-18Complete LinkedChildren integration and batch DTO optimizationsShadowghost
This commit integrates remaining performance changes: - Add batch user data fetching in DtoService to reduce N+1 queries - Add GetNextUpEpisodesBatch in TVSeriesManager for efficient batch retrieval - Update Video/Movie/BoxSet to use LibraryManager for alternate versions - Transition LinkedChild to use ItemId instead of Path (obsolete Path/LibraryItemId) - Update providers and controllers for LinkedChildren-based references - Add NextUpEpisodeBatchResult for batched episode queries - Integrate IDescendantQueryProvider in SqliteDatabaseProvider
2026-01-18Add folder-aware filter extensions and descendant query providerShadowghost
- Add FolderAwareFilterExtensions for LinkedChildren-based filtering - Add IDescendantQueryProvider interface for database-specific queries - Add MatchCriteria classes for folder filtering - Add SqliteDescendantQueryProvider implementation
2026-01-18Add optimized indexes for UserData and latest items queriesShadowghost
2026-01-18Remove ExtraIds column and use OwnerId relationship for extrasShadowghost
- Remove ExtraIds property from BaseItemEntity and BaseItem - Update RefreshExtras to query via OwnerId instead of cached ExtraIds - Update GetExtras methods to query database via OwnerIds filter - Add OwnerIds and ExtraTypes filter support to InternalItemsQuery - Add filter handling in BaseItemRepository for new query options - Update HasSpecialFeature/HasTrailer filters to use Extras relationship - Add CleanupOrphanedExtras migration routine - Add database migration to drop ExtraIds column
2026-01-18Normalize OwnerId to GUID and add performance indexesShadowghost
- Change OwnerId from string to Guid for proper foreign key relationships - Add Owner/Extras navigation properties for extras relationship - Add indexes on OwnerId and ExtraType columns for efficient queries - Add optimized composite indexes for latest items queries sorted by DateCreated - Update BaseItemRepository and migration to handle new Guid type
2026-01-18Add LinkedChildren database table for normalized relationshipsShadowghost
Introduces a new database table to store linked child relationships for boxsets, playlists, and video alternate versions. This replaces the JSON-serialized Data column approach with a proper relational structure. - Add LinkedChildEntity and LinkedChildType enum - Add entity configuration with proper foreign keys - Add EF Core migration for SQLite
2026-01-14Update to .NET 10.0Bond_009
2025-11-17Backport pull request #15369 from jellyfin/release-10.11.zevanreichard
feat(sqlite): add timeout config Original-merge: c2e5081d64e519a74d47df23335bb228fea8ec7e Merged-by: crobibero <cody@robibe.ro> Backported-by: Bond_009 <bond.009@outlook.com>
2025-11-02Backport pull request #15328 from jellyfin/release-10.11.zevanreichard
fix: in optimistic locking, key off table is locked Original-merge: b5f0199a25cc221ff86d112ed6968a5352277e32 Merged-by: crobibero <cody@robibe.ro> Backported-by: Joshua M. Boniface <joshua@boniface.me>
2025-11-02Enable jellyfin.db customized pathTaylor Southwick
This enables moving where the database is stored to another directory that doesn't have all the trickplay/subtitles/etc Fixes #15354
2025-10-27Backport pull request #15087 from jellyfin/release-10.11.ztheguymadmax
Optimize WhereReferencedItemMultipleTypes filtering Original-merge: a5bc4524d8a882efa12a17b6251894322745be78 Merged-by: crobibero <cody@robibe.ro> Backported-by: Bond_009 <bond.009@outlook.com>
2025-10-13Fix contributing artist query (#14991)theguymadmax
2025-09-28Fix AddProperParentChildRelationBaseItemWithCascade migration deleting all itemsNiels van Velzen
2025-09-25Fix people deduplication lookup (#14864)JPVenson
2025-09-25Fixes FK on unconnected base items (#14863)JPVenson
2025-09-24Add People Dedup and multiple progress fixes (#14848)JPVenson
2025-09-16Optimize internal querying of UserData, other fixes (#14795)JPVenson
2025-09-14Reenable common PRAGMA setters (#14791)JPVenson
2025-09-12Improve optimistic locking behavior (#14779)JPVenson
2025-09-12Reenable pooling (#14778)JPVenson
2025-09-07Additional debug logging for SQLite connections (#14753)evan314159
2025-07-22Supress transaction (#14514)JPVenson
2025-07-14Allow loading of Database options for DB provider (#14466)JPVenson
2025-07-14Use IDatabaseCreator instead of relying on History repository (#14465)JPVenson
2025-06-26Fix modification checks and make sure to use UTC (#14347)Tim Eisele
2025-06-11Fix UserData cleanup task and queries (#14280)JPVenson
2025-06-09Feature/persistent watch data (#14262)JPVenson
2025-06-03Allow custom plugin provided database providers to be loaded (#14171)JPVenson
2025-06-03Add declarative backups for migrations (#14135)JPVenson
2025-06-03Add multiple options for internal locking (#14047)JPVenson
2025-06-03Add partition helper (#14039)JPVenson
2025-05-18Add Full system backup feature (#13945)JPVenson
2025-04-27Merge pull request #14016 from crobibero/upd-projectsJoshua M. Boniface
Add new nuget packages to abi diff
2025-04-27Unified migration handling (#13950)JPVenson
2025-04-27Add required nuget propertiesCody Robibero
2025-04-26Fix ItemValue query (#13939)JPVenson
generated by cgit v1.2.3 (git 2.46.0) at 2026-05-06 04:53:38 +0000