[bugfix] Fix filter title unique constraint (#3458)

[chore] Fix loop issue in streaming 🤦 (#3457)

[chore] Thumbnail only first frame of animated media (#3448)

[bugfix] Fix occasionally streaming empty messages (#3456)

[chore] Set some additional git attributes (#3454)

* .go files are now tagged with diff=go for better diffs
* go.sum is tagged with generated which suppresses the diff
* go.sum is tagged with merge=ours to reduce merge conflicts

go.mod isn't tagged with generated since it's useful to see it on
dependency bump PRs.

[docs/bugfix] Fix access to /dev and /tmp in AppArmor profile (#3444)

[chore] Upgrade golangci-lint, ignore existing int overflow warnings (#3420)

* [chore] Bump tooling versions, bump go -> v1.23.0

* undo silly change

* sign

* bump go version in go.mod

* allow overflow in imaging

* goreleaser deprecation notices

* [chore] Upgrade golangci-lint, ignore existing int overflow warnings

There is a new lint for unchecked int casts. Integer overflows are bad,
but the old code that triggers this lint seems to be perfectly fine.
Instead of disabling the lint entirely for new code as well, grandfather
in existing code.

* fix golangci-lint documentation link

* revert unrelated changes

* revert another unrelated change

* get rid of remaining nolint:gosec

* swagger updates

* apply review feedback

* fix wrong formatting specifier thing

* fix the linter for real

---------

Co-authored-by: tobi <tobi.smethurst@protonmail.com>

[docs] remove duplicate entry from supported platforms (#3442)

updates exported interface types to match ncruces/go-sqlite3/driver methods (#3440)

[chore] Hopefully final tweak to changelog generation (#3437)

[docs] Document experimental, unsupported `nowasm` tag (#3436)

* [docs] Document experimental, unsupported `nowasm` tag

* change some awkward wording

[feature/OFFICIALLY UNSUPPORTED] add nowasm build tag to disable building with WebAssembly (#3429)

* add experimental build-tag 'nowasm' which uses local ffmpeg / ffprobe

* updated experimental support message

* add comment to build script explaining build tag

* add nowasm build tags to moderncsqlite files

[chore]: Bump github.com/minio/minio-go/v7 from 7.0.77 to 7.0.78 (#3431)

Bumps [github.com/minio/minio-go/v7](https://github.com/minio/minio-go) from 7.0.77 to 7.0.78.
- [Release notes](https://github.com/minio/minio-go/releases)
- [Commits](https://github.com/minio/minio-go/compare/v7.0.77...v7.0.78)

---
updated-dependencies:
- dependency-name: github.com/minio/minio-go/v7
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

[chore]: Bump github.com/yuin/goldmark from 1.7.4 to 1.7.6 (#3430)

Bumps [github.com/yuin/goldmark](https://github.com/yuin/goldmark) from 1.7.4 to 1.7.6.
- [Release notes](https://github.com/yuin/goldmark/releases)
- [Commits](https://github.com/yuin/goldmark/compare/v1.7.4...v1.7.6)

---
updated-dependencies:
- dependency-name: github.com/yuin/goldmark
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

[chore] Clarify supported platforms, add notes + docs (#3427)

* [chore] Don't build for OpenBSD, add support level notes + tips

* tweak a bit

* add supported platforms matrix

[feature] for an sqlite database with journal mode != WAL, use maximum of 1 open conn (#3428)

[chore/docs] Add `/gotosocial/.cache` to Docker container, document `GTS_WAZERO_COMPILATION_CACHE` (#3425)

* [chore/docs] Add `/gotosocial/.cache` to Docker container, document `GTS_WAZERO_COMPILATION_CACHE`

* update wazero artifact size guesstimate

[docs] fix httpsig repo typo (#3426)

[chore] Ensure current tag not set as `GORELEASER_PREVIOUS_TAG` (#3424)

* [chore] Ensure current tag not set as `GORELEASER_PREVIOUS_TAG`

* tweak tweak

[chore/bugfix] goreleaser make previous_tag cmd busybox-compatible (#3423)

* [chore/bugfix] goreleaser make previous_tag cmd busybox-compatible

* Please muy lorde