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
AllStoriesComments NewestTopOldest
  1. …have any plans for a similar function for TopoJSON? One that also has a record parameter? [2]. [1]: https://github.com/PostgREST/postgrest/blob/f1d0e8ea2266077d... [2]: PostGIS has https://postgis.net/docs/AsTopoJSON.html but it doesn't…
    comment by steve-chavez · 2026-05-08 · in GeoJSON
  2. …[1], basically linking Gentoo's AI policy, which we found the most apt in lack of a standard. [1]: https://github.com/PostgREST/postgrest/blob/main/CONTRIBUTIN...
    comment by steve-chavez · 2026-03-10 · in Redox OS has adopted a Certificate of Origin policy and a strict no-LLM policy
  3. …moving off supabase a lot less scary for. auth is very sticky. - Is this offering an alternative to https://github.com/PostgREST/postgrest or a wrapper around it? - I tried to self-host supabase/realtime recently and couldn't even get it…
    comment by coreylane · 2026-02-25 · in Show HN: Replacebase – library to migrate away from Supabase
  4. I don't have the same impression, but https://github.com/PostgREST/postgrest and https://github.com/koalaman/shellcheck are some popular ones that may be useful to hn'ers. And https://github.com/mchav/dataframe?tab=readme-ov-file#datafr...…
    comment by kreyenborgi · 2025-11-01 · in GHC now runs in the browser
  5. …and not easily supported by PostgREST. The GitHub issue here sums up the conversation about this: https://github.com/PostgREST/postgrest/issues/286 Regardless of Hacker News's thoughts on MCP servers, there is a cohort of users that are…
    comment by dimgl · 2025-07-09 · in Supabase MCP can leak your entire SQL database
  6. …cases and customizations that might present themselves during the full lifecycle of a project. [0] https://github.com/PostgREST/postgrest
    comment by Attummm · 2024-10-17 · in Making the Python back end for my new webapp
  7. ▲ 58
    PostgREST – Serve a RESTful API from Any Postgres Database
    story by redbell · 2024-07-25 · 7 comments
  8. …which are not supported in PostgREST. [1]: https://github.com/supabase/postgrest-js [2]: https://github.com/PostgREST/postgrest/issues/286
    comment by steve-chavez · 2024-05-12 · in The API database architecture – Stop writing HTTP-GET endpoints
  9. Yes, sorry about that. We're looking at it on https://github.com/PostgREST/postgrest/issues/3503 .
    comment by steve-chavez · 2024-05-10 · in The API database architecture – Stop writing HTTP-GET endpoints
  10. …years ago. Companies like Supabase are demonstrating this. [0] https://github.com/sted/smoothdb [1] https://github.com/PostgREST/postgrest
    comment by twsted · 2024-03-20 · in Soul: A SQLite REST and Realtime Server
  11. Don't know if you would call this a "program" but PostgREST is written is Haskell too. https://github.com/PostgREST/postgrest
    comment by ggregoire · 2024-02-02 · in Pandoc
  12. …author https://github.com/begriffs [2]: Also part of the PostgREST team and major contributor https://github.com/PostgREST/postgrest/graphs/contributors
    comment by steve-chavez · 2023-12-19 · in PostgREST: Providing HTML Content Using Htmx
  13. …can change over time, I have to restart Postgrest on a daily basis. For more info, see this issue: https://github.com/PostgREST/postgrest/issues/1130 Does supabase work around this limitation somehow? How do you get SSO to work for auth…
    comment by darksaints · 2023-04-13 · in Supabase Auth: SSO, Mobile, and Server-Side Support
  14. > I keep seeing missing critical features in Postgrest > Example: https://github.com/PostgREST/postgrest/issues/915 > while there isn’t much action on existing issues. That one is planned but it's not high priority because it can be solved…
    comment by steve-chavez · 2023-04-12 · in Supabase Edge Runtime: Self-Hosted Deno Functions
  15. …as a whole seeing more and more launches while there isn’t much action on existing issues. Example: https://github.com/PostgREST/postgrest/issues/915#issue-comm...
    comment by SOLAR_FIELDS · 2023-04-11 · in Supabase Edge Runtime: Self-Hosted Deno Functions
  16. …here on HackerNews, has anybody looked at the Nix config files for this repo to build it locally? https://github.com/PostgREST/postgrest/blob/main/cabal.proje... https://github.com/PostgREST/postgrest/blob/main/default.nix…
    comment by MuffinFlavored · 2022-12-29 · in PostgREST – Serve a RESTful API from any Postgres database
  17. …so bad". Easier said than done as an outsider into a massive Haskell codebase. Transactions (2015): https://github.com/PostgREST/postgrest/issues/286 GROUP BY/DISTINCT (2017): https://github.com/PostgREST/postgrest/issues/915
    comment by MuffinFlavored · 2022-12-29 · in PostgREST – Serve a RESTful API from any Postgres database
  18. …[3] https://postgrest.org/en/stable/api.html#computed-virtual-co... [4] https://github.com/PostgREST/postgrest/issues/2530
    comment by defanor · 2022-12-29 · in PostgREST – Serve a RESTful API from any Postgres database
  19. …we needed to focus on those. We're still open on adding HATEOAS, I've just opened an issue for it: https://github.com/PostgREST/postgrest/issues/2579
    comment by steve-chavez · 2022-11-30 · in A Poor Man's API
  20. Similarly for Postgres, but without the spreadsheet part: https://github.com/PostgREST/postgrest
    comment by dewey · 2022-10-07 · in Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs
  21. Some discussion on this in PostgREST repo https://github.com/PostgREST/postgrest/issues/1214
    comment by xtreak29 · 2022-08-20 · in Ask HN: Auto Generated API (REST/GraphQL) for SQL Server?
  22. …including you!): Start: https://github.com/topics/haskell https://github.com/koalaman/shellcheck https://github.com/PostgREST/postgrest https://github.com/hadolint/hadolint https://github.com/jaspervdj/patat…
    comment by ParetoOptimal · 2022-06-08 · in Dhall: A Gateway Drug to Haskell
  23. …Nix! With Nix we were able to reduce PostgREST image size[1] from over 30 MB to about 4 MB. [1]: https://github.com/PostgREST/postgrest/tree/main/nix/tools/d...
    comment by steve-chavez · 2022-01-07 · in Optimizing Docker image size and why it matters
  24. …course this is PostgREST-specific, only when going through it you'd enforce this restriction. [1]: https://github.com/PostgREST/postgrest/issues/2028
    comment by steve-chavez · 2021-12-01 · in Realtime Postgres Row Level Security
  25. …a nix-shell[1] that allows us to run tests in different PostgreSQL versions(from 9.6 to 14). [1]: https://github.com/PostgREST/postgrest/tree/main/nix#working...
    comment by steve-chavez · 2021-10-24 · in Can we trust Microsoft with open source?
  26. …on PostgREST GitHub discussions. If you'd like you could also post the job offer there. [1]: https://github.com/PostgREST/postgrest/discussions/categorie...
    comment by steve-chavez · 2021-05-11 · in Ask HN: Who is hiring? (May 2021)
  27. …exist and have been discussed a few days ago here on HN. There are also REST adapters for Postgres: https://github.com/PostgREST/postgrest
    comment by selfhoster11 · 2020-12-08 · in Kafka Is Not a Database
  28. …:-]. We'll see. [1]: https://roy.gbiv.com/untangled/2008/rest-apis-must-be-hypert... [2]: https://github.com/PostgREST/postgrest/issues/1089#issuecomm...
    comment by steve-chavez · 2020-11-21 · in PostgREST: REST API for any Postgres database
  29. ▲ 504
    PostgREST: REST API for any Postgres database
    story by swyx · 2020-11-20 · 205 comments
  30. …Even at MVP stage, many backends do quite a bit more than CRUD. This is why I wouldn't pick e.g. https://github.com/PostgREST/postgrest even when it's a perfectly fine (and probably well thought-out) project.
    comment by vemv · 2020-11-15 · in Make Your Back End Layer as Thin as Possible
  31. …and didn't need any updates or transactions. Postgrest was easy to create a self-contained API. https://github.com/PostgREST/postgrest
    comment by manigandham · 2020-09-12 · in Show HN: Octo – Generate a serverless API from an SQL query
  32. ▲ 4
    PostgREST: REST API for any Postgres database
    story by JoelMcCracken · 2020-07-10 · 0 comments
  33. …https://www.postgresql.org/docs/12/functions-json.html https://www.postgresql.org/docs/12/hstore.html https://github.com/PostgREST/postgrest https://github.com/diogob/postgres-websockets https://github.com/supabase/realtime
    comment by leetrout · 2020-07-02 · in Go is boring, and that’s fantastic
  34. …project going with it. Looks like less than 10 people have more than 10 commits in its history: https://github.com/PostgREST/postgrest/graphs/contributors
    comment by RNCTX · 2020-06-19 · in Advice to Young Web Developers
  35. PostgREST: https://github.com/PostgREST/postgrest and http://postgrest.org/en/v6.0/ Sample PostgREST apps: http://postgrest.org/en/v6.0/ecosystem.html React-admin: https://marmelab.com/react-admin/ and…
    comment by cryptonector · 2020-05-06 · in Oracle vs. PostgreSQL: First Glance
  36. …https://www.prisma.io/ There are plenty of "REST API in a box" solutions as well: https://github.com/PostgREST/postgrest https://github.com/prest/prest https://resthapi.com/
    comment by awb · 2020-02-27 · in Hasura raises $9.9M to simplify GraphQL
  37. …the front end. PostgREST or Serverless framework for the backend. Avoid middle ware all together! https://github.com/PostgREST/postgrest https://serverless.com/
    comment by DrJones1098 · 2020-01-27 · in Ask HN: Fastest/easiest framework to build a web application in 2020?
  38. Look similar to postgrest, but younger project under (L)GPL license. https://github.com/PostgREST/postgrest http://postgrest.org/en/v6.0/
    comment by user5994461 · 2020-01-20 · in Access directly your SQL databases via HTTP. In full security
  39. Another worthy mention (not FE, but also exploiting power of sql): https://github.com/PostgREST/postgrest "PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster…
    comment by xwowsersx · 2020-01-17 · in Show HN: ESQLate – Build minimum viable admin panels with just SQL
  40. …Haskell code is still not easily readable, for example, the main file for the tests : https://github.com/PostgREST/postgrest/blob/master/test/Main... and https://github.com/PostgREST/postgrest/blob/master/test/Quer... I don't know, maybe…
    comment by antpls · 2019-11-04 · in PostgREST
  41. Interesting to me I’d this is written in Haskell! I highly recommend reading the source code https://github.com/PostgREST/postgrest
    comment by no_wizard · 2019-11-04 · in PostgREST
  42. It's "cheating" a bit, but Postgrest is interesting in this space: https://github.com/PostgREST/postgrest
    comment by tyingq · 2019-10-27 · in PostgreSQL example of self-contained stored procedures
  43. ▲ 11
    Ask HN: Need an API for your weekend project? I'll build one for you
    story by ruslan_talpa · 2019-10-18 · 7 comments
  44. https://github.com/PostgREST/postgrest (Haskell) is an order of magnitude more performant than postgraphile (Node ~ aka wet noodles).
    comment by cpursley · 2019-09-09 · in Show HN: Quickly generate REST API (for Postgres db)
  45. Worth mentioning: https://github.com/PostgREST/postgrest
    comment by gfodor · 2019-09-09 · in Show HN: Quickly generate REST API (for Postgres db)
  46. I guess it’s a good place to mention https://github.com/PostgREST/postgrest as well
    comment by jatsek · 2019-07-10 · in Sqlite to Rest
  47. You think you're kidding. https://github.com/PostgREST/postgrest https://wiki.postgresql.org/wiki/Python https://github.com/plv8/plv8 https://www.graphile.org/
    comment by paulddraper · 2019-05-10 · in We Can Do Better Than SQL
  48. …connections to the database. You can even have an instant GraphQL server via Postgraphile. [1] [1] https://github.com/PostgREST/postgrest [2] https://www.graphile.org/postgraphile/
    comment by paulddraper · 2019-04-27 · in PostgreSQL Features to Try
  49. https://github.com/PostgREST/postgrest and a very simple ui with an input field and an output list?
    comment by dewey · 2018-12-14 · in Ask HN: Kibana like data explorer UI for PostgreSQL?
  50. …of HTTP/2 multiplexing and have multiple requests executed atomically in a single transaction. [1]: https://github.com/PostgREST/postgrest/issues/286
    comment by steve-chavez · 2018-11-19 · in Post-REST