aboutsummaryrefslogtreecommitdiff
path: root/src/Jellyfin.Database/Jellyfin.Database.Implementations
AgeCommit message (Collapse)Author
2026-08-01Merge pull request #17416 from Shadowghost/enable-duplicate-playlist-childrenCody Robibero
Allow duplicate LinkedChildren for Playlists
2026-07-25Fix favorite filter performanceShadowghost
2026-07-25Fix DatePlayed sorting performanceShadowghost
2026-07-23Reduce correlated subqueries to improve performanceShadowghost
2026-07-23Allow duplicate LinkedChildren for PlaylistsShadowghost
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-21Add new viewtypestheguymadmax
2026-05-16Merge remote-tracking branch 'upstream/master' into search-rebasedShadowghost
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-03-08Optimize Search and NextUp queriesShadowghost
2026-03-05Fix review commentsShadowghost
2026-02-15Migrate PrimaryVersionId to GUID and fix assignmentShadowghost
2026-02-07Fix BoxSet collapse handling and deletionShadowghost
2026-02-07Optimize IndicesShadowghost
2026-01-31Optimize Validator and Filter PerformanceShadowghost
2026-01-18Add ImageInfo indexShadowghost
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-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-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-25Fix people deduplication lookup (#14864)JPVenson
2025-09-16Optimize internal querying of UserData, other fixes (#14795)JPVenson
2025-09-12Improve optimistic locking behavior (#14779)JPVenson
2025-07-14Allow loading of Database options for DB provider (#14466)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-27Add required nuget propertiesCody Robibero
generated by cgit v1.2.3 (git 2.46.0) at 2026-08-21 14:15:59 +0000