Our great sponsors
- ONLYOFFICE ONLYOFFICE Docs — document collaboration in your environment
- InfluxDB - Access the most powerful time series database as a service
- SonarLint - Clean code begins in your IDE with SonarLint
- CodiumAI - TestGPT | Generating meaningful tests for busy devs
| inquire | postgrest | |
|---|---|---|
| 0 | 83 | |
| 7 | 20,570 | |
| - | 1.4% | |
| 0.0 | 7.6 | |
| - | 6 days ago | |
| Haskell | Haskell | |
| GNU General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
inquire
We haven't tracked posts mentioning inquire yet.
Tracking mentions began in Dec 2020.
postgrest
-
Prisma + ZenStack: An Alternative to PostgREST
Yes, you can! PostgREST is built exactly for that purpose. It turns a PostgreSQL database into a secure RESTful API, offering APIs like:
-
Business Logic Inside Database - How Evil Is It?
But it doesn’t have to work this way. Some modern databases support a feature called "row-level security". It allows you to define access control policies at the row level based on the current user’s attributes (id, role, group membership, etc.). As long as the application can securely pass the current user’s identity to the database, it can leave all authorization checking to the database. And since the rules are defined at the table level instead of the API level, it has a much smaller surface to protect. The "row-level security" feature is the foundation of products like PostgREST, PostGraphile, and Supabase.
-
Supabase Edge Runtime: Self-Hosted Deno Functions
I think this is great, but a growing question in my mind from these is what is the long tail plan for maintenance of this constellation of stuff? Especially because you guys are building on technologies that you can’t really just casually find developers for eg Elixir and Haskell. I keep seeing missing critical features in Realtime and Postgrest, and I know these are armies of 1-2, but it does kind of worry me when I think about investing time and effort into the Supabase ecosystem 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...
-
Seeking Architectural Advice for a Report Automation Sytem Upgrade
I don't vouch for this product, but it's open source so you can evaluate the implementation and maybe get ideas. it also sounds like it may be exactly what you need and is actively being developed (pushed a release 2 days ago) https://github.com/PostgREST/postgrest
-
Three Ways to Secure Database APIs: Which Is Right for You?
Row-level security is the foundation for products like Supabase, Postgraphile, and PostgREST.
- is it a good idea to develop a database with direct rest API access??
-
Is a custom CMS a bad idea?
wait till you find out https://github.com/PostgREST/postgrest.
-
How to use Supabase RLS with third-party client library?
Yes that's exactly what I'm reading here and there. It seems to be the approach that Supabase is taking itself when receiving queries via their API gateway, powered by PostgREST. I had a look at the source code for the latter and it's basically converting the claims in the received JWT into as many local set_config() calls (basically a wrapper function around SET LOCAL). See this related discussion.
-
Can't link fresh project - problem with underlying postgrest version not supporting 15.
I suspect this is the culprit (might be wrong): https://github.com/PostgREST/postgrest/blob/main/src/PostgREST/Config/PgVersion.hs
What are some alternatives?
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
supabase - The open source Firebase alternative. Follow to stay updated about our public Beta.
postgres-websockets - PostgreSQL + Websockets
Appwrite - Build Fast. Scale Big. All in One Place.
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
gotrue - An SWT based API for managing users and issuing SWT tokens.
simpleconfig
appsmith - Framework to build admin panels, internal tools, and dashboards. Integrates with 15+ databases and any API.
json - Haskell JSON library
swagger2 - Swagger 2.0 data model.
pg-transact - Another postgresql-simple transaction monad