Decided that I wanted an audit db and service to help keep track of user behaviors.
Since I already have some in Redis, and some in Postgres I thought this might be a useful exercise.
The main thing id like to accomplish with this code is going to be a way to track events and break
them down by week/month/year per user and per company.
Im having some self debate about creating tables for the tallies or if I should just be creating
them on the fly using a query. I like the idea of the tally because it would be a place to easily
look that information up. Although if some error occurs it could possibly be inaccurate.
Deciding on a good schema, im thinking something like
Maybe just using rds would be a better fit. The amount of scanning would be pretty awful. Ok, abandoning idea!
---
updated: 25 June 2021.