Merge branch 'master' of github.com:adamhrv/megapixels_dev

1 files changed, 17 insertions, 0 deletions

diff --git a/README.md b/README.md
index 5d17c304..ed692e40 100644
--- a/README.md
+++ b/README.md
@@ -9,12 +9,29 @@ FaceQuery.me, mozilla, nytimes
 - nvm, node
 
 ```
+conda install pytorch torchvision -c pytorch
+conda install faiss-cpu -c pytorch
+pip install numpy Pillow
+pip install dlib
+pip install requests simplejson click pdfminer.six
+pip install urllib3 flask flask_sqlalchemy mysql-connector
+pip install pymediainfo tqdm opencv-python imutils
+pip install scikit-image python-dotenv imagehash scikit-learn colorlog
+
 sudo apt-get install libmysqlclient-dev
 
 mkdir -p /data_store_hdd/apps/megapixels/faiss/indexes
 mkdir -p /data_store_hdd/apps/megapixels/faiss/metadata
 ```
 
+### MySQL note
+
+You may need to set the database charset to `utf8mb4` in order to import the CSVs:
+
+```
+ALTER DATABASE megapixels CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
+```
+
 ## Building the site
 
 ```