Ai_Agent
0 Followers · 0 Following
  • Joined on 2026-07-08
Repositories Projects Packages Public Activity Starred Repositories
Ai_Agent commented on issue MilkyShots/MilkyShots#30 2026-08-18 09:39:57 +00:00
Change Controller to be async

Branch analysis: feature/webapi/async-methods-migration (2026-08-18)

Branch contents:

  • Exactly 1 commit: 4f4575f (2025-07-02) — "feat(Lactose): Change UserRepository to Async…
Ai_Agent commented on issue MilkyShots/MilkyShots#98 2026-08-18 09:39:48 +00:00
Album/person search queries are catastrophically slow at scale (1.1M assets, 25k albums)

Current status vs initial report (analysis, 2026-08-18)

Initial report (2026-07-12): Album search generated ~50k correlated subqueries (25k albums × 2 — a 3-level nested WHERE EXISTS…

Ai_Agent commented on issue MilkyShots/MilkyShots#101 2026-08-18 09:38:58 +00:00
Person endpoint slow due to cartesian-explosion includes and client-side pagination

Verified resolved against the current code (2026-08-18):

  • Cartesian explosion eliminated — PersonRepository.FindVisible no longer loads the album→asset→shared-with graph. It loads the…
Ai_Agent commented on issue MilkyShots/MilkyShots#181 2026-08-18 09:18:34 +00:00
feat: convert GIFs to mp4 via ffmpeg + first-frame thumbnail

PR #182 implements this: ConvertAnimatedJob (GIF → mp4 via ffmpeg + first-frame thumbnail), new settings, Dockerfile ffmpeg install, and GIF-exclusion from thumbnail/preview jobs. Serving the…

Ai_Agent commented on issue MilkyShots/MilkyShots#180 2026-08-18 09:18:33 +00:00
feat: mark broken assets instead of requeueing + rebuild maintenance page

PR #182 implements this: broken-asset tracking (schema, query exclusion, job marking), the broken-assets report endpoints, and the filesystem-based maintenance browsing.

Ai_Agent created pull request MilkyShots/MilkyShots#182 2026-08-18 09:17:42 +00:00
WIP: feat: mark broken assets instead of requeueing + rebuild maintenance page + GIF→mp4 conversion
Ai_Agent commented on issue MilkyShots/MilkyShots#181 2026-08-18 09:00:11 +00:00
feat: convert GIFs to mp4 via ffmpeg + first-frame thumbnail

Related: #180 (broken-asset marking + maintenance page; failed conversions are marked broken).

Ai_Agent commented on issue MilkyShots/MilkyShots#180 2026-08-18 09:00:11 +00:00
feat: mark broken assets instead of requeueing + rebuild maintenance page

Related: #181 (GIF → mp4 conversion job reuses this broken-marking).

Ai_Agent opened issue MilkyShots/MilkyShots#181 2026-08-18 09:00:07 +00:00
feat: convert GIFs to mp4 via ffmpeg + first-frame thumbnail
Ai_Agent opened issue MilkyShots/MilkyShots#180 2026-08-18 09:00:03 +00:00
feat: mark broken assets instead of requeueing + rebuild maintenance page
Ai_Agent commented on pull request MilkyShots/MilkyShots#178 2026-08-17 22:09:25 +00:00
refactor: optimize stats endpoint & page for scale

Code review

Reviewed the stats optimization PR (backend StatsRepository/migration + frontend chart components). Overall the consolidation into aggregated queries is sound. Two functional…

Ai_Agent created pull request MilkyShots/MilkyShots#179 2026-08-17 21:57:12 +00:00
WIP: fix: use real anchor links for navigation so they open in a new tab
Ai_Agent created pull request MilkyShots/MilkyShots#178 2026-08-17 20:59:06 +00:00
WIP: refactor: optimize stats endpoint & page for scale
Ai_Agent commented on issue MilkyShots/MilkyShots#99 2026-08-17 20:33:08 +00:00
Stats endpoint & page are slow: 25+ SQL queries per request and monolithic rendering

Umbrella tracked through 5 concrete child issues (milestone v1.1), with a dependency chain:

Ai_Agent opened issue MilkyShots/MilkyShots#177 2026-08-17 20:32:54 +00:00
Stats: add charts to visualize distributions
Ai_Agent opened issue MilkyShots/MilkyShots#176 2026-08-17 20:32:53 +00:00
Stats: extract shared components & formatting helper
Ai_Agent opened issue MilkyShots/MilkyShots#175 2026-08-17 20:32:51 +00:00
Stats: cache aggregated results in-memory
Ai_Agent opened issue MilkyShots/MilkyShots#174 2026-08-17 20:32:49 +00:00
Stats: add filtered database indexes
Ai_Agent opened issue MilkyShots/MilkyShots#173 2026-08-17 20:32:47 +00:00
Stats: consolidate & async-ify backend queries
Ai_Agent created pull request MilkyShots/MilkyShots#172 2026-08-17 20:12:51 +00:00
WIP: fix: resolve nullable dereference warnings