A simple application using the documented authorization features of postgrest.
Switch branches/tags
Nothing to show
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.
deploy
revert
t
verify
README.md
sqitch.conf
sqitch.plan

README.md

PostgREST Authentication Example/Starting Point

This application can be used as a starting point for PostgREST authentication based on a Devise installation.

Database setup, management, and configuration is done via sqitch. One of the components of the installation creates a Devise based Users table, simply comment out the contents of deploy/devise_test.sql and update the users_view.sql to point at the appropriate table.

Functions

  • auth.request_password_reset(identifier TEXT)
  • auth.reset_password(identifier TEXT, token UUID, pass TEXT)
  • auth.signup(username TEXT, email TEXT, pass TEXT, role TEXT)
  • auth.confirm(token UUID, role TEXT)
  • auth.login(identifier TEXT, pass TEXT, exp INTEGER=NULL)
  • auth.change_password(identifier TEXT, current_password TEXT, new_password TEXT, confirm_password TEXT)