pg_graphql
crystal
pg_graphql | crystal | |
---|---|---|
8 | 28 | |
2,769 | 12,413 | |
1.3% | 0.2% | |
9.4 | 9.9 | |
5 days ago | 8 days ago | |
Rust | TypeScript | |
Apache License 2.0 | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_graphql
-
Is it just me or is the Supabase GraphQL API really bad?
Hi, I'm the author of Supabase GraphQL (pg_graphql)
- Sketch of a Post-ORM
- AWS Amplify Is a Grift
-
Type Constraints in 65 lines of SQL
One of the restrictions of composite types is that they can not contain an instance of themselves. So unfortunately, this is not currently possible.
I had this issue when trying to implement an AST type for pg_graphql[1] back when it was written in SQL [2]. In the end we used a JSON type which was much less constrained. That might be solvable using pg_jsonschema [3] if you really wanted to have a good time though
[1] https://github.com/supabase/pg_graphql
-
Supabase or Hasura?
It’s something that’ll come in future, but nothing available yet: https://github.com/supabase/pg_graphql/issues/17
-
Best Orm that uses Graphql and Postgres
But... If you're looking for Graphql/Postgres, maybe look at https://github.com/supabase/pg_graphql which popped onto my radar yesterday, but I have no experience with it.
-
GraphJin – An Instant GraphQL to SQL Compiler
Check out some of the generated queries this extension [1] pumps out and you might have an answer.
[1] https://github.com/supabase/pg_graphql
-
GraphQL is now available on Supabase
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 API depending who is "logged in".
On Supabase, the extension is served via PostgREST[1] using the public PostgreSQL function exposed by pg_graphql. PostgREST exposes PG functions as RPC routes (in our case we also map /rest/v1/rpc/graphql => /graphql/v1)
I'll ping the main dev (@oli_rice) and make sure he is here to answer any technical questions. This is just one of the exciting features we're launching this week. Stay tuned for one of our most-requested features later this week.
[0] pg_graphql: https://github.com/supabase/pg_graphql
[1] PostgREST: https://postgrest.org/
crystal
-
Ask HN: What Underrated Open Source Project Deserves More Recognition?
I didn't see a v5 tag in order to know, and I have no idea what "utils/graphile" does for the project, but one will want to ensure they are aware of its licensing scheme https://github.com/graphile/crystal/blob/db8894c74eb0ec3fe96...
- v4.13.0
-
PostgREST – Serve a RESTful API from Any Postgres Database
I was about to say “but this one is!” and realized I had confused PostgREST with PostGraphile. If you’re interested in GraphQL, you can check out PostGraphile here: https://github.com/graphile/postgraphile
-
Best Orm that uses Graphql and Postgres
If you point is to abstract all the CRUD/GraphQL application, Go isn’t needed. You can go with PostgREST or Postgraphile.
- v4.12.12
-
Ask HN: Locally generate GraphQL schema and resolvers from DB
What do you mean locally? Hasura is OSS, and you can run it locally (you have autogenerated SQL statements) Here you can just use Nhost and its CLI;
Alternatives are https://github.com/graphile/postgraphile or dgraph as you mentioned. Hasura is working on support for sqlite, so you may have some blockers there, you can also look into the Prisma engine which has GQL as an intermediate (for resolvers, for example)
- v4.12.11
-
Supabase (YC S20) raises $80M Series B
I've personally found Postgraphile to be fantastic. Nicer to use than Hasura and fully OSS: https://github.com/graphile/postgraphile/
- v4.12.10
-
GraphQL is now available on Supabase
Hi all, this sounds very cool. How does pg_graphql compare to Postgraphile? https://github.com/graphile/postgraphile (besides I guess running in the DB with PLpgSQL instead of as a NodeJS server)
Did you think about integrating Postgraphile with the Supabase ecosystem or have specific limitations with it?
Thanks!
What are some alternatives?
postgrest - REST API for any Postgres database
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
supabase - The open source Firebase alternative.
starter - Opinionated SaaS quick-start with pre-built user account and organization system for full-stack application development in React, Node.js, GraphQL and PostgreSQL. Powered by PostGraphile, TypeScript, Apollo Client, Graphile Worker, Graphile Migrate, GraphQL Code Generator, Ant Design and Next.js
edgedb - A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
postgres - Unmodified Postgres with some useful plugins
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
tensei - 🚀 Content management and distribution with a touch of elegance.
thin-backend - 🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps
porn-vault - đź’‹ Manage your ever-growing porn collection. Using Vue & GraphQL