Looks like someone took this tweet literally https://twitter.com/davecheney/status/1296033304756404225
Show HN: Octo – Generate a serverless API from an SQL query
61–62 of 62 posts
Re: Show HN: Octo – Generate a serverless API from an SQL query
#62Earlier quoted context omitted.
I feel like projects like this work for simple stuff but as soon as you need analytics/insights or actual business logic, you almost always need to just "roll your own" API. Am I wrong? Do other people feel this way? Can anybody think of a few projects they've worked on that would be too complex/a ton of work to make work with these kind of simple template generators?
With postgrest you can add stored procedures as rest rpc calls, and you can always roll a microservice for more advanced stuff. In practice these sorts of auto-api tools make a good starting point as long as they support your authentication and authorization needs.
What I like about postgREST is you’re leveraging a mature system for authorization (postgresql roles) rather than rolling your own outside the database and introducing a ton of code and vulnerabilities.
Not every application needs roles though, but it definitely feels like the saner approach if you do.
Also a nice side effect, depending on the team, is a significant performance boost as your forced to go deep in database land instead of leaky ORM abstractions.