How to work with the database from Vue components?

Question

Vue.js

Actually the question is clear.
There is a single-file VueJS component and a PostgreSQL database.
Deployed the server, wrote the following script:

'use strict';

const { Pool } = require('pg');

const pool = new Pool({
  host: 'localhost',
  port: 5432,
  database: 'application',
  user: 'sysadmin',
  password: 'password123'
});

(async () => {
  const fields = ["tablename", "tableowner"].join(', ');
  const sql = `SELECT * FROM pg_tables`;
  const { rows } = await pool.query(sql);
  console.table(rows);
  pool.end();
})();

How to return the received data to the Vue component from this script?

Answer 1

To interact, you need to write rest-full methods, or use another of the popular technologies, such as GraphQL.
You can try nodejs framework express for this purpose.
You need to implement the route on the server, example:

app.get('/get-data', function (req, res) {
 // запрос к базе
// нормализовать данные в нужный вам вид (json).
  res.send(данные);
});
// по маршруту /get-data вы получите данные из базы

https://expressjs.com/ru/guide/routing.html

Answer 2

expand now also api. For example, on express - the easiest way.