{"id":14678,"date":"2020-09-08T13:00:17","date_gmt":"2020-09-08T11:00:17","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/"},"modified":"2020-09-08T13:00:17","modified_gmt":"2020-09-08T11:00:17","slug":"build-api-backend-server-with-nodejs-and-postgresql","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/","title":{"rendered":"Build API backend server with NodeJS and PostgreSQL"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create our PostgreSQL Tables and history tables. And then we will continue with NodeJS.<\/p>\n

If you don\u2019t have PostgreSQL installed yet, please follow these steps in our Blog<\/a>. As alternative you can also follow the steps in PostgreSQL Page<\/a>. As Database client I will use DBeaver<\/a> to create the tables.<\/p>\n

After you installed PostgreSQL we need to create database from the psql client. For that open terminal.<\/p>\n

psql -U postgres\npostgres=# \n\npostgres=# create database events;\n\npostgres=# \\q\n<\/pre>\n
Now we can connect with our DBeaver client.<\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
\"\"<\/a><\/p>\n
PostgreSQL is creating public schema by default. I recommended to delete it.<\/p>\n
\"\"<\/a><\/p>\n
Now we can create our events table. For that open new SQL-Editor.<\/p>\n
\"\"<\/a><\/p>\n
CREATE SCHEMA data;\n\ncreate sequence data.seq_events start with 1;\ncreate table data.events\n  ( id int primary key default nextval ('data.seq_events')\n  , title varchar(255) not null\n  , description varchar(255) not null\n  , price varchar(255) not null\n  , organizator varchar(255) not null\n  , startdate date not null\n  , starttime time not null\n  , endtime time not null\n  , location_name varchar(255) not null\n  , location_street varchar(255) not null\n  , location_zipcode varchar(255) not null\n  , location_city varchar(255) not null\n  , location_country varchar(255) not null\n  , created_at date default now()\n  , updated_at date default now()\n);\n\ncreate sequence data.history_seq_events start with 1;\ncreate table data.history_events\n  ( id int primary key default nextval ('data.history_seq_events')\n  , event_id int\n  , title varchar(255) not null\n  , description varchar(255) not null\n  , price varchar(255) not null\n  , organizator varchar(255) not null\n  , startdate date not null\n  , starttime time not null\n  , endtime time not null\n  , location_name varchar(255) not null\n  , location_street varchar(255) not null\n  , location_zipcode varchar(255) not null\n  , location_city varchar(255) not null\n  , location_country varchar(255) not null\n  , created_at date\n  , updated_at date\n);\n<\/pre>\n
Also create the trigger to save all changes automatically into the history table<\/p>\n
create function data.tf_update_events_history()\n  returns trigger\n\tlanguage plpgsql\n\tas\n$$\nbegin\n  insert into data.history_events\n    ( event_id\n  \t, title\n  \t, description\n  \t, price\n  \t, organizator\n  \t, startdate\n  \t, starttime\n  \t, endtime\n  \t, location_name\n  \t, location_street\n  \t, location_zipcode\n  \t, location_city\n  \t, location_country\n  \t, created_at\n  \t, updated_at \n    )\n  values\n    ( old.id\n  \t, old.title\n  \t, old.description\n  \t, old.price\n  \t, old.organizator\n  \t, old.startdate\n  \t, old.starttime\n  \t, old.endtime\n  \t, old.location_name\n  \t, old.location_street\n  \t, old.location_zipcode\n  \t, old.location_city\n  \t, old.location_country\n  \t, old.created_at\n  \t, old.updated_at \n    );\n   return new;\nend\n$$;\n-- trigger before update\ncreate trigger t_before_update_log_event_history\nbefore update on data.events\nfor each row\nexecute procedure data.tf_update_events_history();\n<\/pre>\n
And finally, we can test if our history trigger is working<\/p>\n
insert into data.events\n    ( title\n  \t, description\n  \t, price\n  \t, organizator\n  \t, startdate\n  \t, starttime\n  \t, endtime\n  \t, location_name\n  \t, location_street\n  \t, location_zipcode\n  \t, location_city\n  \t, location_country\n    )\n  values\n    ( 'PostgreSQL tutorial'\n    , 'In this event we will show PostgreSQL'\n  \t, 'Free'\n  \t, 'dbi services'\n  \t, '2020-11-16'\n  \t, '09:00'\n  \t, '17:00'\n  \t, 'dbi services sa'\n  \t, 'Flurstrasse 30'\n  \t, '8048'\n  \t, 'Z\u00fcrich'\n  \t, 'Switzerland'\n   );\n\nupdate data.events\nset startdate = '2020-11-20'\nwhere id = 1<\/pre>\n
Now once you open the history_events table you should see the old value.<\/p>\n
\"\"<\/a><\/p>\n
Well done, it is working.<\/p>\n
Let\u2019s prepare our NodeJS environment.<\/p>\n
You can install NodeJS from https:\/\/nodejs.org\/en\/<\/a><\/p>\n
I will use Visual Studio Code editor. https:\/\/code.visualstudio.com\/<\/a><\/p>\n
Create any folder and open it in Visual Studio Code Editor.<\/p>\n
\"\"<\/a><\/p>\n
Open Terminal and initial the Project:<\/p>\n
npm init -y<\/pre>\n
After that create the folders and files<\/p>\n
mkdir configs controllers db routes services validators && touch .env index.js<\/pre>\n
routes<\/strong>: Our all routes will be defined here
\ncontrollers<\/strong>: Each route has own controller, controller handles the request and response and calls multiple services. Controllers will never access to the Database!
\nvalidators<\/strong>: Validators Objects
\nservices<\/strong>: runs one service, for example get data from the Database
\nconfigs<\/strong>: Object with configs, reads environment file attributes
\ndb<\/strong>: Database Models and connection
\n.env<\/strong>: Environment variables such as PostgreSQL connection
\nindex.js<\/strong>: Main File<\/p>\n
Now were ready to install the required dependencies:<\/p>\n
npm i express dotenv sequelize pg joi && npm i --save-dev nodemon<\/pre>\n
express<\/strong>: Framework to handle requests and responses
\ndotenv<\/strong>: Reads from .env file and adds into process variable which is readable globally
\nsequelize<\/strong>: Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction support, relations<\/strong>, eager and lazy loading, read replication and more.
\npg<\/strong>: NodeJS PostgreSQL connection \u201cdriver\u201d
\njoi<\/strong>: For validation
\nnodemon<\/strong>: Restarts the server automatically on each file changes<\/p>\n
–save-dev<\/strong> dependencies will be not installed on production environment.<\/p>\n
Firstly configure the nodemon, for that open package.json and into scripts<\/p>\n
\"start\": \"nodemon index.js\"<\/pre>\n
\"\"<\/a><\/p>\n
And then configure our .env file<\/p>\n
NODE_ENV=development\nPORT=2000\n\nDB_HOST='localhost'\nDB_USERNAME='postgres'\nDB_PASSWORD='postgres'\nDB_DATABASE='events'\nDB_PORT=5432\nDB_DIALECT='postgres'<\/pre>\n
Then, create inside the configs folder file named “config.js” and insert:<\/p>\n
require('dotenv').config();\n\nvar config = {};\n\n\/\/ General config\nconfig.node_env = process.env.NODE_ENV;\n\n\/\/ WEB config\nconfig.web = {};\nconfig.web.port = process.env.PORT;\n\n\/\/ DB config\nconfig.db = {};\nconfig.db.host = process.env.DB_HOST;\nconfig.db.username = process.env.DB_USERNAME;\nconfig.db.password = process.env.DB_PASSWORD;\nconfig.db.database = process.env.DB_DATABASE;\nconfig.db.port = process.env.DB_PORT;\nconfig.db.dialect = process.env.DB_DIALECT;\n\nmodule.exports = config;<\/pre>\n
Inside db folder, create two files: “index.js” and “event.js”<\/p>\n
Open index.js file and insert:<\/p>\n
\/* Databse connection\n******************************************************************\/\n'use strict';\nconst { Sequelize } = require('sequelize');\nconst config = require('..\/configs\/config');\nconst db = {};\n\nconst sequelize = new Sequelize(\n  config.db.database,\n  config.db.username,\n  config.db.password,\n  {\n    host: config.db.host,\n    dialect: config.db.dialect,\n    logging: false\n  }\n);\n\n\/* init models\n******************************************************************\/\ndb.sequelize = sequelize\n\ndb.Events = require('.\/event')(sequelize)\n\nmodule.exports = db;<\/pre>\n
After that open event.js<\/p>\n
'use strict';\nconst {  Model, DataTypes } = require('sequelize');\n\nmodule.exports = (sequelize) => {  \n  class Events extends Model {}\n\n  Events.init({\n    id: {\n      type: DataTypes.INTEGER,\n      primaryKey: true,\n      autoIncrement: true\n    },\n    title: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    description: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    price: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    organizator: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    startdate: {\n      type: DataTypes.DATEONLY,\n      allowNull: false\n    },\n    starttime: {\n      type: DataTypes.TIME,\n      allowNull: false\n    },\n    endtime: {\n      type: DataTypes.TIME,\n      allowNull: false\n    },\n    location_name: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    location_street: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    location_zipcode: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    location_city: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n    location_country: {\n      type: DataTypes.STRING(255),\n      allowNull: false\n    },\n  }, {\n    tableName: 'events',\n    schema: 'data',\n    sequelize,\n    modelName: 'Events',\n    createdAt: 'created_at',\n    updatedAt: 'updated_at'\n  });\n\n  return Events\n};<\/pre>\n
Now we can create our two validators. One is for creating an event and the other is for updating.
\nCreate two two file inside the validators folder: “eventCreate.js” and “eventUpdate.js<\/p>\n
Open eventCreate.js<\/strong> and insert:<\/p>\n
const Joi = require('joi')\n\nmodule.exports = EventCreateValidator = Joi.object({\n    title: Joi.string().required(),\n    description: Joi.string().required(),\n    price: Joi.string().required(),\n    organizator: Joi.string().required(),\n    startdate: Joi.string().required(),\n    starttime: Joi.string().required(),\n    endtime: Joi.string().required(),\n    location_name: Joi.string().required(),\n    location_street: Joi.string().required(),\n    location_zipcode: Joi.string().required(),\n    location_city: Joi.string().required(),\n    location_country: Joi.string().required(),\n    created_at: Joi.string(),\n    updated_at: Joi.string(),\n})<\/pre>\n
Open eventUpdate.js<\/strong> and insert:<\/p>\n
const Joi = require('joi')\n\nmodule.exports = EventUpdateValidator = Joi.object({\n    title: Joi.string(),\n    description: Joi.string(),\n    price: Joi.string(),\n    organizator: Joi.string(),\n    startdate: Joi.string(),\n    starttime: Joi.string(),\n    endtime: Joi.string(),\n    location_name: Joi.string(),\n    location_street: Joi.string(),\n    location_zipcode: Joi.string(),\n    location_city: Joi.string(),\n    location_country: Joi.string(),\n    created_at: Joi.string(),\n    updated_at: Joi.string(),\n})<\/pre>\n
As you can see on creating event there is all fields required. But if we want to update, no field is requried.
\nCreate event.service.js<\/strong> inside the services folder and insert:<\/p>\n
const db = require('..\/db\/index')\n\nmodule.exports = {\n    async getEvents() {\n        try {\n            let events = await db.Events.findAll()\n            return events\n        } catch (e) {\n            throw e\n        }\n    },\n\n    async createEvent(event){\n        try {\n            let newEvent = await db.Events.create(event)\n            return newEvent\n        } catch (e) {\n            throw e\n        }\n    },\n\n    async updateEvent(id, event){\n        try {\n            let updateEvent = await db.Events.update(event, {\n                where: {\n                    id: id\n                }\n            })\n            return updateEvent\n        } catch (e) {\n            throw e\n        }\n    },\n\n    async deleteEvent(id){\n        try {\n            let deleteEvent = await db.Events.destroy({\n                where: {\n                    id: id\n                }\n            })\n            if(deleteEvent){\n                return true\n            } else {\n                return false\n            }\n        } catch (e) {\n            console.log(e)\n            throw e\n        }\n    }\n}<\/pre>\n
Now we can create the controller: create a file named “event.controller.js”<\/strong> inside the controllers folder and insert:<\/p>\n
const eventCreate = require('..\/validators\/eventCreate')\nconst eventUpdate = require('..\/validators\/eventUpdate')\nconst eventService = require('..\/services\/event.service')\n\nmodule.exports = {\n\n    \/* get All events *\/\n    async getEvents(req, res) {\n        try {\n            let events = await eventService.getEvents()\n            res.send(events)\n        } catch (e) {\n            res.send('Internal server error')\n        }\n    },\n\n    \/* add event *\/\n    async addEvent(req, res) {\n        try {\n            const { body } = req\n\n            \/* validate input *\/\n            let inputIsValid = await eventCreate.validate(body)\n\n            if(inputIsValid.error){\n                res.send(inputIsValid.error.details[0].message)\n            } else {\n                let createdEvent = await eventService.createEvent(body)\n                res.send(createdEvent)\n            }\n        } catch (e) {\n            res.send('Internal server error')\n        }\n    },\n\n    async updateEventById(req, res) {\n        try {\n            const { body } = req\n            const { id } = req.params\n\n            \/* validate input *\/\n            let inputIsValid = await eventUpdate.validate(body)\n\n            if(inputIsValid.error){\n                res.send(inputIsValid.error.message[0].details)\n            } else {\n                let updateEvent = await eventService.updateEvent(id, body)\n                res.send(updateEvent)\n            }\n        } catch (e) {\n            res.send('Internal server error')\n        }\n    },\n\n    async deleteEventById(req, res) {\n        try {\n            const { id } = req.params\n            let deleteEvent = await eventService.deleteEvent(id)\n            res.send(deleteEvent)\n        } catch (e) {\n            res.send('Internal server error')\n        }\n    },\n}\n\nAt least we need to create our routes. Create two files inside the routes folder: \"index.js\" <\/strong>and \"event.router.js\". \n<\/strong>Open \"event.router.js\" <\/strong>and insert:\n<\/pre>\n
\/\/index router\nconst express = require('express');\nconst eventController = require('..\/controllers\/event.controller');\nconst router = express.Router();\n\n\/* get events *\/\nrouter.get('\/', eventController.getEvents)\n\n\/* post new event *\/\nrouter.post('\/', eventController.addEvent)\n\n\/* update event by id *\/\nrouter.put('\/:id', eventController.updateEventById)\n\n\/* delete event by id *\/\nrouter.delete('\/:id', eventController.deleteEventById)\n\nmodule.exports = router\n\nAt least open the \"index.js<\/strong>\" inside the routers folder and insert:<\/pre>\n
\/\/index router\nconst express = require('express');\nconst router = express.Router();\nconst eventsRouter = require('.\/event.router')\n\nrouter.use('\/events', eventsRouter)\n\nmodule.exports = router<\/pre>\n
And Finally, we can update our main index.js file:<\/p>\n
const express = require('express')\nconst routes = require('.\/routes\/index')\nconst config = require('.\/configs\/config')<\/pre>\n
const app = express()<\/p>\n
\/\/ parse requests of content-type – application\/json
\napp.use(express.json())<\/p>\n
\/\/ load routes
\napp.use(‘\/api’, routes)<\/p>\n
app.listen(config.web.port, () => {
\nconsole.log(`server is running at port ${config.web.port}`)
\n})<\/p>\n
Done. Now we can test our API Endpoints. I will use Postman<\/a><\/p>\n
First test our \/api\/events endpoint:
\n\"\"<\/a>
\nYeaah it is working!
\nSecond, test our put \/api\/events\/:id endpoint:
\nFor that you need to set headers as below:
\n\"\"<\/a><\/p>\n
Now we can update:<\/p>\n
\"\"<\/a><\/p>\n
Now we can try to add new event. First try to add an empty Object. The Validation should throw error.<\/p>\n
\"\"<\/a><\/p>\n
As aspected it is throwing error.<\/p>\n
Conclusion:<\/strong><\/p>\n
I hope you did understand the main concept. For production you might be protect the delete and put endpoints by allowing only authenticated users. For that you need to implement JWT or session Authentication.<\/p>\n
<\/pre>\n","protected":false},"excerpt":{"rendered":"
Introduction In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create our PostgreSQL Tables and history tables. And then we will continue with NodeJS. If you […]<\/p>\n","protected":false},"author":28,"featured_media":14679,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[83],"tags":[],"type_dbi":[],"class_list":["post-14678","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"acf":[],"yoast_head":"\nBuild API backend server with NodeJS and PostgreSQL - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build API backend server with NodeJS and PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"Introduction In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create our PostgreSQL Tables and history tables. And then we will continue with NodeJS. If you […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-08T11:00:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"745\" \/>\n\t<meta property=\"og:image:height\" content=\"569\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"headline\":\"Build API backend server with NodeJS and PostgreSQL\",\"datePublished\":\"2020-09-08T11:00:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\"},\"wordCount\":690,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\",\"name\":\"Build API backend server with NodeJS and PostgreSQL - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png\",\"datePublished\":\"2020-09-08T11:00:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png\",\"width\":745,\"height\":569},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Build API backend server with NodeJS and PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"caption\":\"Open source Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Build API backend server with NodeJS and PostgreSQL - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Build API backend server with NodeJS and PostgreSQL","og_description":"Introduction In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create our PostgreSQL Tables and history tables. And then we will continue with NodeJS. If you […]","og_url":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/","og_site_name":"dbi Blog","article_published_time":"2020-09-08T11:00:17+00:00","og_image":[{"width":745,"height":569,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png","type":"image\/png"}],"author":"Open source Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Open source Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"headline":"Build API backend server with NodeJS and PostgreSQL","datePublished":"2020-09-08T11:00:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/"},"wordCount":690,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/","url":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/","name":"Build API backend server with NodeJS and PostgreSQL - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png","datePublished":"2020-09-08T11:00:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/NodeJS_PostgreSQL1.png","width":745,"height":569},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/build-api-backend-server-with-nodejs-and-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Build API backend server with NodeJS and PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","caption":"Open source Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14678"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14678\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14679"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14678"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}