mikiher 40504da4d7

Improve book library page query performance for author sort order (#4080) ...

* Add migration to create authorNames* columns, in libraryItems including update triggers and indices

* Add authorNames columns and indices to LibraryItem model

* Add database triggers for updating author names in libraryItems (for new databases)

* Populate authorNames during book scanning

* Update book sorting to use new authorNames columns

* Add an index on podcastEpisodes.publishedAt

* Fix group_concat order by and update to sqlite 3.44.2

---------

Co-authored-by: advplyr <advplyr@protonmail.com>

2025-03-17 17:09:49 -05:00

..

generators

Update:Book series embeds in grouping meta tag as semicolon deliminated, book meta tag parser falls back to using grouping tag for series if set #3473

2024-10-20 16:58:13 -05:00

migrations

Migrate tools and collapse series. fix continue shelves. remove old objects

2025-01-05 14:09:03 -06:00

parsers

Update opf parser to support refines meta elements

2025-03-13 17:49:05 -05:00

queries

Improve book library page query performance for author sort order (#4080)

2025-03-17 17:09:49 -05:00

areEquivalent.js

Add feed migration and cleanup

2023-07-05 18:18:37 -05:00

comicBookExtractors.js

Fix catch exception on failed to parse comic metadata #3804

2025-01-08 16:53:56 -06:00

constants.js

Add mime types for MPEG/MPG

2024-11-01 09:12:40 -05:00

ffmpegHelpers.js

Update podcast downloads to fallback to download without tagging due to inaccurate rss feed enclosures #3837

2025-01-14 15:48:06 -06:00

fileUtils.js

Add fileUtils recurseFiles and shouldIgnoreFile tests

2025-02-23 16:53:11 -06:00

globals.js

'mpg' and 'mpeg' added as supported audio-type/file-extension

2024-10-31 15:29:40 +01:00

htmlEntities.js

Ability to decode HTML Entities when all tags are stripped. Fixes #929

2022-08-30 19:20:35 -04:00

htmlSanitizer.js

Update custom metadata provider results to sanitize html descriptions #3880

2025-01-26 10:51:18 -06:00

index.js

Update RSS feed to exclude empty tags, format duration, use CDATA

2025-01-20 13:57:56 -06:00

libraryHelpers.js

Migrate tools and collapse series. fix continue shelves. remove old objects

2025-01-05 14:09:03 -06:00

longTimeout.js

Fix:Shares not working with timeouts longer than 23 days #3164

2024-07-27 17:40:51 -05:00

notifications.js

Add localization for notification descriptions

2024-10-12 15:22:21 -05:00

podcastUtils.js

Auto format

2025-02-18 17:19:06 -06:00

prober.js

Fix merging embedded chapters for multi-track audiobooks giving incorrect chapter ids #3361

2025-01-12 09:56:48 -06:00

profiler.js

Add a profile utility function

2025-02-08 10:41:56 +02:00

scandir.js

Fix spelling

2025-03-09 14:01:53 -07:00

stringifySequelizeQuery.js

fix stringifySequelizeQuery and add tests

2025-02-15 23:57:27 +02:00

zipHelpers.js

Change: no compression when downloading library item as zip file

2024-12-07 16:52:31 -07:00