GraphQL is now available on Supabase • Hacker News Board

Re: GraphQL is now available on Supabase

#31

Post by tomatowurst » Wed, Mar 30, 2022, 1:17 AM UTC

DenseComet wrote: post #28

tomatowurst wrote: post #19

been curious as to what sort of savings you've been able to get with supabase because we are approaching a few thousand dollars to store a couple terabytes on DynamoDB Thinking of buying a dedicated server from Hetzner to run Supabase on it instead but worried about latency. awful that we have to move away from AWS for this but with four/five dedicated servers in EU, US-West, US-East, Singapore and Tokyo, we could ha…

Take a look at ScyllaDB Alternator [1], which is API compatible with DynamoDB. Scylla also supports multiregion clusters, which should help with latency. I've not used alternator, but I've had a good experience with Scylla, and it might be worth looking into as a lower effort way to move off DynamoDB. [1] https://www.scylladb.com/alternator/

wow! didn't know this existed, so does this mean I can self-host and still keep my dynamodb api code?

Re: GraphQL is now available on Supabase

#32

Post by tomatowurst » Wed, Mar 30, 2022, 1:21 AM UTC

kiwicopple wrote: post #21

tomatowurst wrote: post #19

been curious as to what sort of savings you've been able to get with supabase because we are approaching a few thousand dollars to store a couple terabytes on DynamoDB Thinking of buying a dedicated server from Hetzner to run Supabase on it instead but worried about latency. awful that we have to move away from AWS for this but with four/five dedicated servers in EU, US-West, US-East, Singapore and Tokyo, we could ha…

One thing to mention is that DynamoDb and Postgres are vastly different databases, so the migration won't be a simple "dump and restore". You're right - it will be a daunting task, but one that only becomes more daunting the longer you wait. If you make the migration to Hertzner + self-hosting (even just to pure Postgres), I'm certain you will see huge savings. It's hard to give exact numbers without knowing your wor…

Appreciate it, really think AWS dynamodb is not an option for those running a bootstrapped business and dealing with large amount of data anymore, guess I'm going to have to bite the bullet and just do more research on hardening dedicated servers ourselves. Really the security and peace of mind from relying on AWS was what we were paying for but the cost is too much as our data storage needs are exploding.

At this point I might even move off AWS Lambda somehow, its quite ironic, we do consulting to help businesses get on AWS but we are moving off it due to rising costs!

Re: GraphQL is now available on Supabase

#33

Post by realPubkey » Wed, Mar 30, 2022, 4:47 AM UTC

sk55 wrote: post #27

Does this support Graphql subscriptions as well?

From the example generated schema in the docs, it does not look like they have subscriptions.

Re: GraphQL is now available on Supabase

#34

Post by andrewmunsell » Wed, Mar 30, 2022, 4:56 AM UTC

oliverrice wrote: post #5

heyo, thanks for the ping I'm the dev lead on pg_graphql. Happy to answer any questions!

Any plans to expose RPC functions inside of GraphQL?

Re: GraphQL is now available on Supabase

#35

Post by KwisaksHaderach » Wed, Mar 30, 2022, 5:09 AM UTC

1st1 wrote: post #24

Dowwie wrote: post #22

Earlier quoted context omitted.

How would you contrast this library with what EdgeDB is doing on top of Postgres?

EdgeDB [1] has indeed a rich GraphQL layer, but it's a very different project. While it also builds on top of Postgres, EdgeDB replaces the entire relational database front-end. EdgeDB features a SQL replacement language called EdgeQL (analytical capabilities of SQL married with deep-fetching in GraphQL), a higher-level data model (tables -> object types), integrated migrations engine, a custom protocol with great pe…

Are there any plans to provide a Java client for EdgeDB?

Re: GraphQL is now available on Supabase

#36

Post by privatemonkey » Wed, Mar 30, 2022, 5:37 AM UTC

syrusakbary wrote: post #18

Nice! I was already pretty excited about you guys, and this only fuels up more excitement since I always been a GraphQL lover. I'm impressed by the pace that you are releasing new products... keep it up team!

I have to second that. Supabase rocks!

Re: GraphQL is now available on Supabase

#37

Post by aslakhellesoy » Wed, Mar 30, 2022, 7:00 AM UTC

oliverrice wrote: post #5

heyo, thanks for the ping I'm the dev lead on pg_graphql. Happy to answer any questions!

Excellent work!

Postgraphile uses a naming convention for postgres functions to extend the GraphQL schema [1].

Do you have any plans to support a similar mechanism in pg_graphql?

[1]: https://www.graphile.org/postgraphile/functions/

Re: GraphQL is now available on Supabase

#38

Post by methyl » Wed, Mar 30, 2022, 8:16 AM UTC

davidkuennen wrote: post #10

kiwicopple wrote: post #2

hey HN, supabase ceo here. I'm really excited about this release. Our GraphQL implementation is built on top of pg_graphql[0], a PostgreSQL extension we open-sourced a few months ago. The implementation works with a lot of native PG functionality (like Row Level Security). You can also do a some neat things with PG GRANTS, enabling/disabling access to different tables/columns to effectively serve a different GraphQL…

Hey, thanks for creating this! It's nice to see more products in that space. Off-Topic: How did you create your blog? It's seems like you developed it yourself? I'm currently contemplating on how to create the blog for my product, since I want to have it integrated into the main website as well (as subdirectory). It's not really possible when using third party providers. You always have to use subdomains there.

Hey, I’m about to launch a product that will make it much easier to host third party website as a subdomain, ping me at lucjansuski (at) gmail if you are interested

Re: GraphQL is now available on Supabase

#39

Post by andreypopp » Wed, Mar 30, 2022, 9:02 AM UTC

oliverrice wrote: post #5

heyo, thanks for the ping I'm the dev lead on pg_graphql. Happy to answer any questions!

It's impressive that the entire thing is in pl/pgsql (apart from parsing).

Have you considered any other implementation strategies (C native extension, any other pl/* or maybe running an out of PostgreSQL process which does GraphQL to SQL compilation)?

Re: GraphQL is now available on Supabase

#40

Post by elitan » Wed, Mar 30, 2022, 10:23 AM UTC

Congratulations on the GraphQL launch. I think it is a step in the right direction :)

I see a lot of mentions of Hasura in the comments.

If you'd like what Supabase is building but prefer using Hasura you might want to check out what we're building at Nhost (http://nhost.io/). We use Hasura's GraphQL Engine for the API layer while also providing Postgres, Auth, Storage and Serverless Functions.

(CEO of Nhost)