audiobookshelf/server
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
..
controllers fix(auth): Add admin-level auth to LibraryController delete update and issue removal 2025-02-22 00:44:52 +01:00
finders Support rich text book descriptions 2025-01-22 08:53:23 +02:00
libs Update custom metadata provider results to sanitize html descriptions #3880 2025-01-26 10:51:18 -06:00
managers Update migration manager to validate migration files #4042 2025-03-06 17:24:33 -06:00
migrations Improve book library page query performance for author sort order (#4080) 2025-03-17 17:09:49 -05:00
models Improve book library page query performance for author sort order (#4080) 2025-03-17 17:09:49 -05:00
objects Show download icon for queued/downloaded episodes in rss feed modal 2025-02-26 17:56:17 -06:00
providers Cast OpenLibrary publishYear to string #4114 2025-03-15 17:41:07 -05:00
routers Close RSS feeds after removing empty series 2025-03-08 17:47:47 -06:00
scanner Improve book library page query performance for author sort order (#4080) 2025-03-17 17:09:49 -05:00
utils Improve book library page query performance for author sort order (#4080) 2025-03-17 17:09:49 -05:00
Auth.js Security fix for GHSA-pg8v-5jcv-wrvw 2025-02-11 22:02:51 +02:00
Database.js Improve book library page query performance for author sort order (#4080) 2025-03-17 17:09:49 -05:00
Logger.js Simplify log level determination 2025-03-08 12:46:36 -07:00
Server.js Merge branch 'advplyr:master' into master 2025-01-04 20:15:59 -05:00
SocketAuthority.js Keep original socket.io server for non-subdir clients 2024-11-29 04:13:00 +02:00
Watcher.js Add: generic function to ignor files 2025-02-22 12:28:51 -07:00