official style guide: python.org/dev/peps/pep-0008 using flake8 for url params, use _, not - database engine: mysql fixture actually not for dumpdata/loaddata python manage.py collectstatic installing mysql db: conda install -c bioconda mysqlclient pip install pymysql https://hsunnystory.tistory.com/76?category=794803 https://12teamtoday.tistory.com/53 GCP to use speech-to-text api https://github.com/googleapis/python-speech/tree/master/samples/microphone Tutorial: https://webnautes.tistory.com/1247 PyAudio: https://medium.com/@wagnernoise/installing-pyaudio-on-macos-9a5557176c4d https://cloud.google.com/docs/authentication/getting-started NRCLex: https://github.com/metalcorebear/NRCLex ref) https://pypi.org/project/NRCLex/ about Postgres database: https://postgresapp.com/ ref: two-scoops-of-django 배포 https://nerogarret.tistory.com/47?category=800142 Install all the requirements in venv DB: https://minwoo2815.tistory.com/64 https://blog.boxcorea.com/wp/archives/2702 sudo apt-get install python3-dev python3 import nltk nltk.download('stopwords') nltk.download('wordnet') https://stackoverflow.com/questions/46619039/django-db-utils-operationalerror-1045-access-denied-for-user-rootlocalho/46619093 flush privileges; migrate python3 -m textblob.download_corpora home/ubuntu/nltk-data https://stackoverflow.com/questions/35861482/nltk-lookup-error mv nltk_data to django-nlp