• Thursday

    • Equinox in the morning? First time in a couple years. Always night.
    • Rode the ducati to Soho Diner in the workday morning for bfast which was nice – need to hit more diners in manhattan. Caught up with Scott.
    • Private work.
    • Spotify and vscode desktop version upgrades.
    • Signed the extra resident parking spot for Mike. Check on bill in a bit. Made task on cal.
    • Caught up with Teague for the first time in a while.
    • You can pass the proper RDS/Aurora endpoint for the postgres instance to psql to connect directly, as if local.
    • SBSC. Did some optimization with flask-debugtoolbar and flask-caching.\
    • map_picks is the longest part of the results views. That call alone takes about a quarter of a second. Iterates over all picks.
    • Routes, templates, flask.g, and profiler all work fine – the sqlalchemy tab shows 0 queries (which is wrong).
    • Could parallelize a lot further. Plots could all be built in separate threads, being passed a serialized query result set. Same for results
    • Flask-debugtoolbar has a bug and doesn’t scroll. https://github.com/ckan/ckan/issues/6995. Just add a new style rule:
    #flDebug, #flDebug * {
    overflow-y: auto;
    }