aboutsummaryrefslogtreecommitdiff
path: root/src/Jellyfin.Database/Jellyfin.Database.Implementations
AgeCommit message (Collapse)Author
7 daysMerge pull request #17582 from Shadowghost/fix-assembliesCody Robibero
Fix assemblies
7 daysMerge pull request #17563 from Shadowghost/cleanup-sql-helpersCody Robibero
Cleanup and simplify query helpers
9 daysFix assembliesShadowghost
10 daysMerge pull request #17560 from IDisposable/chore/pessimistic-reality-checkCody Robibero
Add warning that PessimisticLockBehavior is unsafe
11 daysApply review suggestionsShadowghost
12 daysCleanup and simplify query helpersShadowghost
12 daysAdd warning that PessimisticLockBehavior is unsafeMarc Brooks
Since it uses ReaderWriterLockSlim, it gets tripped up if the transaction is continued across an await boundary on a different thread.
12 daysFix captured (and discarded) Execute exceptionsMarc Brooks
Using ExecuteAndCapture (and the async version) requires something to manage the captured exception, which we don't do. Errors would be silently dropped and the writes/deletes treated as if they succeeded.
2026-08-02Merge remote-tracking branch 'upstream/master' into fix-byname-queriesShadowghost
2026-08-01Merge remote-tracking branch 'upstream/master' into fix-byname-queriesShadowghost
# Conflicts: # src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs
2026-08-01Merge remote-tracking branch 'upstream/master' into tmdb-missing-episodesShadowghost
# Conflicts: # Jellyfin.Server.Implementations/Item/BaseItemRepository.QueryBuilding.cs
2026-08-01Merge pull request #17416 from Shadowghost/enable-duplicate-playlist-childrenCody Robibero
Allow duplicate LinkedChildren for Playlists
2026-07-28Restrict people, genres, studios and artists to names backed by an item the ↵Shadowghost
user can access
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-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-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