Mert

fix(ml): set face detection threshold correctly in locust

3

### Description The detection threshold is in the `recognition` options, but it needs to be in the `detection` options instead. Also fixes and tightens the face detection unit test.

refactor(server): link live photos as part of metadata extraction instead of queueing job

2

## Description The overhead of queueing jobs for individual assets can be significant. This PR moves live photo linking to metadata extraction instead, taking care to do this *after* asset...

refactor(server): group async calls in metadata extraction

1

## Description This PR refactors metadata extraction to increase concurrent asynchronous operations as well as making smaller code improvements, improving overall performance. It is based on #16390, which should be...

refactor(server): use exiftool for file date metadata

1

### Description There are two redundant `stat` calls in metadata extraction that can instead use the exiftool output (tags starting with `File` are from the file system). Besides generally less...

## Description This is an easy win for search performance. An embedding is currently generated for any given request, including later pages of the same search query. It's much better...

chore(web): passive events

1

## Description The passive option lets the browser skip checking if `preventDefault` was called, acting as a promise that the listener won't call `preventDefault`. It makes things like scrolling faster...

feat(web): wasm justified layout

3

## Description This is take 2 for #15524 with various improvements since then, including: * Safari compatibility * Subpixel rendering for better box gaps * Improved layout algorithm * More...

chore(web): skip slow rules except in ci

1

## Description These two rules account for the lion's share of time when locally linting the web codebase. There are two more slow rules that are kept in this PR...

Support `COPY ... FROM STDIN`

2

This is a PostgreSQL feature [supported](https://github.com/porsager/postgres?tab=readme-ov-file#await-sqlcopy--from-stdinwritable---writable) by Postgres.js and through a [plugin](https://www.npmjs.com/package/pg-copy-streams) for pg. It's significantly faster for bulk imports compared to regular bulk inserts, so it'd be great to...

resumable: clarify greater offset

7

Resolves #3268, making it more explicit that the resource offset is allowed to be greater than what the client sent in its current upload. It also consolidates the rejection behavior...