logo

Contact us

Blogs

Code Generation NodeJs and PostgreSQL

AutoCodeGen now supports REST API code generation for the PostgreSQL database.

logo

If you know how to write SQL queries for the PostgreSQL database, then you should be able to build a backend web service without having to write a single line of code using AutoCodeGens code generation platform.

In this article, we will discuss how to generate NodeJS REST API code, which communicates with the PostgreSQL database and performs CRUD operations.

Go to AutoCodeGen and click on get started anywhere within the page, it will take us to the code generation platform. If you do not have an account, drop your email and signup. And once you are inside, you will see what is shown below.

logo

You have access to a free subscription, which is shared by all users of autocodegen. Click on the View button, which will take us to the project page.

logo

On the project page, click on create, and you can choose between MongoDB and PostgreSQL for the database. Choose PostgreSQL database. Node.JS is the only programming language to choice currently. Now we give it a project name.

logo

We are going to build a school_students_info_manager project, which manages basic information about school students. When the project is created it will be available in the table below, now click on create to launch the project.

Once inside give it a project name again and save it.

logo

Before we go on to define our data structure, let us see what are all the different data types that are available to us.

logo

As we can see above, we have Text, Text array, Numeric, Numeric Array, Boolean, Varchar, Varchar Array, Date, and Time. Geeks for Geeks has good information on when to use what data types for the PostgreSQL database, and you can check it out here.

Now let us input the data structure for our student info table as shown below.

logo

And once it is done follow below steps to generate code,

  • click on generate button
  • paste the project name in the same format
  • and then click on “Generate”.

logo

Once the code generation is done, which will take like a couple of seconds, you are good to download the code.

logo

What we see above is the list of files generated. The package.json file is where all our dependencies are defined. index.js is our entry point for the web service, you can know more about each of the files by going through the code.

logo

No modifications need to be made apart from updating our PostgreSQL DB connection information, which you can do from here. Once it is done, it is time to run the following command from your VS code terminal, which is npm i, which will install all the necessary dependencies, and node index.js, which will run our server at http://localhost:8080

logo

As we can see above, our server is up and running on port 8080, Great success, we got a backend server up and running without writing a single line of code. Now it is time to test it using Postman, which we will discuss in the upcoming article.

Talk to us...

logo

© 2022 AutoCodeGen. All rights reserved

Company

About usOur BlogsContact Us