Ai_Agent
  • Joined on 2026-07-08
Ai_Agent opened issue MilkyShots/MilkyShots#108 2026-07-13 17:37:09 +00:00
Redesign homepage: curated album & cosplayer selection instead of infinite photo scroll
Ai_Agent commented on issue MilkyShots/MilkyShots#56 2026-07-13 17:12:12 +00:00
Web API automated testing

Updated issue body with current progress and split into two phases based on codebase analysis (July 13):

Phase 1 — Fill remaining REST Client gaps (Media, Folder, Jobs, Tag CRUD, Settings…

Ai_Agent opened issue MilkyShots/MilkyShots#107 2026-07-13 17:01:39 +00:00
CurrentUser scoped service — replace inline authService.GetUserData(User) calls
Ai_Agent opened issue MilkyShots/MilkyShots#106 2026-07-13 16:58:17 +00:00
Auth/permissions redesign — 5-actor model, Maintainer role, DB schema
Ai_Agent opened issue MilkyShots/MilkyShots#105 2026-07-13 15:47:55 +00:00
Rate limiting for public search & auth endpoints
Ai_Agent opened issue MilkyShots/MilkyShots#104 2026-07-13 15:44:08 +00:00
Maintenance page: request timing metrics per endpoint (avg/top time, DB vs total)
Ai_Agent opened issue MilkyShots/MilkyShots#103 2026-07-13 15:43:43 +00:00
Add ability for curators/admins to add assets to an album from the album detail page
Ai_Agent opened issue MilkyShots/MilkyShots#102 2026-07-12 19:20:05 +00:00
Card components not middle-clickable — <div @onclick> instead of <a> breaks "open in new tab"
Ai_Agent opened issue MilkyShots/MilkyShots#101 2026-07-12 19:04:33 +00:00
Person endpoint slow due to cartesian-explosion includes and client-side pagination
Ai_Agent created pull request MilkyShots/MilkyShots#100 2026-07-12 18:11:17 +00:00
Add searchbar to cosplayer detail page for filtering albums
Ai_Agent opened issue MilkyShots/MilkyShots#99 2026-07-12 17:37:46 +00:00
Stats endpoint & page are slow: 25+ SQL queries per request and monolithic rendering
Ai_Agent commented on pull request MilkyShots/MilkyShots#91 2026-07-12 17:27:16 +00:00
Global "Search Anything" typeahead dropdown in navbar

Addressed the validation review points:

  • AlbumController, TagController: reverted PageSize < 1 back to original PageSize < 0
  • PersonController: removed PageSize < 1, kept only…
Ai_Agent commented on pull request MilkyShots/MilkyShots#91 2026-07-12 17:07:50 +00:00
Global "Search Anything" typeahead dropdown in navbar

Fixed the 4 failing tests (23, 24, 25, 45, 46):

  • Root cause: SharedWith.Any() navigation through the many-to-many AlbumAsset join table couldn't be translated by EF Core inside a SQL…
Ai_Agent commented on pull request MilkyShots/MilkyShots#91 2026-07-12 17:03:24 +00:00
Global "Search Anything" typeahead dropdown in navbar

Rebased & addressed all review feedback:

  • Pagination zero-based standard (closes #95):
    • AssetRepository: all Skip() → page * size (3 occurrences)
    • JobRecordRepository: same formula…
Ai_Agent opened issue MilkyShots/MilkyShots#98 2026-07-12 16:43:34 +00:00
Album/person search queries are catastrophically slow at scale (1.1M assets, 25k albums)
Ai_Agent commented on pull request MilkyShots/MilkyShots#91 2026-07-12 16:04:59 +00:00
Global "Search Anything" typeahead dropdown in navbar

Added performance index for visibility queries (commit 48b6d4f)

Created a partial index IX_Assets_VisibleForSearch on Assets(IsPubliclyShared, OwnerId) WHERE "DeletedAt" IS NULL to…

Ai_Agent opened issue MilkyShots/MilkyShots#97 2026-07-12 15:44:47 +00:00
CosplayersMissingCover stat is hardcoded to 0 — never wired up
Ai_Agent opened issue MilkyShots/MilkyShots#96 2026-07-12 15:42:25 +00:00
Add searchbar to cosplayer detail page for filtering albums
Ai_Agent commented on pull request MilkyShots/MilkyShots#91 2026-07-12 15:41:33 +00:00
Global "Search Anything" typeahead dropdown in navbar

Refactored AlbumRepository.SearchQuery to match the new PersonRepository pattern (commit 89edf29)

Same approach as the Person repository — projects AlbumPreviewDto directly with…

Ai_Agent commented on pull request MilkyShots/MilkyShots#91 2026-07-12 15:18:26 +00:00
Global "Search Anything" typeahead dropdown in navbar

Addressed review feedback on TotalVisibleAlbums (commit c77096b)

Removed the [NotMapped] TotalVisibleAlbums property from Person.cs and refactored PersonRepository.SearchQuery to…