github-mirrors/audiobookshelf
1
0
Fork 0
mirror of https://github.com/advplyr/audiobookshelf.git synced 2025-04-23 14:09:04 -04:00
Code Issues Projects Releases Packages Wiki Activity
audiobookshelf/server/utils
History
Exact
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