Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres WASM

supabase.com

Post reply on HN
Print view View original

171–180 of 190 posts

Re: Postgres WASM

#171

Post by neoberg »

robertlagrant wrote: post #123
tmpz22 wrote: post #118

Earlier quoted context omitted.

My comment doesn't assert Firefox or Safari are ahead on features. My comment is about Google/Chrome still being culpable as a market leader despite Apple (Safari) and Microsoft (IE legacy) likely slowing down browser development in general.

I don't understand what you're comparing Chromium to if you're saying it doesn't have features for business reasons, when the other browsers also don't have those features.

In almost every standards working group Google holds the most seats. It'd be naive to say that those in the groups are working only and only for the common good and don't pursue their employer's interests.

Re: Postgres WASM

#172

Post by cranium »

I love watching the WASM space evolve and get use cases like that. I feel it could become an easier Docker for people wanting to try programming with little fuss.

Re: Postgres WASM

#173

Post by isthisreality »

cranium wrote: post #172

I love watching the WASM space evolve and get use cases like that. I feel it could become an easier Docker for people wanting to try programming with little fuss.

> I feel it could become an easier Docker for people wanting to try programming with little fuss.

In a lot of ways, repl.it is doing this.

https://blog.replit.com/powered-by-nix

Re: Postgres WASM

#174

Post by mchaynes »

would it be possible to install an extension like postgis into this? if so, you might have saved me countless hours attempting to port gdal to wasm…

Re: Postgres WASM

#175

Post by vbezhenar »

burggraf wrote: post #47
alex_duf wrote: post #29

Earlier quoted context omitted.

Correct me if I'm wrong, but given your profile (I assume someone in the tech world), nothing stopping you from doing all of the above with a local pg. If installing is annoying you could run it in docker.

You're absolutely right, you can use a local pg. This just makes it easier for me, as it's sort of a "sandbox" environment and I can easily take snapshots to do A/B testing or roll things back. I can also send a snapshot to a coworker so they can get my entire environment with all my data in a few seconds.

You can do that with docker unless you’re running ARM and your friend uses x86

Re: Postgres WASM

#176

Post by miohtama »

dchest wrote: post #165
ankraft wrote: post #162

Earlier quoted context omitted.

Zstandard is able to compress this file to 1.4MB. a2b67f25.bin : 8.26% (16777216 => 1386514 bytes, a2b67f25.bin.zst)

brotli compresses it to 1047967 bytes. And you can serve it as-is with Content-Encoding: br, unlike zstd. (zstd at --ultra -22 level: 1149751 bytes).

Why is Brotli more efficient on Wasm files? I believe their built-in dictionary was tuned for HTML, CSS and JS content.

Re: Postgres WASM

#177

Post by burggraf »

mchaynes wrote: post #174

would it be possible to install an extension like postgis into this? if so, you might have saved me countless hours attempting to port gdal to wasm…

Yes, we can include postgis. I'm currently investigating how to include other PostgreSQL extensions as well. A fair number of standard extensions are already included, but there are more we need for a full Supabase implementation.

Re: Postgres WASM

#178

Post by [deleted] »

miohtama wrote: post #176
dchest wrote: post #165

Earlier quoted context omitted.

brotli compresses it to 1047967 bytes. And you can serve it as-is with Content-Encoding: br, unlike zstd. (zstd at --ultra -22 level: 1149751 bytes).

Why is Brotli more efficient on Wasm files? I believe their built-in dictionary was tuned for HTML, CSS and JS content.

[deleted]

Re: Postgres WASM

#179

Post by robryk »

miohtama wrote: post #176
dchest wrote: post #165

Earlier quoted context omitted.

brotli compresses it to 1047967 bytes. And you can serve it as-is with Content-Encoding: br, unlike zstd. (zstd at --ultra -22 level: 1149751 bytes).

Why is Brotli more efficient on Wasm files? I believe their built-in dictionary was tuned for HTML, CSS and JS content.

I'd guess that the context model (based on last 1-2 bytes) can be used to separate opcodes and their parameters.

Re: Postgres WASM

#180

Post by javcasas »

Can I have the opposite? I want to be able to run webassembly-based extensions in postgresql. I don't like writing C, and most postgresql languages offer too much (no sandboxing, need slow interpreters and shit). But a WASM based sandbox for creating custom functions for postgres in your favourite WASM-outputting language sounds very interesting
Post reply on HN