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
..
v0.0.1-migration_example.js	Update migrations jsdocs	2024-09-10 15:57:07 -05:00
v0.0.1-migration_example.test.js	Make migration management more robust	2024-09-07 22:24:19 +03:00
v2.15.0-series-column-unique.test.js	Fix: flaky 2.15.0 migration test	2025-02-26 21:40:56 -07:00
v2.17.3-fk-constraints.test.js	Update v2.17.3 migration file to first check if constraints need to be updated, add unit test	2024-11-30 15:48:20 -06:00
v2.17.4-use-subfolder-for-oidc-redirect-uris.test.js	Change migration to v2.17.4	2024-11-29 09:01:03 +02:00
v2.17.5-remove-host-from-feed-urls.test.js	Remove serverAddress from Feeds and FeedEpisodes URLs	2024-12-07 19:27:37 +02:00
v2.17.6-share-add-isdownloadable.test.js	Feat/download via share link (#3666)	2024-12-29 16:52:57 -06:00
v2.19.1-copy-title-to-library-items.test.js	Improve page load queries on title, titleIgnorePrefix, and addedAt sort order	2025-02-08 12:29:23 +02:00
v2.19.4-improve-podcast-queries.test.js	Change migration version to v2.19.4	2025-02-18 07:57:46 +02:00
v2.20.0-improve-author-sort-queries.test.js	Improve book library page query performance for author sort order (#4080)	2025-03-17 17:09:49 -05:00