We need to create more comprehensive self hosting instructions in the readme. As a follow up to #34.
It should be documented that google needs to be enabled as an auth provider in supabase with some helpful instructions on how to set it up.
Documentation on how to create tables in supabase. Was able to run the sql from server/sql_setup/tables/ in the subabase SQL editor to create the tables.
Documentation on how to create functions in supabase. We created them manually in the database -> functions tab. Currently two functions need to be created with the names deduct_rate, and get_attempt_aggregates. Functions definitions can be found at server/sql_setup/functions/
deduct_rate
Inputs: input_api_key (text), rate (integer)
Return type: integer
Advanced settings language: plpqsql
get_attempt_aggregates
Input: user_id (uuid)
Return type: jsonb
Advanced settings language: sql
Documentation on how to initialize these resources automatically if possible.
We need to create more comprehensive self hosting instructions in the readme. As a follow up to #34.
googleneeds to be enabled as an auth provider in supabase with some helpful instructions on how to set it up.server/sql_setup/tables/in the subabase SQL editor to create the tables.database->functionstab. Currently two functions need to be created with the namesdeduct_rate, andget_attempt_aggregates. Functions definitions can be found atserver/sql_setup/functions/deduct_rateinput_api_key(text),rate(integer)integerget_attempt_aggregatesuser_id(uuid)jsonb