Skip to content
a demo set of postgres tables, row-level security migrations, and accompanying web app
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
.gitignore
migrate.sh
package.json
project.code-workspace
psql-admin.sh
psql-commerce.sh
readme.md
tsconfig.json
yarn.lock

readme.md

super-commerce

a minimal viable demo of showing how to pragmatically:

  • apply row-level security policies via postgresql, and
  • integrate with rls protected resources in a web application

see cdaringe.com/protect-bacon-with-rls for a guided tour.

usage

prereqs

  • install docker for running an ephemral postgres instance
  • install nodejs for running the application server
  • install yarn package manager to install dependencies
  • consider reviewing thesrc/migration/###-<name>.sql migration sql files
    • it's worth seeing how rls is being implemented!

run

  • run yarn in the project root. this will:
    • purge any existing commerce database
    • fire up a new db
    • migrate the db
    • compile the typescript files
    • run the server application, attached to the database
  • kill/purge the db - ``yarn db:container:kill`

follow the onscreen instructions for more.

You can’t perform that action at this time.