haste-app VS postgrest

Compare haste-app vs postgrest and see what are their differences.

haste-app

Development version of Haste.App (by valderman)
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
haste-app postgrest
0 84
9 20,605
- 0.9%
0.0 7.6
over 5 years ago 5 days ago
Haskell Haskell
MIT License MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

haste-app

Posts with mentions or reviews of haste-app. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning haste-app yet.
Tracking mentions began in Dec 2020.

postgrest

Posts with mentions or reviews of postgrest. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-06-02.
  • 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 2023
    12 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.

    Example: https://github.com/PostgREST/postgrest/issues/915#issue-comm...

  • 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?

When comparing haste-app and postgrest you can also consider the following projects:

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