graphile-engine
starter
Our great sponsors
graphile-engine | starter | |
---|---|---|
6 | 9 | |
752 | 1,707 | |
0.0% | 1.5% | |
5.8 | 5.4 | |
3 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:
starter
-
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.
-
Show HN: Appwrite – Open-Source and Self Hosted Firebase Alternative
I learned so much about postgresql and RLS from postgraphile starter project: https://github.com/graphile/starter/blob/main/%40app/db/migr...
also the project is worth checking out ;)
- Have my first GraphQL project at work. Any recommended learning resource for production-ready GraphQL APIs?
-
Best resource to learn PL/pgSQL?
I'm a fairly seasoned developer, but I've started contributing to a project (graphile-starter) where the core business logic is defined in PL/pgSQL functions and realized I have a lot to learn.
-
PostgREST v9.0.0
Someone called it: "hasura for adults”
It's highly customisable, works directly with postgresql row levels security and the performance is quite good. It has a custom GraphiQL gui to work on queries/mutations.
To really see how it all works together checkout the starter project: https://github.com/graphile/starter it has migrations, job queue, graphql-codegen etc.
Benjie (https://github.com/benjie) is one of the greatest maintainers I've ever seen!
- Are there any "Opinionated" backend web app frameworks for node?
-
SAME BACKEND FOR WEB APP AND MOBILE APP ?
Here’s a full stack, batteries included example: https://github.com/graphile/starter it doesn’t have mobile app yet but could be added relatively easily.
-
Bedrock - modern full-stack Next.js & GraphQL boilerplate
Postgraphile starter uses most of the same tech and has all the same functionality as far as I can tell, with the additional benefit of Postgraphile generating your GraphQL schema and resolvers instead of worrying them manually.
-
Overwhelmed with auth options, looking for constructive feedback
Check out the Postgraphile Starter and how it handles auth and sessions in a graphql api
What are some alternatives?
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
crystal - 🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!
annuaire-entreprises-sirene-api
codebase - a software and writing repository
postgrest-starter-kit - Starter Kit and tooling for authoring REST API backends with PostgREST
sandman2 - Automatically generate a RESTful API service for your legacy database. No code required!
sqlc - Generate type-safe code from SQL
next-auth - Authentication for the Web.
datasette - An open source multi-tool for exploring and publishing data
apollo-cache-policies - An extension of the Apollo 3 cache with support for advanced cache policies.
daisyui - 🌼 🌼 🌼 🌼 🌼 The most popular, free and open-source Tailwind CSS component library
typescript-eslint-language-service - TypeScript language service plugin for ESLint