Unfortunately python for Postgres is only available as an untrusted language extension, which can provide avenues for things like privilege escalation[0]
We’ve decided to only bundle trusted language extensions so that there is a balance between flexibility when it comes to users writing their own procedures, all while maintaining security.
Supabase Engineer here, happy to answer any questions!
We've made a Prometheus-compatible metrics endpoint[0] available to our customers for quite a while now, which is actively used by customers to monitor their projects.
Setting up a metrics scraper and a Grafana instance, all while figuring out how and where to host it can pose a lot of friction for folks which haven't had much hands-on infrastructure experience.
This aims to cut down on that friction, and allow everybody to deploy it on Docker-compatible platforms and services, such as Fly.io.
The included dashboard has significant overlap with what Supabase is using internally to monitor and debug project infrastructure.
PHP is still very web focused (server side), Javascript is a much better general purpose language, with more domains where it can be used and IMO a way much better language than PHP.
I agree that JS is a better general-purpose language than PHP, but it's still about as "Web focused" as PHP.
As far as general-purpose scripting languages go, it seems like Python has been the go-to choice in a whole bunch of domains for a couple of decades, for example:
- Unix scripting (the reason it's part of almost every distro's base install; I think even OSX includes Python)
- Desktop GUIs (GTK, wxWindows, tk, etc.)
- Non-Web, performance-insensitive games (i.e. pygame); these have always been outnumbered by Web games though, mostly with Flash and recently some with Javascript/HTML5.
- Scientific computing and data analysis (numpy, scipy, pandas, etc.); R, MATLAB, etc. are big too, but I wouldn't call them general-purpose.
About five years ago, I would occasionally run across some non-Web thing written in Ruby; i.e. I would find a CLI program which claimed to solve whatever problem I was tackling, then after about an hour battling with rubygems I'd rage quit and move on.
Within the past couple of years I've noticed a trend that these sorts of projects now tend to be written in Javascript, and its npm which makes me nope out after an hour.
Still, those have only been a tiny proportion of the applications I run across, so I certainly wouldn't recommend Javascript (or Ruby) as a general purpose language for publically distributed, non-Web applications, since a) their installation mechanisms don't seem battle-tested enough and b) very few people seem to be using them in that way.
If we're pulling alternatives out of a hat, I'd say that extrapolating the line from PHP to JS (i.e. more consistency, less bloat, fewer spandrels, safer by default, etc.) we'd reach Racket.
1) Carefully choose the people that are going to sit next to you whenever "the big thing of your life" is going to happen.
2) ALWAYS, but ALWAYS use contracts, even when doing something together with your relatives, long-life friends and "that guy from university which was ever helpful".
3) Think you're worth more than you're getting? Ask away.
4) Learn to accept critique and not dismiss it. Accepting it and making efforts to improve on its basis is the way towards personal (and professional) growth.
5) Nobody is always right, learn how to gracefully lose a dispute.
6) Take time for yourself, don't rush head-first into any opportunity, don't accept every invitation, learn how to refuse. This will save you time, headaches and integrity.
We’ve decided to only bundle trusted language extensions so that there is a balance between flexibility when it comes to users writing their own procedures, all while maintaining security.
[0] https://www.postgresql.org/docs/current/plpython.html