graphile-engine
crystal
Our great sponsors
graphile-engine | crystal | |
---|---|---|
6 | 28 | |
752 | 12,413 | |
0.0% | 0.7% | |
5.8 | 9.9 | |
4 days ago | 3 days ago | |
JavaScript | TypeScript | |
- | 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.
graphile-engine
- Sketch of a Post-ORM
-
Business Logic Inside Database - How Evil Is It?
But it doesn’t have to work this way. Some modern databases support a feature called "row-level security". It allows you to define access control policies at the row level based on the current user’s attributes (id, role, group membership, etc.). As long as the application can securely pass the current user’s identity to the database, it can leave all authorization checking to the database. And since the rules are defined at the table level instead of the API level, it has a much smaller surface to protect. The "row-level security" feature is the foundation of products like PostgREST, PostGraphile, and Supabase.
- PostgREST – Serve a RESTful API from Any Postgres Database
-
You may not need an SQL query builder or ORM
I really love the way pg-sql2 is going about that.
-
Ask HN: Solo Dev Stack of 2022?
I've been enjoying developing on top of PostGraphile. https://www.graphile.org/
Good starter: https://github.com/graphile/starter
I can add a column the the db, and my frontend gets that autimagically (in dev mode, it generates a graphql schema out of the db, and from that it creates composables for my frontend wiht graphql-codegen). On the frontend I use Vue 3, the starter is build with nextjs/react.
-
Best resource to learn PL/pgSQL?
I don't much direct knowledge on the internals, but here's a snippet from the graphile-engine repo README:
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?
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
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
pg_graphql - GraphQL support for PostgreSQL
annuaire-entreprises-sirene-api
postgrest-starter-kit - Starter Kit and tooling for authoring REST API backends with PostgREST
supabase - The open source Firebase alternative.
sqlc - Generate type-safe code from SQL
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
datasette - An open source multi-tool for exploring and publishing data
tensei - 🚀 Content management and distribution with a touch of elegance.