[feature] Utilize PostgREST for REST API

[pxp928]

Is your feature request related to a problem? Please describe.

PostgREST should give us the ability to create a REST API on top of the postgres. Need to investigate if this works for us and if its worth using.

[BWhitfield]

main...BWhitfield:guac:postgrest

Examples

PSQL

SELECT * FROM package_names
WHERE type = 'alpine'
LIMIT 5
OFFSET 5

id	type	namespace	name
a3eddff2-4c32-53c6-9adc-0702a804b2a7	alpine		ca-certificates-bundle
819cdb9d-3fc2-504d-a351-1bcad092d69a	alpine		zlib
a9e88158-8445-5c3f-998c-868dd5da010b	alpine		libc-utils
befec236-f7b9-51bf-adab-0a8ecf54c473	alpine		apk-tools
370e957a-6396-5082-9e06-279bc7cf5675	alpine		libssl1.1

PostgREST api call

http://localhost:3000/package_names?type=eq.alpine&offset=5&limit=5

[
  {
    "id": "a3eddff2-4c32-53c6-9adc-0702a804b2a7",
    "type": "alpine",
    "namespace": "",
    "name": "ca-certificates-bundle"
  },
  {
    "id": "819cdb9d-3fc2-504d-a351-1bcad092d69a",
    "type": "alpine",
    "namespace": "",
    "name": "zlib"
  },
  {
    "id": "a9e88158-8445-5c3f-998c-868dd5da010b",
    "type": "alpine",
    "namespace": "",
    "name": "libc-utils"
  },
  {
    "id": "befec236-f7b9-51bf-adab-0a8ecf54c473",
    "type": "alpine",
    "namespace": "",
    "name": "apk-tools"
  },
  {
    "id": "370e957a-6396-5082-9e06-279bc7cf5675",
    "type": "alpine",
    "namespace": "",
    "name": "libssl1.1"
  }
]