mostly software engineering

Was able to get the facial verification process started for Binance. Should receive an email within a few days, then I can link my Binance account to cointracker, export a csv with all transactions, attach it to turbotax, file taxes, and delete the binance app from my phone.

Nice, actually got verification later today. Added an API key for cointracker to my binance account, so I should have full tax info now.
In order to get the forms necessary to input to turbotax, you have to buy the cointracker tax plan. This is bullshit. It's $49. I did it for convenience, but that's an insane fee.
Total capital loss was about $6.2k. The max you can claim in a single tax year is 3k, so this will last me two years (2019's is called a capital loss carryover).

Another new thing: royalty distribution from my mesabi trust cbi shares. Reported on 1099-MISC, had to claim on Schedule E. Was only $42.

Changed my medium digest back to daily. I just skim over the weekly and never look at anything. The daily would spark something cool every morning.
My confluence space at SpaceX is actually saved. The user account is inactive, but all of the content is preserved: blog, pages, comments, everything.
PW

New versions of pycharm and django.
Remember, Selenium can do more than just load dynamic content (js) into the dom for you. It can simulate the clicking of buttons, text input, scrolling, downloading, changing cookies, etc.

sh returns 127 when it can't find the executable on path.
systemctl communicates with systemd over dbus.
Great collection of flask+nginx dockerfiles: https://github.com/tiangolo/uwsgi-nginx-flask-docker.
Bottled this kombucha brew for second fermentation, finally. Used apple cider. The final brew time was 6 weeks, about 3x as long as usual. The cultures were super old and took forever, but the pH is ~2.5 and it's slightly tart. I added a little extra apple juice to bring the sweetness back up. Second fermentation should go in the fridge on Monday afternoon, 4 days is fine.
Supercontest.

Docker caches previous build results so you can step through a dockerfile as you develop on it.
Read a lot about docker-compose and the final config of server/app/db in 3 separate containers. Gonna upgrade to postgres and python 3 first, then come back to that. Then enable backups.
Changed the password for the southbaysupercontest@gmail.com account. It was getting correct-password attempts from elsewhere. It's now stored in my personal Google account.
You can migrate a database to another type. Often, it means "dumping" the current db into a single file of pure SQL commands, which most databases' CLI allows you to do. Then you can import it into another database.

This is also how backups often work. You just recreate the db from a dumped file.
There are tools to perform this migration for you. pgloader is the main one to convert into Postgres, which is what I used to migrate the Supercontest db from sqlite.

sudo apt install postgresql postgresql-contrib postgresql-client postgresql-client-common libpq-dev pgloader
pip install psycopg2 (inside the sc venv)
Added `export PGDATABASE=supercontest` to ~/.bashrc so that psql would by default connect to supercontest. To ingest, restart bash by simply typing bash.
sudo -u postgres createuser --username=supercontest --superuser --pwprompt # run the command as the postgres user to create the auth that the app uses
sudo -u postgres createdb supercontest # create the new db. dropdb is opposite
pgloader ./data/supercontest.db postgresql:///supercontest
Helpful commands inside psql:

Thursday, April 4, 2019