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
|over 5 years ago||5 days ago|
|MIT License||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.
We haven't tracked posts mentioning haste-app yet.
Tracking mentions began in Dec 2020.
Sketch of a Post-ORM
13 projects | news.ycombinator.com | 2 Jun 2023
The OP didn't write about a UI and we don't know what their needs are, so for all we know they're writing a Python-based back-end API in REST or GraphQL which is being consumed by a mobile UI or a SPA UI in Reactor or Vue.js or whatever, such that that back-end API doesn't have to provide a UI. If the existing Python back-end doesn't provide a UI then any proposed substitute--including one in SQL--shouldn't have to provide a UI either, just an API. In that case, there are some ready-made solutions already available:
- PostgREST (https://postgrest.org/): REST API for PostgreSQL
Prisma + ZenStack: An Alternative to PostgREST
2 projects | dev.to | 24 Apr 2023
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?
3 projects | dev.to | 17 Apr 2023
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
12 projects | news.ycombinator.com | 11 Apr 202312 projects | news.ycombinator.com | 11 Apr 2023
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.
Seeking Architectural Advice for a Report Automation Sytem Upgrade
3 projects | reddit.com/r/ExperiencedDevs | 9 Apr 2023
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?
6 projects | dev.to | 3 Apr 2023
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??
2 projects | reddit.com/r/rust | 21 Mar 2023
Is a custom CMS a bad idea?
2 projects | reddit.com/r/webdev | 20 Mar 2023
wait till you find out https://github.com/PostgREST/postgrest.
How to use Supabase RLS with third-party client library?
2 projects | reddit.com/r/Supabase | 17 Feb 2023
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.
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.
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