-
- 196 of 535 congress members accepted money from SBF/FTX.
- Private work.
- Saw hadestown on broadway.
- Lightshow control, pattern design, software development. Not just mapping each LED to an address and passing floats for brightness/color/etc at each time slice – that’s the from-scratch route. Instead you can input acoustic patterns and have the LEDs match the current music.
- Amazon Smile is shutting down in a month.
- SBSC.
- Continued work on the SBSC data backfill. Found some issues with the port yesterday. Actually finished today.
- Created a ticket to create the teams table and have other tables FK to it. Right now, columns with team names (in lines, scores, picks, etc) can be anything – there’s no enforcement. https://gitlab.com/bmahlstedt/supercontest/-/issues/175.
-
- 314th day without snowfall. 4th largest snow drought in nyc history.
- Tons of private work today.
- SEC declared that Gemini Earn violated securities law. You’re lending your assets (crypto) for interest payments (yield), which is technically the offering of an unregistered security (according to the SEC).
- “The investment of money in a common enterprise with a reasonable expectation of profits to be derived from the efforts of others” = security. Everything is a security.
- Cold weather makes our noses run. This is because cold air is dryer. Lower temp means more moisture condenses out of the air, leaving less moisture in the air. Dryer air means our nose produces more mucus to keep it moist.
- 3AC founders Su Zhu and Kyle Davies are starting a new venture: an exchange (called GTX) for crypto bankruptcy claims (lol).
- Got the Fidelity 401k check, sent to MS to rollover in their prepaid fedex envelope.
- SBSC. Finished the backfill, 2014-2017. https://gitlab.com/bmahlstedt/supercontest/-/issues/172.
- One migration for backfills to the seasons and weeks table.
- One migration for backfills to the lines and scores table.
- One migration to add old users.
- One migration for backfills to the picks table.
-
- Did a little bit of this yesterday too, but focused mostly on house stuff (plants, aquarium, mealprep, smoothies, bacon, gym, clean, laundry, etc).
- Adult neurogenesis is real. We create new neurons. Neuroplasticity is great. We can learn, remember, change, whatever.
- Considering SXSW for horror this year, Mar 10-19, Austin.
- Little deepdive in generated columns for postgres.
- Came out in postgres 12 (2019).
- You can have one column be completely dependent on others. Calculates when the depended columns are written (on insert) and recalculates every time the depended columns are updated.
- You can think manifest this in two ways.
- Stored. You can have the generated column written to disk (on every insert and update, as mentioned), just like a normal column. This is the same as a materialized view, but for cols instead of tables.
- Virtual. You can have the generated column only be calculated when it is read (during a query). This is the same a regular view, but for cols instead of tables.
- Right now for SBSC, I do this in python. Calculations of coverer (from other scores cols) and points (from other picks cols) are done in the app. This is very inefficient. And it’s not deterministic. They’re only written and read on app events, rather than direct write/read operations on the dependent data. Created ticket to fix: https://gitlab.com/bmahlstedt/supercontest/-/issues/174
- SBSC.
- Added some fake dates to the seasons and weeks tables to simulate offseason, preseason, and regseason (I had already tested yesterday’s changes against postseason).
- Created a gdrive folder for all sbsc content (not source, not in repo – this is some old gsheets and gdocs).
- https://gitlab.com/bmahlstedt/supercontest/-/issues/172
- Backfilled all the missing 2019 data. Finally.
- Basically a long manual ETL. Grabbed data from some public sources, butchered it in excel to match the format expect by my commit() functions, then created an alembic migration to load everything.
- Had to add a ton of functions. All details on ticket.
- Everything stored in alembic migrations.
-
- Tata steel finally started.
- 68,323 fans in attendance at warriors/spurs last night. NBA record.
- 49ers advance to divisional round over seahawks.
- Abstracted the aquarium maintenance doc to gsheets for the tabular portions. Easier to manage now. Also updated alive/dead status. Calculated totals: $1478 consumables, $9877 equipment, $5487 life (only $1839 still alive). $17k total so far.
- SBSC. Took over 10 hours to fix the postseason LB issues today. https://gitlab.com/bmahlstedt/supercontest/-/issues/171
- Fixed the data corruption for (after week 18, before season end).
- Made
season_start and season_end consistent for all (sept 1 and feb 1).
- Added proper preseason() and postseason() logic so we’re resilient to this in the future.
- TONS of logical changes in this one. Not repeating here. Just check ticket. Was a way bigger change than anticipated.
- I’ll actually copy one over. There’s a HUGE difference between these checks:
- Is it currently in an active week, or is it the offseason?
- Did the user request the active week, or a noncurrent (old) season/week?
- These two distinct cases were blended all over the place in the code. Had to separate and clean/rewrite a LOT.
-
- SEC now slapping both Gemini and Genesis with charges for pooling user funds: https://blockworks.co/news/genesis-gemini-charged-with-securities-violations-by-sec. Remembers it’s about 340k Earn users missing ~$900M.
- SBF created a substack and made a single post: https://sambf.substack.com/p/ftx-pre-mortem-overview
- I had the same reaction: wolfram|alpha can merge features with chatGPT to bring a ton of the computational wizardry over. https://writings.stephenwolfram.com/2023/01/wolframalpha-as-the-way-to-bring-computational-knowledge-superpowers-to-chatgpt/
- Another chapter in Behave, most on endocrinology:
- Even in the minutes before a decision is made, there’s a multitude of subliminal influence. Colors we see, words we read, smells we smell, sounds we hear. All of these affect our response inclinations drastically, even if we’re (feeling) fully at the driver seat.
- Endocrine system. Glands secrete hormones. They can have massive impact, just like neurotransmitters, but usually on a larger scale (both physically across more of the body, as well as longer time frame). The precursors are usually simple proteins and cholesterol found in food (similar to neurotransmitter precursor amino acids in food).
- “Testosterone makes us more willing to do what it takes to attain and maintain status.” That doesn’t alway mean aggression/dominance. Could be generosity or kindness. Its effect is very context and subject driven.
- Oxytocin and vasopressin increase partner and offspring bonding.
- Women experience regular hormone swings to much greater magnitude than men. Estrogen and progesterone move widely during ovulation.
- The stress response is necessary. Glucocorticoid levels increase. Your body emphasizes everything critical (blood pressure, heart rate, focus, etc). It ignores things that are not essential to save your life immediately (immune system, digestion, etc). This is perfect for acute physical threats, like escaping a lion. This is NOT good for sustained psychological threats, like work stress.
- The costco on jack northrop with the GIGANTIC walk-in freezer was a costco business center, not a costco wholesale. I don’t think they have that large butcher selection here.
- Played with substack. They use magiclinks (email) to login.
- Lots of private work.
-
- Another brain chapter in Behave.
- Hypothalamus controls the autonomic nervous system, the limbic system. Our behavioral and emotional responses. Sympathetic nervous system usually epinephrine and parasympathetic usually acetylcholine.
- The cortex does all our analysis. Frontal/parietal/temporal/occipital lobes. “The frontal cortex makes you do the harder thing when it’s the right thing to do.” Isn’t fully developed until midtwenties, wow.
- Amygdala controls aggression. And fear and anxiety.
- Dopamine, the reward system. But note that dopamine spikes at the ANTICIPATION of the reward equal or higher than the rewarding itself.
- Broadway week next week, buy 1 ticket get 1 free. I’ve seen a handful on the list already but the remainders I’m most interested in: Hadestown, Wicked, MJ.
- Ended up getting Hadestown.
- Robinhood now offers IRAs lol. And they match 1%.
- As of right now, there are 57 valid aws access keys in packages on pypi: https://tomforb.es/i-scanned-every-package-on-pypi-and-found-57-live-aws-keys/
- Gaia (mother earth, Terra, Earth) was the first. Bore everything. Her son Caelus (sky/heavens, Uranus) was her main partner and they had the titans, 6 male and 6 female. Primary couple was Cronus (father time, Saturn) and Rhea. The only other titan you probably know is Hyperion, who fathered Helios (both representing Sun). Cronus and Rhea had the first 6 of 12 olympians: Zeus (thunder, Jupiter), Hades (underworld, technically not an olympian, Pluto), Poseidon (sea, Neptune), Hestia, Demeter, Hera. Zeus and Hera then had the other olympians: Athena, Apollo, Artemis, Ares (Mars), Aphrodite (Venus), Hermes (Mercury), Hephaestus.
- CPI dropped 0.1% in december. Inflation slowed a little bit.
- Tons of private work.
- SBSC.
- Will do the league stuff (diff league per season to retain paid player specificity, user-created leagues, etc) when I convert the full app to ts/react (or maybe just the frontend). It will be a SPA with proper filter components, rather than hardcoded url subroutes.
- Changed the home route to the lb (instead of current-week-matchups).
- Updated the rules text for graceful handling of daylight savings.
- Updated the banner with the winner.
- The leaderboard issue, which I thought was going to be a quick fix, was not. The app believed it was week 1 of the 2022 season, and tried to pull lines/scores, etc. I don’t really know what happened, but the week18 data is gone. I’ll have to manually add some back. And the preseason/postseason checking logic needs to be rewritten. And airtight. If you’re not in an active week, no picks/lines/scores should ever be written. Will do tomorrow.
-
- SBSC.
- Added a few more people to the paid league.
- Payout distributions. Has to be discrete (obviously), not a continuous distribution.
- Like a probability mass function, but instead of all values (to infinity) adding up to 1, only the first n (the top players getting paid out). The probabilities representing the percentage of the purse received. Any tail at the end (since we’re going to n payouts, not inf) will go to the first place purse.
- Example discrete PMFs:
- Geometric = reduced by a constant factor every step.
- Logarithmic = reduces logarithmically every step (greater drops at first, flatter later).
- Added some rules about ending the logseries not at the top 25% of players, but rather where the minimum payout is equal to the buyin. Better.
- Wrote the pseudocode for the roundings to the nearest $10.
- Settled on a discrete logseries with p=0.9: https://en.wikipedia.org/wiki/Logarithmic_distribution
- CNY paperless, sent invites (diff set than friendsgiving for variety!) – christine/levi, josh/kati, harner, sarah, hannah, katie.
- Went to NYC Space Happy Hour!
- Varda is the queen of the stars in LOTR. Palantir is a seeing-stone (like the ones used by Saruman and Sauron) in LOTR.
