search

tcdi / plrust

A Rust procedural language handler for PostgreSQL
PostgreSQL License
1.1k stars 32 forks source link

Publish to https://database.dev/ #402

Open JensGM opened 6 months ago

JensGM commented 6 months ago

Hey,

The guys over at supabase has created a package manager for trusted extensions, https://database.dev/. It would be super smooth for us, as supabase users, to adopt plrust if it was made available there aswell 😁

Jens

eeeebbbbrrrr commented 6 months ago

We'd definitely be open to collaborating with them. Have you raised this with Supabase?

eeeebbbbrrrr commented 6 months ago

https://supabase.github.io/dbdev/extension_structure/

This indicates it's limited to supporting SQL-only extensions. It's not clear to me what work they'd need to do to offer the PL/Rust extension, so that users can then publish their own extensions to dbdev that contain LANGUAGE plrust functions.

eeeebbbbrrrr commented 6 months ago

UPDATE: I asked @kiwicopple about this -- we'll see what happens.

olirice commented 6 months ago

supabase has created a package manager for trusted extensions

database.dev is a trust language extension (TLE) registry. plrust is one of those trusted languages so you can already upload any plrust TLE to it. The supabase platform doesn't currently support plrust so you wouldn't actually be able to install them in your instance, but the dbdev part is good to go.

plrust if it was made available there aswell (supabase)

We've looked into plrust and intend to adopt it. We paused our implementation last year because the resource consumption on lower end hardware, e.g. free tier, was too high and could potentially interrupt DB operation. We hadn't previously gated extensions/PLs to a minimum level of hardware so we developed a mechanism to constrain extension resources such that they can fail gracefully.

It's on the roadmap but we don't have an exact timeline

eeeebbbbrrrr commented 6 months ago

It's on the roadmap but we don't have an exact timeline

Thanks for the info, @olirice. Don't hesitate to let us know if there's anything we can do.

olirice commented 6 months ago

Any chance you could produce the arm deb artifacts for v1.2.7?

It looks like that ran in CI but the artifact aren't associated with the release

BradyBonnette commented 6 months ago

Hi @olirice

We are currently working on that. Somehow the build "succeeded" back then, but then "successfully failed" (❓) to upload the artifacts for aarch64.

We will drop you a line when it's ready for you :)

BradyBonnette commented 6 months ago

@olirice

Update: we fixed it -- https://github.com/tcdi/plrust/releases/tag/v1.2.8

Let us know if you find anything else!

olirice commented 6 months ago

Awesome, thank you!