graphile/crystal on Hacker News

…PostgREST with PostGraphile. If you’re interested in GraphQL, you can check out PostGraphile here: https://github.com/graphile/postgraphile It’s interesting to me that PostgREST and Hasura are written in Haskell, but PostGraphile is not.…

comment by aobdev · 2022-12-29 · in PostgREST – Serve a RESTful API from any Postgres database

…(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…

comment by AccountAccount1 · 2022-10-23 · in Ask HN: Locally generate GraphQL schema and resolvers from DB

I've personally found Postgraphile to be fantastic. Nicer to use than Hasura and fully OSS: https://github.com/graphile/postgraphile/

comment by ISV_Damocles · 2022-05-10 · in Supabase (YC S20) raises $80M Series B

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…

comment by alexkreidler · 2022-03-29 · in GraphQL is now available on Supabase

…that does something similar (introspects your postgres schema and runs a graphql API on top): https://github.com/graphile/postgraphile Prisma is also interesting (but pulls more logic out of the DB). My question with this type of…

comment by rgbrgb · 2021-12-03 · in GraphpostgresQL: A GraphQL Extension for PostgreSQL

https://github.com/graphile/postgraphile

comment by tflinton · 2020-03-19 · in GraphQLize: JVM library to build GraphQL API instantly from PostgreSQL and MySQL

Postgraphile https://github.com/graphile/postgraphile It's like Hasura but written in a language you can understand. Using it with great success on two projects, both > 3 months into development on.

comment by markhalonen · 2020-01-19 · in Ask HN: What's the fastest tool for basic CRUD?

You might find Postgraphile interesting, if you like graphql: https://github.com/graphile/postgraphile

comment by marviel · 2020-01-17 · in Show HN: ESQLate – Build minimum viable admin panels with just SQL

I considered Hasura but went with postgraphile ( https://github.com/graphile/postgraphile ) because it's written in JavaScript with a plugin architecture, meaning I can easily add my own plugins into the system down the road. Creating a…

comment by markhalonen · 2019-10-22 · in Software projects written in Haskell

…these days, (if requirements permit), my choice would be GraphQL via something like PostGraphile. https://github.com/graphile/postgraphile

comment by michaelmior · 2019-09-09 · in Show HN: Quickly generate REST API (for Postgres db)

For someone looking for a GraphQL solution, which benefits does EdgeDB have over https://github.com/graphile/postgraphile ?

comment by kawera · 2019-04-12 · in Show HN: EdgeDB – Next generation database

…of data Well then you haven't really looked :) https://join-monster.readthedocs.io/en/latest/ https://github.com/graphile/postgraphile https://www.prisma.io/ https://subzero.cloud/ These are all examples of tools/libs that implement a…

comment by ruslan_talpa · 2018-11-07 · in Facebook’s GraphQL gets its own open-source foundation

…it’s amazing. I have been using it to write plpgsql functions for postgraphile. Find out more at https://github.com/graphile/postgraphile

comment by cellis · 2018-09-03 · in Ask HN: Have you ever used PL/pgSQL – the PostgreSQL programming language?

…like so: allPosts { edges { node { headline body author: userByAuthorId { name } } } } [1] https://github.com/graphile/postgraphile/tree/postgraphile#a...

comment by zawerf · 2018-04-12 · in EdgeDB: A New Beginning

▲ 1

PostGraphile – A GraphQL schema created by reflection over a PostgreSQL schema

story by elsherbini · 2018-02-23 · 0 comments

…we're approaching a sort of Atwood's law for GraphQL. Here's the GraphQL version of PostgREST: https://github.com/postgraphql/postgraphql

comment by bmpafa · 2018-02-14 · in Introduction and Quick Guide to GraphQL for BackEnd and FrontEnd

Edit: Apparently this is based on https://github.com/postgraphql/postgraphql which makes sense!

comment by petetnt · 2018-01-15 · in PostGraphile Instant GraphQL API for PostgreSQL Database

Have you looked into PostGraphQL? https://github.com/postgraphql/postgraphql

comment by michaelsbradley · 2017-12-01 · in Build Better GraphQL APIs: Thinking in Graphs

…There are also open source GraphQL backends * https://github.com/jscomplete/graphfront (Postgres) * https://github.com/postgraphql/postgraphql (Postgres) * http://join-monster.readthedocs.io/en/latest/ * https://rest-layer.io/ (MongoDB,…

comment by gregwebs · 2017-11-28 · in AWS AppSync – Build data-driven apps with real-time and off-line capabilities

similar, but for postgres : https://github.com/postgraphql/postgraphql

comment by skhro87 · 2017-11-25 · in Show HN: Tuql – Automatically create a GraphQL server from a sqlite database

…for you! https://github.com/stems/join-monster And even a system that generates your whole schema: https://github.com/postgraphql/postgraphql Plus, the Graphcool framework allows you to bring your own DB:…

comment by djmashko2 · 2017-11-09 · in The GraphQL stack: How everything fits together

I haven't put anything into production yet but I've been playing with PostGraphQL ( https://github.com/postgraphql/postgraphql ). It automatically creates a GraphQL endpoint based on your schema using Node. You define your application…

comment by Mongus · 2017-11-06 · in Mastering PostgreSQL in Application Development

similar but for GraphQl: https://github.com/postgraphql/postgraphql

comment by skhro87 · 2017-10-30 · in Show HN: Xmysql – One command to serve REST APIs for any MySql database

…on wrapping an existing API with GraphQL here which goes through basics of settings up too. [0] https://github.com/postgraphql/postgraphql [1] https://github.com/motleyagency/devday-tutorials/blob/master...

comment by petetnt · 2017-10-25 · in GraphQL Fragments Are the Best Match for UI Components

There's PostGraphQL, which serves a PostgreSQL database as a GraphQL schema: https://github.com/postgraphql/postgraphql

comment by yawaramin · 2017-08-04 · in Learn GraphQL with GitHub

You might be interested in postgraphql: https://github.com/postgraphql/postgraphql Otherwise it depends on your GraphQL implementation and what DB adapters or ORMs they support. For example, `graphql-ruby` includes a generator for a…

comment by dobs · 2017-07-11 · in How to GraphQL – A Fullstack Tutorial for GraphQL

Here's a project that might be interesting. https://github.com/postgraphql/postgraphql

comment by dustinmr · 2017-07-01 · in React, Relay and GraphQL: Under the Hood of the Times Website Redesign

There's also https://github.com/postgraphql/postgraphql

comment by Dnguyen · 2017-05-27 · in Agens Graph – PostgreSQL Based Graph Database

…this package makes turning on a GraphQL API as simple as writing a couple lines of middleware: https://github.com/postgraphql/postgraphql

comment by rojobuffalo · 2017-04-19 · in Relay Modern: Simpler, faster, more extensible

https://github.com/postgraphql/postgraphql

comment by brlewis · 2017-04-06 · in Databases have failed the web

I hope you didn't just throw https://github.com/postgraphql/postgraphql and https://postgrest.com/en/v0.4/ behind some closed source code and called it a business.

comment by _ar7 · 2017-03-31 · in Is GraphQL the Next Frontier for Web APIs?

…for a fact that PostgREST can support that. As for the "very similar be done for GraphQL", there is https://github.com/postgraphql/postgraphql which was based on postgrest ideas. Another approach would be to build graphql on top of…

comment by ruslan_talpa · 2017-03-31 · in Is GraphQL the Next Frontier for Web APIs?

…that creates the API for me, like one of these: https://www.reindex.io https://www.graph.cool https://github.com/calebmer/postgraphql

comment by smt88 · 2017-03-15 · in Which stack would you use for a new API service in 2017?

…of views that query other schema(s), but still have the relations automatically determined? https://github.com/calebmer/postgraphql#schema-driven-apis

comment by infogulch · 2016-12-13 · in PostGraphQL: PostgreSQL meets GraphQL

…be building apps for the a while now. Huge thanks to Caleb Meredith for all the work he has done on https://github.com/calebmer/postgraphql

comment by waingake · 2016-12-13 · in PostGraphQL: PostgreSQL meets GraphQL

…seems to indicate that PostGraphQL does suffer from the N+1 query problem at least to some extent ( https://github.com/calebmer/postgraphql/issues/219 ). Which probably doesn't matter as long as you only have a few nested children, but…

comment by fabian2k · 2016-12-13 · in PostGraphQL: PostgreSQL meets GraphQL

…seen that. There is also postgraphql, which I have become a big fan of and is a great foundation: https://github.com/calebmer/postgraphql That said, the real-time aspect is what I'm really dying for, plus a company supporting a BAAS. The…

comment by smac8 · 2016-11-26 · in Let Postgres Do the Work (2013)

…NOTIFY for this to work though. But uh, that's how you'd do it in postgraphql or postgrest anyway. https://github.com/calebmer/postgraphql http://postgrest.com/

comment by tiglionabbit · 2016-10-07 · in RethinkDB, SageMath, Andreessen-Horowitz, Basecamp and Open Source Software

…[2]: https://github.com/wincent [3]: https://www.youtube.com/watch?v=OEfUBN9dAI8 [4]: https://github.com/calebmer/postgraphql

comment by rojobuffalo · 2016-10-03 · in The State of JavaScript – Survey results

…sleeves and do it yourself starting form this https://github.com/graphql/graphql-js Might also try https://github.com/calebmer/postgraphql (PostgREST inspired, open source but no auth and has N+1 problem) I am also working on a…

comment by ruslan_talpa · 2016-08-17 · in Ask HN: What is a good React stack?

▲ 1

My vision for the future of PostGraphQL

story by GutenYe · 2016-08-16 · 0 comments

Also check Postgraphql: https://github.com/calebmer/postgraphql Inspired from Postgrest linked above, it automatically builds a GraphQL API by reflecting on postgres schema.

comment by nileshtrivedi · 2016-05-10 · in PostgreSQL Scalability: Towards Millions TPS

…project and definitely an inspiration for PostGraphQL. I gave the project credit in the README: https://github.com/calebmer/postgraphql#thanks

comment by calebmer · 2016-04-27 · in Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

…(especially going to production and extending GraphQL myself) which are answered in the README. https://github.com/calebmer/postgraphql/blob/master/README.m... But I don't know how to do it yet.

comment by therealmarv · 2016-04-27 · in Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

▲ 217

Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema

story by craigkerstiens · 2016-04-27 · 24 comments