v2.4.2

What's Changed

• This release is all about speeding up database queries. In one case, a slow fetch of the data needed for the activity tab could cause all your irc network connections to drop, so that one was a whopper. Along the way, we kept digging into a slow search condition I've run into personally, and Claude suggested we dig into CHATHISTORY handling to see if there are also speedups to be found there. So there are two new indexes, and some changes to queries to take advantage of them. On update, it could take a minute or two to migrate depending on your database size and environment.
• Some optimizations around database migrations.
• Some random dependency updates.

What's Changed - Detailed

• searchMessages: drive highlights from their partial indexes; page a multi-network in: per buffer (#1070) by @amiantos in #1071
• Feed statements: every filter combination plans without a sort or a scan by @amiantos in #1072
• Two indexes: covering highlight reads and counts (#1073); CHATHISTORY windows seek by time (#1075) by @amiantos in #1076
• Bump proxy-addr from 2.0.7 to 2.0.8 in /integrations/autonotes in the npm_and_yarn group across 1 directory by @dependabot[bot] in #1062
• Bump proxy-addr from 2.0.7 to 2.0.8 by @dependabot[bot] in #1063
• Bump source-map-js from 1.2.1 to 1.2.2 by @dependabot[bot] in #1064
• Bump source-map-js from 1.2.1 to 1.2.2 in /docs by @dependabot[bot] in #1061
• Bump source-map-js from 1.2.1 to 1.2.2 in /vue_client by @dependabot[bot] in #1060
• Drain the WAL where the migrations end; immediate boot transactions (#748) by @amiantos in #1077
• Bump Lurker version to 2.4.2 by @amiantos in #1078

Full Changelog: v2.4.1...v2.4.2