search

CodeWithAsheville / court-notifications

GNU General Public License v3.0
11 stars 10 forks source link

11/20/2021: Upgrade Heroku Postgres to Standard & set up backups #102

Closed ejaxon closed 2 years ago

ejaxon commented 2 years ago

The production app is now running against a Standard-0 database, with daily backups. Also created credentials for the County data analyst to pull reports.

jayhill commented 2 years ago

@ejaxon Could you please expound on the access that the County Data Analyst has and how that arrangement came to be?

ejaxon commented 2 years ago

Sure. Per this comment I met with the analyst at the County that has been supporting the SJC efforts to reduce jail population to discuss what data could be used to measure and improve impact. As a result I added two reporting tables, one for subscriptions and one for notifications (log_subscriptions and log_notifications). The goal is to try to (a) use subscription information to keep encouraging the court system to promote the system and (b) try to assess the impact of notifications on reduced FTA rates.

The primary reason for this is to try to make sure that we're having a positive impact. A secondary reason is that I want to have as much justification as possible in the event that the state court system decides to thwart our use of their public site to pull court date information.

The analyst has read-only access to these two tables, which do not include any subscriber information - only whether a subscription occurred or a notification was sent.