ARMAGEDDON POP

Music Philosophy Art Math Chess Programming and much more ...

April
28
Monday
2025
2025 04 28

Armageddon POP Chess DB - ToDo List



🛠️ Armageddon POP Chess DB - ToDo List

Eplanation of symbols:

Function or Script fully working and tested
✅🔄  Function or Script fully working and tested
❌🔄 Under investigation
Bug or missing function



Search & Filters
  • ✅ ECO-based search
  • ✅ Search by White player
  • ✅ Search by Black player
  • ✅ Search by Date range
  •  Search by Opening Name
  • ✅ Result filter (Win/Loss/Draw)
User Interface
  • ✅ Search Form styling
  • 🔄 Pagination improvements
  • ❌🔄 Full responsive chessboard controls
  • 🔄 Autocomplete fields for players & ECO
  • ✅ Light/dark background for tables

    🔄 Eventhandler for mouseEnter in search input after first Criteria is set, then we take all the matches sorted alphabetically.
Database & Backend
  • ✅ Move to single table + partitions
  • 🔄 Optimize complex queries (multiple criteria)
  • ❌ Search by Move Text (future step)
  • 🔄 PGN Export stability checks
  • ✅ General backend cleanup

Notes:

2025-04-28 19:05:46 Search on White performs as expected; i.e once "Morphy, Paul" is selected Black at once contains only Paul Morphys opponent just as you expect as a user. Here though we must think this through, we dont need to connect everything with everything so to speak, but a very good example is that white player should be connected to black player(s) As soon as we triggers Morphy, Paul search From date should be at first date with correct format and To date should automatically be last game with correct date format. Note, that fortunately the db is sorted chronologically by default ID :) .

We must also consider the Collections table where we have 2 major things to do, the display must be not the CollectionID but rather the "Event" Column. Event must naturally be connected to players both black and white. Here same logic about date from - to applies