Hacker News Reader

Hacker News

Comment by lioeters | Hacker News Reader

Full thread

lioeters

Seems like Supabase deserves a mention, with their contributions to the Postgres ecosystem.

https://supabase.com/

pg_graphql - https://supabase.com/blog/pg-graphql-v1

pg_jsonschema - https://supabase.com/blog/pg-jsonschema-a-postgres-extension...

Postgres WASM - https://supabase.com/blog/postgres-wasm

..And other open-source features.

View on HN

We want to write a paper on the vast extensions ecosystem for Postgres at some point. It's on my TODO list for 2023.

Having so many plug-ins/add-ons available is unique to Postgres and due to Stonebraker's original vision of including extensibility as a first-class design principle in the DBMS.

I didn't know that and it would make for an interesting historical article in its own right.

In doing so, it would be great if you could provide details around extension safety. I've heard that some extensions may not play nicely in combination with others, and it would be really nice to know how one is to vet extensions for use in production.

Supabase didn't do Postgres WASM first, wasmer did FYI (3 years ago)

https://github.com/wasmerio/wasmer-postgres

(supabase ceo)

these are two different things - wasmer runs WASM code inside postgres (as an extension), whereas our implementation runs an entire Postgres server as WASM (eg, you can run it in a browser: wasm.supabase.com)

We weren't the first to do this though - CrunchyData was. Theirs wasn't open source, so we worked with Snaplet to build an open source version and added networking: https://news.ycombinator.com/item?id=33067962

My mistake, I fully eat crow, and this is what I get for not reading the thing I argued against!

I want to ask a question to the engineers with experience in WebAssembly.

Last year I invited a student to compile ClickHouse with WebAssembly. But the task appeared harder than expected, supposedly due to poor 64-bit support in WASM.

Here is a pull request: https://github.com/ClickHouse/ClickHouse/pull/37871 that we have to close because it is unfinished.

I suspect maybe we can get the result with some additional effort...

Also Planetscale

edit: I'm okay with being downvoted, but I'm honestly asking why, not complaining. Is Planetscale not an interesting database?

fwiw, I don't get the downvotes either

Possibly lack of context. Without the edit, I would assume you're going for a version of "webscale" meme about postgres. (Haven't heard of planetscale before)

Ah interesting. Nope, definitely talking about a real database. I think cloud native is interesting, and two solutions I’m aware of in the space are CockroachDB and Planetscale.

Reply on news.ycombinator.com