-
- Titled Tuesday is open to any Fide-titled player (>=2200). Every tuesday. There’s an early and late tourney, 11am ET and 5pm ET. Around 500 people play in each. 11 round swiss. 3+1 blitz. 1st place is $1k in each.
- Lots of private work.
- To show the views in a postgres db:
select table_name from INFORMATION_SCHEMA.views WHERE table_schema = ANY (current_schemas(false));
- Did some ticket planning. Brought the scorestreaming/tick task forward while I do this batch of table updates.
- There’s a luka doncic bot on chess.com now! https://www.chess.com/news/view/play-luk-ai-bot-chesscom
- Cooked another batch of liver. It smelled a little weird. Being extra sensitive after last week, decided to throw it away.
\o to switch output in psql.
- SBSC. Prepped some data changes.
- Removed
scores.coverer and picks.points. Everything is recalculated from the data in 1st order normal form. Will do the change for gen cols (for results views) next.
- The removal proved to take longer than expected, mostly due to data cleansing. The
coverer column was directly populated from Petty’s gsheets in the backfill. The coverer col was correct, but the underlying scores were NOT mapped correctly (underdog and favorite switched). Works in all recent seasons, because the espn scorestrip maps correctly from home/visitor. But the backfill didn’t have that. So it got some wrong. And with coverer gone, the calculation from swapped source SCORES showed incorrect results.
- Wrote a couple convenience views,
matchups and allpicks.
- Cleaned ADMIN.md.
- Altered a bunch of col types from dialect-specific values (BIGINT, TEXT, postgresql.TIMESTAMP, etc) to sqlalchemy generics (sa.Integer/String/DateTime).
- The frontend had a bug from the last couple releases. Was showing UTC timestamps. Fixed to show PT on the matchups view.
- Also the asterisks for home teams were gone. Fixed the bug (was the hidden td).
