Block a user
Add auth endpoints
thinking about how to accomplish Sign In With Twitch.
we probably want email addresses so we can communicate with people regarding account actions, breaking changes, security breaches, &c. we…
WIP: auth
w/b this kind of thing
CREATE TABLE session(
"token" BYTEA PRIMARY KEY NOT NULL,
"user_id" UUID NOT NULL REFERENCES user_data("id"),
"expires" TIMESTAMP NOT NULL,
…
WIP: auth
The idea is to avoid the need for a join on every API call to check whether the user is allowed to do an action because they're a moderator. Perhaps this could be a materialized calculation…