psql: error: connection to server at "db.XXX.supabase.co" (35.176.XXX.XXX), port 5432 failed: Operation timed out
    Is the server running on that host and accepting TCP/IP connections?

dsn := fmt.Sprintf("user=%s password=%s host=%s port=5432 dbname=postgres", USER, PASSWORD, HOST)

failed to initialize database, got error failed to connect to `host=db.XXX.supabase.co user=alex.walker database=postgres`: dial error (dial tcp [64:ff9b::XXX:XXX]:5432: connect: no route to host)

NEW.updated_at := NOW();

updated_at

timestamptz

updated_at

timestamptz

NOW()

CURRENT_TIMESTAMP

NOW()

sql
BEGIN
  NEW.updated_at := NOW();
  UPDATE public.projects 
  SET updated_at = NEW.updated_at 
  WHERE id = NEW.project_id;
  INSERT INTO public.document_contributor (document_id, contributor)
  VALUES (NEW.id, NEW.created_by)
  ON CONFLICT
  DO NOTHING;
  INSERT INTO public.commits (message, created_by, project_id, document_id, created_at, previous_content, current_content)
  VALUES (NEW.note, NEW.updated_by, NEW.project_id, NEW.id, NEW.updated_at, OLD.content, NEW.content);
  RETURN NEW;
END

config.toml

toml
[inbucket]
# Port to use for the email testing server web interface.
pop3_port = 54326
port = 54324
smtp_port = 54325

# ...

[auth.email]
# Allow/disallow new user signups via email to your project.
enable_signup = true
# If enabled, a user will be required to confirm any email change on both the old, and new email
# addresses. If disabled, only the new email is required to confirm.
double_confirm_changes = false
# If enabled, users need to confirm their email address before signing in.
enable_confirmations = false

profiles
  user_id (pk)
  username 
  avatar_url

posts
  post_id (pk)
  user_id
  title
  description

let { data: posts, error } = await supabase
    .from('posts')
    .select('*, profiles(*)')

Database

(get_my_agency() = agency)

(agency contains(get_my_agencies())

sql
CREATE POLICY "files images are publicly accessible."
    ON storage.objects
    AS PERMISSIVE
    FOR SELECT
    TO public
    USING ((bucket_id = 'files'::text));

hashid

Object.assign(file, { test: 'test' });

return new Response(err.message, { status: 400 })

const { result } = await request.json();
  console.log(`Testing errors. Result requested: ${result}`)

  if (result === "success") {
    console.log('sending success')
    return new Response(JSON.stringify("You got a success"), {
      headers: { "Content-Type": "application/json" },
    });
  } else {
    console.log('sending error')
    return new Response("You got an error!", { status: 400, statusText: "Error" });
  }

const {data, error} = await supabase.functions.invoke("test-errors", {
    body: JSON.stringify({ result: "error" }),
  });
  console.log('Test Result: ', data, error);

Test Result:  {} null

localhost:3000/:salt/:hash/:password

valid

AuthApiError: Invalid login credentials

Error: Cannot find module 'config/postcss.config

information_schema

js
supabase
  .channel('public:countries')
  .on('postgres_changes', { event: 'DELETE', schema: 'public', table: 'countries' }, payload => {
    console.log('Change received!', payload)
  })
  .subscribe()