Breaking changes
This release added paradedb's pg_search extension to replace Postgres full text search. Using the latest version of the production dockerfile will ensure you have the correct extensions. Alternatively it can be installed separately.
The production dockerfile also uses a new fork of pg-spgist-hamming. The fork includes optimizations for batch fingerprint queries, and fixes bugs that might otherwise break fingerprint submission. Using the original implementation of the extension is no longer supported.
The file hierarchy and naming for file image backends have been changed from md5 to image id nested by id prefix (aa/bb/aabb...) similar to s3 storage. The included python script can be used to migrate file names.
What's Changed
⭐ Improvements
- Parse pasted entity urls in search fields by @InfiniteStash in #1036
- Prioritize studio performers in scene form performer search by @InfiniteStash in #1037
- Add fingerprint moving/deletion for moderators by @InfiniteStash in #1006
- Change varchar columns to text by @InfiniteStash in #1045
- Add SubmitFingerprints batch mutation by @InfiniteStash in #1009
- Replace full text GIN index with paradedb search by @InfiniteStash in #1038
- Paginate sub-studio fetching by @InfiniteStash in #1057
- Optimize serving of local image files by @InfiniteStash in #1063
- Add autocert certificate fetching by @InfiniteStash in #1062
- Split bra size into cup/band on frontend by @InfiniteStash in #1067
- Add edit deletion for moderators, and audit logs by @InfiniteStash in #1044
- Rename applyEdit->approveEdit, and restrict to Moderators by @InfiniteStash in #1087
- Switch image file backend from checksum to id paths by @InfiniteStash in #1091
- Change performer image prioritization; use float division for aspect ratios by @tj2222 in #1089
- Add frontend unit tests by @InfiniteStash in #1094
- Add playwright e2e tests by @InfiniteStash in #1093
🐞 Fixes
- Fix crash when multiple cron edit applications are running by @InfiniteStash in #1041
- Fix removal of aliases from deleted studios/tags by @InfiniteStash in #1046
- Correct incorrect date accuracy on older edits by @peolic in #1050
- Fix notifications when edits are closed by votes by @InfiniteStash in #1058
- Fix CheckboxSelect state persistence by @InfiniteStash in #1054
- Fix activation timer and error messages by @InfiniteStash in #1059
- Fix parsing of
brownhair color in performer drafts by @InfiniteStash in #1065 - Fix styling of quotes in edit comments by @InfiniteStash in #1066
- Add no script CSP on images route by @ikmckenz in #1074
- Remove usage of pg-spgist-hamming when phash distance is zero by @InfiniteStash in #1083
- Fix returned error in activation when email does not exist by @InfiniteStash in #1100
🚧 Maintenance
- Remove deprecated fingerprint queries by @InfiniteStash in #1042
- Remove findSceneByFingerprint query by @InfiniteStash in #1043
- Remove MD5 hash support by @InfiniteStash in #1040
- Update postgres extension documentation by @InfiniteStash in #1082
- Filter out md5s from SubmitFingerprints mutation by @InfiniteStash in #1080
New Contributors
Full Changelog: v0.7.9...v0.8.0