Create documentation on installation procedure

[virginiascarlett]

I think Mike would find this reassuring, and we'll want to do it eventually anyway

[virginiascarlett]

Rob can write up the low-level stuff, basically explaining the architecture of our stack. Not a step-by-step guide, just the broad strokes.
Virginia can do the user guide, which is more of a step-by-step instruction manual for the next librarian.

[virginiascarlett]

UPDATE: I FINALLY got this working on my mac. Here's what I had to do to install:
Clone the repo + create venv, as described in our docs.
Install MySQL version 8.0.32 for MacOS13 (even though I’m running MacOS 14) from here: https://downloads.mysql.com/archives/community/
Do:
export PATH=$PATH:/usr/local/mysql/bin (or wherever MySQL was installed)
Do a find command to figure out where this file is located: mysqlclient.pc
Then use that path in this command:
export PKG_CONFIG_PATH=$PKG_CONFIG_PATH:/usr/local/mysql-8.0.32-macos13-arm64/lib/pkgconfig
Then set a few more environment variables:

export MYSQLCLIENT_LDFLAGS=$(pkg-config --libs mysqlclient)
export MYSQLCLIENT_CFLAGS=$(pkg-config --cflags mysqlclient)
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$PATH

Then, while in the dis venv, do:
pip install mysqlclient==2.1.1 --no-cache-dir
(The --no-cache-dir is important)

DONE. I edited my ~/.bashrc to include this: (actually it's ~/.zshrc because new macs use zsh instead of bash)

#Add mysql and mysql_config to PATH
export PATH=$PATH:/usr/local/mysql/bin
export PKG_CONFIG_PATH=/usr/local/mysql-8.0.32-macos13-arm64/lib/pkgconfig
export MYSQLCLIENT_LDFLAGS=$(pkg-config --libs mysqlclient)
export MYSQLCLIENT_CFLAGS=$(pkg-config --cflags mysqlclient)
export DYLD_LIBRARY_PATH=/usr/local/mysql/lib:$PATH

Related forum links:
PyMySQL/mysqlclient#584
https://stackoverflow.com/questions/63109987/nameerror-name-mysql-is-not-defined-after-setting-change-to-mysql