Very brief installation notes
- Install postgres server
- Install python
- pip install -r requirements.txt
- Get config.ini from tech 1password vault
- brew install dbmate
- There should be an analytics dotenv in your Credentials Repository. Symlink it into .env
- Install pgtap
We use dbmate to migrate the database schema. See the migrations in /db/migrations/. It stores the current schema in /db/schema.sql.
The raw table is one giant document store. To make it more query-friendly, we create views for each event type we need, such as event_navigate.