pg_graphql
graphjin
pg_graphql | graphjin | |
---|---|---|
8 | 61 | |
2,769 | 2,839 | |
1.3% | - | |
9.4 | 5.5 | |
5 days ago | about 24 hours ago | |
Rust | Go | |
Apache License 2.0 | Apache License 2.0 |
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/
graphjin
- [Golang] Super Graph GraphQL au compilateur SQL renommé GraphJin et prend maintenant en charge MySQL
-
Does Go, has something similar to Laravel eloquent (ORM) ?
This one looks interesting if you like GraphQL… https://graphjin.com
-
Looking for library recommendations: Django -> Golang port
You're right. Django made a ton of tables, and it's pretty insightful to think about all the stuff it's trying to consider and a nightmare to migrate that framework. Django might have simplified some stuff, but it's still too opaque for my taste and the overall end goals of the project. Currently, I'm testing using graphjin (it doesn't have the best documentation, but it does boast an SQL generation capability that I philosophically think is the best way to do things).
-
Advice on ORMs with REST/GraphQL & Hasura/PostGraphile implementation
Checkout GraphJin it's an automatic GraphQL to SQL compiler, you write your database queries in GraphQL instead of SQL and it compiles them into efficient SQL on the fly. Works as a library in GO and NodeJS. https://github.com/dosco/graphjin
-
Ask HN: How do you test SQL?
In GraphJin an automatic GraphQL to SQL compiler we use the gnomock library it startups a database instance (docker) then create the schema and tests data and finally our code connects to it and runs a series of tests. We run these across Mysql, Postgres and a few other DB's. Gnomock supports a wide range of them. Right now we don't take down the db for every test only between test runs but its fast enough that we could. This whole thing runs of a simple `go test -v .` command and we run it on every commit using a githook. https://github.com/dosco/graphjin/blob/master/tests/dbint_te...
- Should I use GraphQL for a public facing API (in place of a REST API)?
- GraphJin 2.0 - A new kind of ORM for GO
-
Multiple subscriptions fom apollo aclient.
This was a bug in GraphJin it has since been fixed. The issue was that you were trying to have multiple subscriptions over a single websocket this did not work (it should) and now it does. https://github.com/dosco/graphjin/commit/43e619b2ff392dd42b99a4d56074a041a54b0e1c
-
Is graphql-request a good tool for only client side api? Share your feedbacks. Thanks 🙏
Not exactly GraphQL is just a format to define what data you want back from someplace. You can use it in a browser app to request data from a backend GraphQL server or you can use it as an ORM within your backend app to fetch data from a database using a library like GraphJin. https://github.com/dosco/graphjin
- Graphjin.js - An easy-to-use, zero dependency Node.js library to build APIs quickly
What are some alternatives?
crystal - 🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
postgrest - REST API for any Postgres database
graphql-go - GraphQL server with a focus on ease of use
supabase - The open source Firebase alternative.
gqlgen - go generate based graphql server library
edgedb - A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
asciinema - Platform for hosting and sharing terminal session recordings
postgres - Unmodified Postgres with some useful plugins
graphql-benchmarks - GraphQL benchmarks using the-benchmarker framework.
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
node-pg-migrate - Node.js database migration management for PostgreSQL