postgrest-js

You have explicit control over transactions with functions https://postgrest.org/en/latest/references/api/functions.htm.... I think this sentiment stems from users of postgrest-js[1], which is a JS library that gives an ORM feel to PostgREST requests. Under that abstraction, users don't realize they're using a REST API, instead of a direct postgres connection. So in this case users are really asking for "client-side transactions"[2], which are not supported in PostgREST. [1]: https://github.com/supabase/postgrest-js [2]: https://github.com/PostgREST/postgrest/issues/286

At one point, I really thought it was used in Supabase. But I guess they only wrote the js wrapper for it. https://github.com/supabase/postgrest-js Came here to mention Hasura as well (not sure of it's popularity though) https://hasura.io/graphql/database/postgresql

I think it’s great too. I wish they would shore up some of their existing releases though. Probably most notably, the ability to query aggregates via the officially supported route is missing: https://github.com/supabase/postgrest-js/issues/206 The workarounds suggested are not ergonomic for most use cases and it feels pretty out of place for such basic functionality to be missing in what otherwise feels like a pretty full featured product. Their Realtime product is another example of something that languishes while new features get launched.

yes you're right. The JS library is a thin wrapper around PostgREST's API (https://github.com/supabase/postgrest-js) Supabase now offers a few more features which integrate with the Postgres database - File Storage (s3), Authentication, Deno Functions, and Realtime (database change listeners). Each of these services is a standalone server and each has a corresponding JS library. "supabase-js" wraps up the modular JS libraries into a single library for convenience

Hey everyone. It was a big month for the team at Supabase, but I want to highlight the community contributions: * Get response data as CSV thanks to this PR[0] from @andreivreja * Go Libraries are now underway thanks to @yusufpapurcu and @muratmirgun [1] * Swift Libraries are now underway thanks to @satishbabariya [2] We still have a long way to go for mobile support, but the Apple logins is a big one. If you ship an app to the App Store with any third-party logins, you're required to enable Apple logins as well. While this sounds like a bit of over-reach, it's actually quite cool - if you use Apple login they obfuscate your email so that the 3rd party app don't get access to your personal data. Quite nice! [0] CSV: https://github.com/supabase/postgrest-js/pull/187 [1] Go: https://github.com/supabase/postgrest-go [2] Swift: https:/

Glad to be part of the Supabase team! Clickable links to the Supabase client libraries, for those interested: - JS: https://github.com/supabase/postgrest-js/ - Dart: https://github.com/supabase/postgrest-dart - Rust: https://github.com/supabase/postgrest-rs - Python: https://github.com/supabase/postgrest-py Also, you can see how they're used together on https://pro.tzkt.io.

We're trying to support postgREST - at the moment that means client libraries: https://github.com/supabase/postgrest-js https://github.com/supabase/postgrest-rs https://github.com/supabase/postgrest-py (coming soon) But for additional features, it's a lot of UX - auto-docs, API gateways, auto-UI (like Airtable). For distinct features, check out our realtime server: https://github.com/supabase/realtime

See my comments on Auth here: https://news.ycombinator.com/item?id=23320443 > We want to nail the auth and we're looking at leveraging Postgres' native Row Level Security. This is a tricky task to "generalize" for all businesses but we have some good ideas (we're discussing in our repo if you want to follow - https://github.com/supabase/supabase) > RESTful APIs I can of course get with PostgREST That's what we use! See our supporting libraries: https://github.com/supabase/postgrest-js https://github.com/supabase/postgrest-rs https://github.com/supabase/postgrest-py (coming soon) Also, I'm a long time user and a huge fan. My previous company is featured on their docs (blog post: https://paul.copplest.one/blog/nimbus-tech-2019-04.html#api-...)

There's also one for JavaScript: https://github.com/supabase/postgrest-js