• Talked to the Best Buddies coordinators. They do monthly social hours (last thursday of every month at Q’s billiards in West LA. I’m going to go to the next one.
    • Night Crew Labs’ new website! https://www.nightcrewlabs.com/.
    • PW
      • Sklearn has a ton of cool machine learning capability. You can even do data analysis on text, finding correlations and such.
      • WSGI. Request handling and routing is different than application logic.
    • Squarespace is a very popular platform for building websites.
    • Ag will automatically skip folders like venv, so make sure to take that into account when searching for stuff that might be in site-packages.
    • Supercontest
      • Reinstantiated a lot of the flask-user routes. Played with them a bit. Tried to customize most of it by integrating the default forms and such into the navbar of my supercontest page. Ultimately decided against the customization. I can do it later, and right now I want to focus on function rather than style.
      • The navbar at the top is now in an ok place, with home, user, and signout.
      • Played with PyCharm a bit more.
      • SCP is great to move files between. It goes source -> destination. For example, to move the production db to your local dev machine, scp -i mykey southbaysupercontest.com:~/code/supercontest/data/supercontest.db ./test.db.
      • python manage.py db migrate -m “description of change” after you modify the models. Then go to an existing db and python manage.py db upgrade.
      • Pycharm allows you to enter an SQL console on the database in question, which is nice.
      • If you have an existing database with a version that isn’t tracked in the current history (the migrations folder), then internet might tell you to init/migrate/upgrade. This is fine, but it’s a shotgun approach. It’s a wipeover. If you know what version the old database is close to, you can just go into the db and overwrite the value in the alembic_version table, then upgrade as usual.
      • Copied the database over from the production server and upgraded it to the most recent model, which accommodates users and logins.
      • When pycharm is connected to the db, it locks it, so the app can’t write to it. You can disconnect in pycharm with a right-click.
      • The prod database now has a user! Me. I deleted the example user.
      • Aligned the th.