PostgREST/postgrest
View on GitHub ↗ ★ 27,740 Haskell
REST API for any Postgres database
99 mentions on Hacker News by 72 people: 11 stories, 88 comments · first 2014-12-31 · latest 2026-05-08
20082026
-
…neither I'm sure that's a good idea), but there's projects for providing HTTP APIs to Postgres: https://github.com/PostgREST/postgrest https://github.com/prest/prest
comment by detaro · 2018-09-08 · in Ask HN: HTTP extension for Postgres -
…creates a service for a postgres database. postgrest[0] would probably be it's REST equivalent. https://github.com/PostgREST/postgrest
comment by y4mi · 2018-07-16 · in Show HN: Hasura – Fast, instant GraphQL APIs on Postgres -
…). One of his projects he works on is a SASS product which is largely done in postgresql leveraging https://github.com/PostgREST/postgrest . Seems pretty good, going to be interesting to see how it turns out ( though I haven't seen him…
comment by keithnz · 2018-07-13 · in How NoSQL forced the evolution of a scalable relational database -
…have to touch Haskell, but benefit from its type safety and performance), check out PostgREST: https://github.com/begriffs/postgrest If you need GraphQL and standard PostgREST endpoints (as well as a few other tools like Openresty), this…
comment by cpursley · 2018-01-16 · in Prisma – An open-source GraphQL API layer for your database -
I'd love to see a port of https://github.com/begriffs/postgrest to Elixir. Cockroachdb + Elixir-based Postgrest implementation would be the ultimate platform for realtime distributed web scale.
comment by cpursley · 2017-12-06 · in “Follow-The-Workload” Beats the Latency-Survivability Tradeoff in CockroachDB -
…for REST server. [1]: http://haskell-servant.readthedocs.io/en/stable/introduction... [2]: https://github.com/begriffs/postgrest
comment by zypeh · 2017-07-27 · in Ask HN: What language/framework do you plan to use in your next project? -
Just wanted to give a huge shout-out to PostgREST: https://postgrest.com https://github.com/begriffs/postgrest You can get many of the benefits of GraphQL using postgrest's resource embedding: https://postgrest.com/en/v4.1/api.html#resource…
comment by Cieplak · 2017-07-11 · in How to GraphQL – A Fullstack Tutorial for GraphQL -
take a look at PostgREST https://github.com/begriffs/postgrest simplified example query https://pastebin.com/7J2ZswRC
comment by ruslan_talpa · 2017-07-01 · in React, Relay and GraphQL: Under the Hood of the Times Website Redesign -
…bottledwater-pg [4] which has a nice blog post [5] explaining the benefits of the architecture [1] https://github.com/begriffs/postgrest [2] https://subzero.cloud [3] https://github.com/subzerocloud/postgrest-starter-kit [4]…
comment by steve-chavez · 2017-06-30 · in Show HN: pg-amqp-bridge – Send Messages from PostgreSQL to RabbitMQ (rust) -
…to get a taste and if GraphQL is your thing, you could explore the same idea using subZero [3] [1] https://github.com/begriffs/postgrest [2] https://github.com/subzerocloud/subzero-starter-kit [3] https://subzero.cloud Edit: typos
comment by ruslan_talpa · 2017-06-18 · in Rules for REST API URI Design -
It sounds like you would like to look at something like postgrest. See https://github.com/begriffs/postgrest
comment by zitterbewegung · 2017-04-06 · in Databases have failed the web -
Words can hurt you know ... :) https://github.com/begriffs/postgrest/graphs/contributors?fr... It uses postgrest but not postgraphql, actually not even the graphql-js reference implementation
comment by ruslan_talpa · 2017-03-31 · in Is GraphQL the Next Frontier for Web APIs? -
I'm a big fan of postgrest ( https://github.com/begriffs/postgrest/ ). It creates a RESTful HTTP API out of your existing postgres schema. It practically eliminates the need to write a CRUD backend.
comment by daurnimator · 2017-03-31 · in Is GraphQL the Next Frontier for Web APIs? -
https://postgrest.com/en/v0.4/ https://github.com/begriffs/postgrest
comment by ruslan_talpa · 2017-03-30 · in Ask HN: What was that automatic api creator for postgres written in Haskell? -
…of 10 language extensions, 20 imports, and 1 line of Perl" and I understand the sentiment :-) [1] https://github.com/begriffs/postgrest/blob/0b486ccf446c6480d...
comment by a-saleh · 2017-03-26 · in PostgREST – A fully RESTful API from any existing PostgreSQL database -
> Postgrest is a great example of a real-world Haskell codebase. It's hard to read. Very messy . https://github.com/begriffs/postgrest/tree/master/src/PostgR... Despite 15 years of programming experience in python, js, C, etc. I feel like…
comment by gothrowaway · 2017-03-26 · in PostgREST – A fully RESTful API from any existing PostgreSQL database -
https://github.com/begriffs/postgrest - 8k stars
comment by seddona · 2017-03-20 · in Three Months of Go, from a Haskeller’s perspective (2016) -
In addition to the others mentioned, PostgREST: https://github.com/begriffs/postgrest
comment by seagreen · 2017-03-19 · in Three Months of Go, from a Haskeller’s perspective (2016) -
https://github.com/begriffs/postgrest could use a technical writer and would welcome one
comment by ruslan_talpa · 2017-01-21 · in Ask HN: Any open-source project in need of a Technical Writer? -
…It needs some backend to talk to postgres. I would use rust or maybe postgrest[0] would do. [0] https://github.com/begriffs/postgrest
comment by ivanceras · 2016-11-15 · in Ask HN: If you were to build a CRM today what would your stack be? -
…in general) tools/libraries : Bookshelf ORM http://bookshelfjs.org/ PostgREST automated REST API https://github.com/begriffs/postgrest Sqitch git style migration management http://sqitch.org/
comment by _w3e8 · 2016-05-10 · in PostgreSQL Scalability: Towards Millions TPS -
…Postgrest. Postgrest is an open-source project that creates a REST api based on a Postgres schema: https://github.com/begriffs/postgrest It ain't GraphQL, and I don't understand GraphQL enough to note functional differences. Postgrest made…
comment by bageldaughter · 2016-04-27 · in Postgraphql: A GraphQL schema created by reflection over a PostgreSQL schema -
…convince me that you aren't going anywhere and will be able to build a substantial community. [1]: https://github.com/begriffs/postgrest [2]: That isn't a reason not to do it.
comment by tyre · 2016-04-07 · in Apply HN: Brodlist – a new type of database -
There's also PostgREST https://github.com/begriffs/postgrest
comment by droque · 2016-03-02 · in Show HN: Restdb.io – a plug and play database service -
Perhaps something like a modified PostgREST could work? https://github.com/begriffs/postgrest
comment by 15155 · 2016-01-17 · in Parsing 10TB of Metadata, 26M Domain Names and 1.4M SSL Certs for $10 on AWS -
…to check if it's possible. I haven't though it can be as fast. 2-4* times faster than a Postgrest https://github.com/begriffs/postgrest 20* times faster than Rails (*for GET index) Now it's refactored as shard so it should be much easier…
comment by bobik314 · 2016-01-14 · in Crystal_api – fast and easy REST api for Postgresql written in Crystal -
https://github.com/begriffs/postgrest
comment by bryanlarsen · 2016-01-07 · in PostgreSQL 9.5: UPSERT, Row Level Security, and Big Data -
With a REST layer like https://github.com/begriffs/postgrest you don't need any extra application server layer to serve your data, securely (RLS). Bye bye Java EE ?
comment by lugus35 · 2016-01-07 · in PostgreSQL 9.5: UPSERT, Row Level Security, and Big Data -
It looks like PostgREST has already started updating its documentation for RLS: https://github.com/begriffs/postgrest
comment by DerfK · 2016-01-04 · in PostgreSQL 9.5 Released -
OP was talking about this: https://github.com/begriffs/postgrest
comment by loopdoend · 2015-12-19 · in PostgreSQL 9.5 RC1 Released -
Dude, have you seen Postgrest? https://github.com/begriffs/postgrest
comment by sscarduzio · 2015-08-29 · in Aquameta Layer 0: Meta – Writable System Catalog for PostgreSQL -
…once support for stored functions [0] is completed it'll be tremendously more useful. 0: https://github.com/begriffs/postgrest/issues/114
comment by snuxoll · 2015-07-21 · in Woah that is some wild postgresql -
You might be interested in this: https://github.com/begriffs/postgrest "PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write…
comment by chrisdevereux · 2015-07-21 · in Woah that is some wild postgresql -
You should check out PostgREST, a tool to expose Postres tables through a JSON APIs: https://github.com/begriffs/postgrest
comment by framp · 2015-07-04 · in Developing Web Applications with Haskell -
…"second opinion" to what this cookbook says. It doesn't say anything about transactions, [1]: https://github.com/begriffs/postgrest [2]: http://begriffs.com/posts/2014-12-30-intro-to-postgrest.html
comment by glogla · 2015-05-25 · in The Restful CookBook -
There is also postgrest, providing a REST API for postgresql databases. https://github.com/begriffs/postgrest
comment by Codas · 2015-04-24 · in Becoming Productive in Haskell -
…turn a Postgres db into an API with PostgREST, and it supports jsonb to retrieve json properties. https://github.com/begriffs/postgrest
comment by begriffs · 2015-04-20 · in A proof of concept MongoDB clone built on Postgres -
I haven't used it yet but postgrest looks awesome for this. https://github.com/begriffs/postgrest
comment by lgas · 2015-02-26 · in Embracing SQL in Postgres