wasmer-postgres

I was expecting https://github.com/wasmerio/wasmer-postgres#usage--documenta... to catch on, and some how must have gotten it mixed up with Trusted Language Extensions <https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Postg...> (and https://github.com/aws/pg_tle/tree/v1.4.0#getting-started ) but unless someone decides to implement every single bit of a modern PG extension in JS (or Perl), that's just some hello-world nonsense

Supabase didn't do Postgres WASM first, wasmer did FYI (3 years ago) https://github.com/wasmerio/wasmer-postgres

This exists, but with limitations: [0][1] [0]https://medium.com/wasmer/announcing-the-first-postgres-exte... [1]https://github.com/wasmerio/wasmer-postgres

I believe the team at Wasmer have worked on something like this: https://github.com/wasmerio/wasmer-postgres It only works for PG10, but I can't imagine it will take much effort to bring it up to the latest version

> Please don't tell me that someone compiled Postgresql to WASM. I don't believe that nobody has ever done this... And google delivers: https://github.com/wasmerio/wasmer-postgres

Technically, it can be integrated with Postgres with https://github.com/wasmerio/wasmer-postgres. That said, it makes little sense to integrate this at the database level since it'll bloat up the column size, unless just the encrypted integer is stored (without converting to a base58 string). As for collisions, a hash function maps an input of any length to an output of fixed length, so collisions will happen eventually. What I'm using is encryption, which cannot collide, otherwise decryption would be impossible https://crypto.stackexchange.com/questions/60473/can-collisi...

This is really cool! The only other similar thing I know of is WASMer's extension (which only supports Rust atm I believe): https://github.com/wasmerio/postgres-ext-wasm One question though: If you built and compiled an extension with this, how would you deploy it on top of a Postgres Docker image? I see instructions for installing and testing locally, via the cargo command, but couldn't find anything on this. Does it spit out a static asset that you put in the project folder, and copy over during the build pipeline? Something like: FROM postgres:12-alpine COPY ./my-rust-extension /some/container/directory RUN install-command-here