What is the reason for using GET instead of POST in this instance?

Question

I'm walking through the Javascript demos of pg-promise-demo and I have a question about the route /api/users/:name.

Running this locally works, the user is entered into the database, but is there a reason this wouldn't be a POST? Is there some sort of advantage to creating a user in the database using GET?

// index.js
// --------

app.get('/api/users/:name', async (req, res) => {
  try {
    const data = (req) => {
      return db.task('add-user', async (t) => {
        const user = await t.users.findByName(req.params.name);
        return user || t.users.add(req.params.name);
      });
    };
  } catch (err) {
    // do something with error
  }
});

For brevity I'll omit the code for t.users.findByName(name) and t.users.add(name) but they use QueryFile to execute a SQL command.

EDIT: Update link to pg-promise-demo.

Answer 1

The reason is explained right at the top of that file:

IMPORTANT:

Do not re-use the HTTP-service part of the code from here!

It is an over-simplified HTTP service with just GET handlers, because:

1. This demo is to be tested by typing URL-s manually in the browser;
2. The focus here is on a proper database layer only, not an HTTP service.

I think it is pretty clear that you are not supposed to follow the HTTP implementation of the demo, rather its database layer only. The demo's purpose is to teach you how to organize a database layer in a large application, and not how to develop HTTP services.