Vote for more plugins

[kiwicopple]

This issue is for tracking requests/demand for more plugins/extensions. Give a thumbs up if you want an extension added.

Please refrain from adding comments unless you are adding an extension which isn't already listed.

[kiwicopple]

plv8 - https://github.com/plv8/plv8

[kiwicopple]

PL Python enabled by default on template1 - https://www.postgresql.org/docs/current/plpython.html

[shah]

PL Java would be great - https://github.com/tada/pljava.

Also, ARG based build which would enable/disable certain plugins might also be helpful.

Great work by the way, love the Dockerfile.

[kenahrens]

Timescale - https://github.com/timescale/timescaledb

[shah]

plpgsql_check for linting and validating SQL code quality.

[kiwicopple]

@kenahrens we will have to confirm but it looks like Timescale's license prohibits us from installing it on our platform. While we could still bake it into the image for personal use, we will focus first on permissively licensed plugins which we can use ourselves. It's a shame - I personally would love to offer Timescale/timeseries on supabase. If I'm wrong about the license, please let me know!

[kenahrens]

@kiwicopple - Thank you for the clarification. It seems their own code uses 2 different licenses, and the code inside the binary has at least some code with the Timescale License. And that license can't mesh with yours. 😞

Here is a summary of their license:
https://github.com/timescale/timescaledb/blob/master/LICENSE

And you can see the tsl library (which is really what you want) only uses their Timescale License:
https://github.com/timescale/timescaledb/tree/master/tsl

I found that DigitalOcean offers this extension in their managed database product, but failed to find anything about the licenses:
https://www.digitalocean.com/docs/databases/postgresql/resources/supported-extensions/

[kiwicopple]

I found that DigitalOcean offers this extension

Very interesting. Perhaps it's possible then. I'll dig a little deeper or raise an issue in their repo

[felixyz]

wal2json

[Takashiidobe]

I would like to see pg_cron on here, although I don't know about the licenses.

[kiwicopple]

@Takashiidobe Looks like it's PG license :) https://github.com/citusdata/pg_cron/blob/master/LICENSE

We can add it if there's enough interest

[SvenVandenbrande]

@kiwicopple

The license for Timescale has been changed
https://blog.timescale.com/blog/building-open-source-business-in-cloud-era-v2/

[kiwicopple]

🎉 I saw! I reached out to the CEO a while back. I'll try again and see if he will allow it in our platform. There are still parts of their license which make me nervous - I want to make sure I've got written approval from him. Thanks for the update @SvenVandenbrande

[SvenVandenbrande]

Would be great.

Would love to store some timeseries. 😄 For my domotica system.

[kiwicopple]

Hey @SvenVandenbrande - I got an email back from the founders. Unfortunately their license won't allow it because we're a hosted platform. We would love offer it here, but we use this build within Supabase itself.

I understand their stance - they have their own hosted platform. Perhaps at some stage we can build in some simple timeseries functionality of our own for your domotica system :) (with help from you???)

[SvenVandenbrande]

@kiwicopple Sounds great. What's the best way to get in contact with you? 😄

[psolymos]

PL/R would be great! https://github.com/postgres-plr/plr and https://access.crunchydata.com/documentation/plr/8.3.0.18/