- 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;
}