Universal CRUD backend for the frontend?

Question

CRUD

A project of a familiar person needs a primitive backend, CRUD for a dozen resources, authorization and simple authentication. The main difficulties of the project will be on the frontend.
There are no backends in the team, but there is a good frontend worker.
What tools can act as a backend for such a project?
Who can give feedback on PostgREST, Firebase, Horizon REST API, Hasura GraphQL, Graphcool and similar? What's in the mainstream?

Answer 1

loopback does great CRUD on any common database. Models are described simply, concisely and flexibly. Out of the box, a bunch of methods for searching and filtering, plus Swagger.

Answer 2

I once made a universal api https://github.com/grinat/faap which covers crud. You don't need to generate anything, it's all by itself, express + monga is used. In general, the essence of this thing, if we need a blog with entries and comments, then we send requests:
post / post create a post
get / post get posts, filtering, pagination, etc. comes with
post / comment create a comment
get /comment get their list. Instead of post / comment, you can substitute any name. That is, at the front, we come up with a name for the collection and send the data, they are written to the database and the whole crud is available, there is authorization (bearer token) / uploading files / filters by fields / selections from-to / sorting / even full-text search. As a side effect of all this dynamics, there is no validation, but it can be manually written. I myself use it as a mock server, I deployed product demos on it, I use it for pet projects, but I don’t recommend it for sale, since there is no built-in validation, you can write it with pens, but then in my opinion the whole essence of this application is lost. The turnip has examples, docks in swagger / open-api, and so on.

Answer 3

I recently stumbled upon the Python Eve
library It takes very little to run:
As a result, it turns out to be as similar as possible to a RESTful server. Examples of work and in general an article about the use here
Authorization is also declared on the official website, just connect and configure

Answer 4

Of the rapidly deployable graphql CRUD shells (Prisma / Graphcool, Postgraphile, Hasura and self-written ), I personally liked Hasura, now I'm putting it into production.

Answer 5

https://api-platform.com/ - CRUD, REST/GraphQL, Authorization, Customizable AF, Built on top of Symfony

Answer 6

I have used https://www.dreamfactory.com/ on several small projects. Knows how to do CRUD on popular DBMS, you can make resources for external APIs, write scripts (including JS). There is a service, but you can put it on your server.