aboutsummaryrefslogtreecommitdiff
path: root/src/Jellyfin.Database
AgeCommit message (Collapse)Author
4 daysMerge remote-tracking branch 'upstream/master' into tmdb-missing-episodesShadowghost
# Conflicts: # Jellyfin.Server.Implementations/Item/BaseItemRepository.QueryBuilding.cs
4 daysMerge pull request #17416 from Shadowghost/enable-duplicate-playlist-childrenCody Robibero
Allow duplicate LinkedChildren for Playlists
11 daysFix favorite filter performanceShadowghost
11 daysFix DatePlayed sorting performanceShadowghost
13 daysReduce correlated subqueries to improve performanceShadowghost
13 daysAllow duplicate LinkedChildren for PlaylistsShadowghost
2026-06-25Add TMDb missing episode providerShadowghost
2026-05-30Merge remote-tracking branch 'upstream/master' into search-rebasedShadowghost
# Conflicts: # Emby.Server.Implementations/Library/LibraryManager.cs # Jellyfin.Server.Implementations/Item/PeopleRepository.cs # MediaBrowser.Controller/Library/ILibraryManager.cs # MediaBrowser.Controller/Persistence/IPeopleRepository.cs
2026-05-29Merge pull request #16177 from theguymadmax/homevideo-viewtypesBond-009
Add new viewtypes options
2026-05-26Backport: Fix/user manager collation (#16919)Bond-009
Backport: Fix/user manager collation
2026-05-24Merge remote-tracking branch 'upstream/master' into search-rebasedShadowghost
2026-05-21Add new viewtypestheguymadmax
2026-05-21Run tree-wide dotnet formatjakobkukla
2026-05-16Merge remote-tracking branch 'upstream/master' into search-rebasedShadowghost
2026-05-15Reorder migration handling for extra columnJPVenson
2026-05-15Merge pull request #9787 from TheMelmacian/feature/language_filtersBond-009
New filters for audio and subtitle languages
2026-05-15readded concurrency exception checkJPVenson
2026-05-12Update logging message for DbConcurrency messagesJPVenson
2026-05-12Merge remote-tracking branch 'upstream/master' into search-rebasedShadowghost
2026-05-10feat: language filters for subtitles and audioTheMelmacian
2026-05-07Add OriginalLanguage as option to PreferredAudioLanguage (#12579)Erik W
* Add OriginalLanguage as option to PreferredAudioLanguage * Support for multiple original languages * Add original audio stream indicator * Fetch OriginalLanguage from TMDB * Adapt to EFCore refactor * Fix PlayDefaultAudioTrack OriginalLanguage behavior * Fix better PlayDefaultAudioTrack OriginalLanguage behavior * Add comment to ItemFields * Improved PlayDefaultAudioTrack behavior * Add migration for original language * Use sting.Equals for string comparisons * Always set dto OriginalLanguage * Remove OriginalLanguage from ItemFields --------- Co-authored-by: Lampan-git <lampan-git@users.noreply.github.com>
2026-05-04Apply review suggestionsShadowghost
2026-05-04Fix Playlist and Boxset query and count perfShadowghost
2026-05-04Implement search providersShadowghost
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