Reid Hewitt

postgres native [notify/listen](https://www.postgresql.org/docs/current/sql-notify.html)

other than pg_cron i'd like to avoid installing any other additional extensions or 3rd party libraries

[flask-socketio](https://flask-socketio.readthedocs.io/en/latest/getting_started.html). using websockets gets us full-duplex communication which seems ideal for pub/sub. [example of app](https://stackoverflow.com/questions/49462024/combining-socketio-and-simple-web-server-in-same-app-using-background-task) with both normal routes and sockets

here's the [pg_cron branch](https://github.com/GSA/datagov-harvesting-logic/tree/pg_cron). at the time of this comment all it does is install it, add the extension, and add a cleaning/vacuum job to be performed every minute. i...

it seems that we're moving away from having postgres be responsible for job scheduling and initialization in favor of having flask do it. one reason is that postgres logs aren't...

i updated the title of this ticket to a spike since that's what it ended up like