4 ms·

Seems like Supabase deserves a mention, with their contributions to the Postgres ecosystem. https://supabase.com/ https://supabase.com/ pg_graphql - https://s

Seems like Supabase deserves a mention, with their contributions to the Postgres ecosystem. https://supabase.com/ https://supabase.com/ pg_graphql - https://supabase.com/blog/pg-graphql-v1 https://supabase.com/blog/pg-graphql-v1 pg_jsonschema - https://supabase.com/blog/pg-jsonschema-a-postgres-extension-for-json-validation https://supabase.com/blog/pg-jsonschema-a-postgres-extension... Postgres WASM - https://supabase.com/blog/postgres-wasm https://supabase.com/blog/postgres-wasm ..And other open-source features.

apavlo 4y ago
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.
- dang 4y ago
  I didn't know that and it would make for an interesting historical article in its own right.
- whitepoplar 4y ago
  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.
danielvaughn 4y ago
Also Planetscale edit: I'm okay with being downvoted, but I'm honestly asking why, not complaining. Is Planetscale not an interesting database?
- mritchie712 4y ago
  fwiw, I don't get the downvotes either
- viraptor 4y ago
  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)
  - danielvaughn 4y ago
    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.
gavinray 4y ago
Supabase didn't do Postgres WASM first, wasmer did FYI (3 years ago) https://github.com/wasmerio/wasmer-postgres https://github.com/wasmerio/wasmer-postgres
- kiwicopple 4y ago
  (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 https://news.ycombinator.com/item?id=33067962
  - gavinray 4y ago
    My mistake, I fully eat crow, and this is what I get for not reading the thing I argued against!
zX41ZdbW 4y ago
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 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...

apavlo 4y ago

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.

dang 4y ago
I didn't know that and it would make for an interesting historical article in its own right.
whitepoplar 4y ago
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.

danielvaughn 4y ago

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

mritchie712 4y ago
fwiw, I don't get the downvotes either
viraptor 4y ago
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)
- danielvaughn 4y ago
  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.

gavinray 4y ago

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

kiwicopple 4y ago
(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 https://news.ycombinator.com/item?id=33067962
- gavinray 4y ago
  My mistake, I fully eat crow, and this is what I get for not reading the thing I argued against!

zX41ZdbW 4y ago

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 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...