How to Create Endpoints to Store and Retrieve Image Records Endpoint 1: Persist Imageįirst, require the dbConnect.js file on the top of the app.js file like so: const db = require('services/dbConnect.js') It's time to unite Node, Postgres, and Cloudinary. If the image below is your result, then you are good to go:Ĭheck your pgAdmin, and you should have your table seated properly in your database like in the image below:Īlright, it's been a long road. If you are ready, let's rock and roll!Įxecute the following code in your terminal: Now we are all set to create the table in our database. export pool and createTables to be accessible from anywhere within the application Max: 10, // max number of clients in the poolĬonsole.log("connected to the Database") Ĭonst imageTable = `CREATE TABLE IF NOT EXISTS We will use this to execute the dbConnect file we are about to create.Ĭreate a services/dbConnect file to contain the following code: In your package.json file, replace the contents of the "scripts" with "create": "node.
PSQL POSTGRES APP TUTORIAL INSTALL
(Do not forget to give it all privileges.)īack in your project directory, install the node-postgres ( npm i pg) and make-runnnable ( npm i make-runnable) packages.
Create a Login/Group Role and name it tutorial.So you'll want to start by cloning this project if you don't already have it. Whenever you are ready, let’s get to work! How to Store and Retrieve an Image Record Create Database and Table If you are totally to Postgres, then check out this tutorial. If you are new to most of these technologies, I would advise you go through my other tutorial on how to create a server and upload images to Cloudinary. So you don’t have to bother about how to go about paying for them. To achieve all of this, we will be using Express (a Node.js framework), Postgres (a database), Cloudinary (a cloud based image storage), GitHub (for version control/storage) and Heroku (a hosting platform). It will be able to store a record of an image in the database, get the image's record back from the database, update the record, and even delete the record completely as the case may be. In this tutorial, we will be learning how to build and deploy an image management application backend.
0 kommentar(er)
