Simple proof of concept (apologies for poor code quality and shortcuts) to provide realtime notifications for DB changes. Prototype for a project that was never released, meant to illustrate a) how to implement realtime WebSocket notifications and b) the difference between realtime and polling.
Somewhat convoluted right now. I may bake this into a script at some point.
- Start a postgres server. Your credentials will be read from env vars:
The default values for the environment variables used are:
PGHOST='localhost'
PGUSER=process.env.USER
PGDATABASE=process.env.USER
PGPASSWORD=null
PGPORT=5432
- Populate the DB:
psql -d $DB_NAME -f db.sql(replace$DB_NAME) cd $REPO_ROOT/server- Start two processes:
node server,node ws cd $REPO_ROOT/app && npm start