codehowlermonkey / hitfactor.info Goto Github PK

Could be a good way to quickly look up something about the shooter that isn't available in the ShooterTable or RunsTable.

Maybe we can even fit graph in there, and definitely some version of a card, to show other divisions.

Could be web only using existing endpoints api/shooters/A99999

should also include:

1. Rec. Percent in classifier scores table
2. Rec. GMs / Ms/ As in classifiers table
3. "Rec HHF" and "CurHHF - RecHFF" columns in the classifiers table
4. Rec. Percent & Rec. Class in Shooters Table
5. Same as 3. for shooters info

Broke downloads with mongo, needs to be re-implemented.

Subj.

Tooltip component from prime react library is unreliable and has weird targeting.

Replace it everywhere where we have tooltips with something else

When classifier scores were fetched we filtered out the inactive (as of Jan 2024) members.
The fetch for classifications of members was done after that only against active members.

This resulted in some scores show up with X classification and "Expired / Not Found".

We need to refetch expired members and possibly support active/inactive expiration status in addition to what we have now.

Probably is blocked by #2

Might need a PractiScore account, since there seems to be no open data to see something like https://practiscore.com/clubs/CLUB_NAME/results

1. Add hq/cur/rec letters to api/shooters/:division
2. Filter out where letters don't match
3. Probably do different modes: hq-vs-cur, hq-vs-rec, I think cur-vs-rec isn't needed as both are synthetic
4. review that classification percentage differences that we need for all modes are already there
5. api can return all needed data and not be aware of the mode
6. frontend can group by GMs/Ms by using multisort
7. additional mode/toggle can be all/demotions/bumps

OG idea from howler monkey discord server, if you're from there and have something to add -- please leave a comment.

Right now, things like filters, pagination, and sort aren't reflected in the URL.

It's not super hard to support this, but it requires significant effort for not-so-much of a reward (quick linking for sending your analysis data sources to someone else for discussion / review).

Parking this as a known issue / TODO / improvement

Probably can just use a simple fs.stat on one of the files updated by the import script.

Or even make import script write the date on start / completion.

Mostly this is useful for catching cheaters / reviewing clubs that have shooters with sus scores.

See #22

LO/CO is a synthetic division made out of a merge between LO and CO data.

It was hacked up as quick as possible, simply to make app not crash.
We need to review debug everything we can with LO/CO div and make sure it doesn't crash and also uses proper data.

Right now all HHFs for it are LO HHFs, and instead we should pick the highest from CO and LO. And maybe show both

Prob should fix 500, return empty table and no frontend fix required

Currently everything is stored and pre-hydrated on server start in-memory, often duplicating the same data multiple times for easier access (e.g. classifier runs by shooter or by division/classifier).

This causes 2 main problems:

1. Server requires quite a lot of RAM to run
2. It takes a noticeable time to hydrate the data, multiple minutes on M1 Pro Macbook, resulting in serious loss of productivity, when constantly changing the API and reloading the server.

We need to find a way to optimize both of these things, but the second one is more important, at least until we get to really high RAM usage, which will force us to change hosting (right now app idles at slightly above 4GB with legacy scores, and around 2 without).

Some ideas how to achieve this:

1. Sequelize + sqlite in memory, with proper DB tables design and basically rewrite of the whole model layer. HUGE EFFORT, HIGH CHANCE OF REGRESSIONS, if you can do this -- you're basically a legit senior backend dev.
2. RxDB, has in memory, is basically nosql, but has schemas, maybe can be hacked together moderately easy-ish. Higher Middle Dev Level
3. Just make GB+ JSON files work, JSONStream, await-sync, etc. Anything that will simply save shit to disk and cache it there. Won't help with memory, probably will make it worse. But should make development faster.
4. Any other ideas?

top20 to infinity and beyond, use data from classifications at first and nothing else

clicking anything in that table goes to #3