Updates November 17
PGrid
- Creating full page tables to allow using the new landing page
- Required fixing a bunch of issues with ClickHouse queries related to out of stock and getting the latest items after using materialised views. Introduced a new table in ClickHouse which is used to store the last price snapshot for all items which gets used for further queries.
- Updated the CPU table generation to not require Postgres timeseries data querying. Added hidden fields to CPU table.
- Fixes to CPU and SSD queries to make them simpler. For SSD queries there was useless timezone stuff, for CPUs added a column to allow manually ignoring CPU models for being displayed.
- Progress on replacing the current index page with new landing page
- Got sick with food poisoning from Wed to rest of the week