-
I am really new to sql in general and want to use python in my functions, because I need to use postgis. It's not listed in the extensions list and enabling via
|
Beta Was this translation helpful? Give feedback.
Replies: 3 comments 5 replies
-
Hi @Vinzent03, we are not planning to offer untrusted extensions in Supabase in the near future. It is hard to limit the functionality of these untrusted extensions and a malicious user can make the platform unsafe for everyone. |
Beta Was this translation helpful? Give feedback.
-
Why is the Python extension a problem but the JS and Java ones are not? |
Beta Was this translation helpful? Give feedback.
-
for those interested in how to enable plpython3u for self-hosted supabase via docker. remove the image from docker-compose.yml and extend it by using a custom Dockerfile using the same image. here is how to install plpython3u for supabase: diff --git a/docker/docker-compose.yml b/docker/docker-compose.yml
index 5060991..b3041b6 100644
--- a/docker/docker-compose.yml
+++ b/docker/docker-compose.yml
@@ -378,7 +378,6 @@ services:
# Comment out everything below this point if you are using an external Postgres database
db:
container_name: supabase-db
- image: supabase/postgres:15.1.0.103
healthcheck:
test: pg_isready -U postgres -h localhost
interval: 5s
@@ -410,6 +409,9 @@ services:
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
PGDATABASE: ${POSTGRES_DB}
POSTGRES_DB: ${POSTGRES_DB}
+ build:
+ context: .
+ dockerfile: "./postgres/Dockerfile"
volumes:
- ./volumes/db/realtime.sql:/docker-entrypoint-initdb.d/migrations/99-realtime.sql:Z
# Must be superuser to create event trigger
Now you will find the extension listed on the dashboard under http://localhost:8000/project/default/database/extensions |
Beta Was this translation helpful? Give feedback.
Hi @Vinzent03, we are not planning to offer untrusted extensions in Supabase in the near future. It is hard to limit the functionality of these untrusted extensions and a malicious user can make the platform unsafe for everyone.