Hacker GitHub

← All repos

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

Mentions per year 99 mentions · busiest year 2017 (17)
20082026
  1. …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
  2. …creates a service for a postgres database. postgrest[0] would probably be it's REST equivalent. https://github.com/PostgREST/postgrest
  3. …). 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…
  4. …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…
  5. 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.
  6. …for REST server. [1]: http://haskell-servant.readthedocs.io/en/stable/introduction... [2]: https://github.com/begriffs/postgrest
  7. 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…
  8. take a look at PostgREST https://github.com/begriffs/postgrest simplified example query https://pastebin.com/7J2ZswRC
  9. …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]…
  10. …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
  11. 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
  12. 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?
  13. 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?
  14. https://postgrest.com/en/v0.4/ https://github.com/begriffs/postgrest
  15. …of 10 language extensions, 20 imports, and 1 line of Perl" and I understand the sentiment :-) [1] https://github.com/begriffs/postgrest/blob/0b486ccf446c6480d...
  16. > 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…
  17. https://github.com/begriffs/postgrest - 8k stars
  18. In addition to the others mentioned, PostgREST: https://github.com/begriffs/postgrest
  19. https://github.com/begriffs/postgrest could use a technical writer and would welcome one
  20. …It needs some backend to talk to postgres. I would use rust or maybe postgrest[0] would do. [0] https://github.com/begriffs/postgrest
  21. …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/
  22. …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…
  23. …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.
  24. There's also PostgREST https://github.com/begriffs/postgrest
  25. Perhaps something like a modified PostgREST could work? https://github.com/begriffs/postgrest
  26. …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…
  27. https://github.com/begriffs/postgrest
  28. 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 ?
  29. 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
  30. OP was talking about this: https://github.com/begriffs/postgrest
    comment by loopdoend · 2015-12-19 · in PostgreSQL 9.5 RC1 Released
  31. Dude, have you seen Postgrest? https://github.com/begriffs/postgrest
  32. …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
  33. 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
  34. You should check out PostgREST, a tool to expose Postres tables through a JSON APIs: https://github.com/begriffs/postgrest
  35. …"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
  36. 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
  37. …turn a Postgres db into an API with PostgREST, and it supports jsonb to retrieve json properties. https://github.com/begriffs/postgrest
  38. 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