Database Catchall

As a developer, I want to get better at using my database as a persistent store.

### Things to explore

- ensure the database can only be accessed when we are on same host / network
- turn on your database’s slow query logging feature and see if any slow queries occur frequently
- `EXPLAIN ANALYZE` [link1](https://www.revsys.com/writings/postgresql-performance.html) [link2](craigkerstiens.com/2013/01/10/more-on-postgres-performance/)
- https://docs.djangoproject.com/en/2.2/topics/db/transactions/#django.db.transaction.on_commit

### Postgres Performance

- wiki.postgresql.org/wiki/Detailed_installation_guides
- wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
- revsys.com/writings/postgresql-performance.html
- craigkerstiens.com/2012/10/01/understanding-postgres-performance
- craigkerstiens.com/2013/01/10/more-on-postgres-performance
- Book: PostgreSQL 9.0 High Performance