challenge.md

Challenge

You have a json file with following structure (example)

[
  { 
    "id": 1,
    "title": "Hello",
    "description": "World"
  },
  { 
    "id": 2,
    "title": "Hello 2",
    "description": "World 2"
  },
  { 
    "id": 3,
    "title": "Hello 3",
    "description": "World 3"
  }
]

Create app using postgres, hasura, and nextjs | sveltekit

Postgres must contain only 1 table long_tails with fields tail as string and json_id as number, with data like

tail, json_id
best-hello-ever, 1
best-hello-world-ever, 2
best-world-ever, 3

json_id is 1-1 relation to json at top

I want accessing app at localhost:3000/{tail} i.e. (localhost:3000/best-hello-ever etc) to see the title and description on the screen.

• I want to see changes on my screen if I edit json and reload the page.
• Web app above must use only 1 fetch to hasura and only to hasura (no other fetches are allowed).
• App above must be reproducible on linux and mac machines, don't use clouds and must be easy to setup (1 command).
• App must have good dev experience (i.e. all that modern hot reloads etc)
• You must think about json above that it can be placed anywhere not only on local file system.

Output we need

github repository with app above, and instructions how we can setup/work with app on local env.

Bonus point

If you would depoy it anywhere and provide a link to app (deploy must be documented/configured too)