How to create and schedule Edge functions on self hosted Supabase (Docker)?

[Tom-De-Backer]

I have self hosted Supabase via container on a VM. I would like to add some edge functions to this Supabase instance, but there seems to be an issue. I have already added the cron integration, where I am trying to add a new job via this screen:

The first thing that seems not right is: Supabase tells me "No edge functions created yet". However, there is a 'main' and a 'hello' function as an example in the docker github of Supabase. So I assume these functions should have been shown there. However, I try to create a new function but that does not work. The webpage shows a supabase logo that is running forever.

What is going wrong here?
This is the studio version I use: supabase/studio:20241202-71e5240
The functions container in docker-compose.yml looks like this:

  functions:
    container_name: supabase-edge-functions
    image: supabase/edge-runtime:v1.66.4
    restart: unless-stopped
    volumes:
      - ./volumes/functions:/home/deno/functions
    depends_on:
      analytics:
        condition: service_healthy
    environment:
      JWT_SECRET: ${JWT_SECRET}
      SUPABASE_URL: http://kong:8000
      SUPABASE_ANON_KEY: ${ANON_KEY}
      SUPABASE_SERVICE_ROLE_KEY: ${SERVICE_ROLE_KEY}
      SUPABASE_DB_URL: postgresql://postgres:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}
      # TODO: Allow configuring VERIFY_JWT per function. This PR might help: https://github.com/supabase/cli/pull/786
      VERIFY_JWT: "${FUNCTIONS_VERIFY_JWT}"
    command:
      [
        "start",
        "--main-service",
        "/home/deno/functions/main"
      ]

[sscarduzio]

@Tom-De-Backer did you ever solve or work around this successfully?

[Tom-De-Backer]

@Tom-De-Backer did you ever solve or work around this successfully?

No, I am still looking for solutions. Hope to see one in the comments here...

[lukas-runge]

@sscarduzio & @Tom-De-Backer as there seems to be no support for self hosted instances within the supabase functions cli as of now the only way to deploy on a self hosted edge-runtime is to manually upload the functions, as pointed out by this reddit comment: https://www.reddit.com/r/Supabase/comments/1gab139/comment/ltf5z94

You can then use the HTTP Request type in the cron job config to call your function in regular intervals. It ain't pretty - but it works. 🙌

[JLAcostaEC]

At the moment this is the only thing that can be done, I think the problem is that there is no schema/table to manage these records in self-hosted

[Tom-De-Backer]

At the moment this is the only thing that can be done, I think the problem is that there is no schema/table to manage these records in self-hosted

What schema/table to manage the records is needed? Can I create those manually myself to solve the problem?

[JLAcostaEC]

At the moment this is the only thing that can be done, I think the problem is that there is no schema/table to manage these records in self-hosted

What schema/table to manage the records is needed? Can I create those manually myself to solve the problem?

I don't really know, I say it in the sense that maybe that is the reason, but maybe it is much more complex than that.