Angular 2 , Nodejs, and postgresql

Question

So I want to display some data on front-end from the database.

My app.js file has included:

app.use('/database', databaseRoutes);

my database.js file is the next.

const { Pool, Client } = require('pg')
const connectionString = "postgres://dbuser:Storerage@localhost/mainstorage"

const client = new Client({
  connectionString: connectionString,
})
client.connect()

client.query('SELECT * FROM files limit 10', (err, res) => {
  console.log(err, res)
  client.on("row", function (row, result) {
    result.addRow(row);
});

});
module.exports = client;

How can I display this postgresql query result in document.component.html.

Can somebody link me any kind of help, or write an introduction ?

I think I need create a document.service file but I don't know how to handle that. I have read about JSON.stringify, but didn't find any cool tutorial.

Thanks for help.

Milan Velebit · Accepted Answer · 2017-10-03 08:24:35Z

1

I think you have trouble understanding the concept of an API. First of all you should retrieve the query results via res.send(results) (or res.end, whichever suits you). That will retrieve the data in a JSON format which you can easily parse using either modules like lodash or just simply by accessing them like any object (using either object.attr or object['attr']). You should create endpoints to which you'll send requests from your Angular front-end and those endpoints will retrieve results in JSON or whichever format. I can't go through all the steps here, but you should check out some tutorials on REST APIs for starters.

answered Oct 3, 2017 at 8:24

Milan Velebit

2,0272 gold badges20 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Milan Velebit · Accepted Answer · 2017-10-03 09:22:18Z

0

You need a Node.js server, like Express, or just the internal server of NodeJS is OK. I suggest Express. Then you put your code in a route's callback function, after you've fetched data form the database, use res.send() or res.json() to send result to the client. Why don't you just have a look of Express at expressjs.com, it's very simple. Or I should suggest you using some frameworks on a higher level to organize your code. I wrote a framework, Cool-Node, it base on Express and Socket.io and some other strong modules, Also, I published an ORM module, Modelar, its easier to handle data with an ORM tool. Cool-Node uses Modelar as well, it currently supports MySQL, PostgreSQL and SQLite, with a powerful Query Constructor, it provides an API that gives you the ability to handle data in an object-oriented way.

edited Oct 3, 2017 at 9:22

Milan Velebit

2,0272 gold badges20 silver badges38 bronze badges

answered Oct 3, 2017 at 8:32

A-yon Lee

2,2222 gold badges12 silver badges18 bronze badges

3 Comments

Milan Velebit Over a year ago

Just a tip, set up port forwarding for your framework's website

A-yon Lee Over a year ago

Sorry, it's a mistake, 3000, the port 80 is used by Apache, I was in PHP groups before joining nodejs.

Milan Velebit Over a year ago

Yeah that was my first thought :D

Collectives™ on Stack Overflow

Angular 2 , Nodejs, and postgresql

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related