使用PostgREST自动生成RESTful API

使用Docker拉起PostgREST，自动根据PostgreSQL模式生成后端REST API

This is an example of creating pigsty cmdb API with PostgREST

1. cd ~/pigsty/app/postgrest ; docker-compose up -d

<http://10.10.10.10:8884> is the default endpoint for PostgREST

<http://10.10.10.10:8883> is the default api docs for PostgREST

1. make up         # pull up postgrest with docker-compose
2. make run        # launch postgrest with docker
3. make ui         # run swagger ui container
4. make view       # print postgrest access point
5. make log        # tail -f postgrest logs
6. make info       # introspect postgrest with jq
7. make stop       # stop postgrest container
8. make clean      # remove postgrest container
9. make rmui       # remove swagger ui container
10. make pull       # pull latest postgrest image
11. make rmi        # remove postgrest image
12. make save       # save postgrest image to /tmp/postgrest.tgz
13. make load       # load postgrest image from /tmp

Swagger UI

Launch a swagger OpenAPI UI and visualize PostgREST API on 8883 with:

1. docker run --init --name postgrest --name swagger -p 8883:8080 -e API_URL=http://10.10.10.10:8884 swaggerapi/swagger-ui
2. # docker run -d -e API_URL=http://10.10.10.10:8884 -p 8883:8080 swaggerapi/swagger-editor # swagger editor

Check <http://10.10.10.10:8883/>

最后修改 2022-06-05: add app docs for wiki.js (820bfc3)