Java Spring Boot with PostgreSQL — CRUD API Project: Part 1/2 (Tools Installation)

• Open VS Code
• CTRL + SHIFT + p OR Type ‘>’ in the Search bar — Spring Initializr: Create a Maven project
• Specify Spring Boot version — 3.2.0
• Specify project language — Java
• Group Id — com.example
• Artifact Id — employer
• Specify packaging type — Jar
• Specify Java version — 17
• Dependencies —
  • Spring Web
  • Spring Boot DevTools
  • Lombok
  • Spring Data JPA

• Specify a folder to generate the boilerplate project with dependencies injected

‘Spring Boot’ is a tool that makes developing web applications and microservices with Java Spring Framework faster and easier. It makes it easy to create stand-alone, production-grade Spring based Applications that you can “just run”.

‘Spring Web’ starter dependency allows you to build Spring-based web applications with minimal configuration by adding all the necessary dependencies — such as the Apache Tomcat web server — to your project.

‘Spring Boot’ includes an additional set of tools that can make the application development experience a little more pleasant. The spring-boot-dev tools module can be included in any project to provide additional development-time features.

‘Spring boot Lombok’ is nothing but a small library that was used to reduce the unused code from the Java applications. It automatically generates the getter and setter method for the class object by using Lombok annotation. It is also used to minimize/remove the boilerplate code and save the precious time of developers during development by just using some annotations.

Developers can use the Java Persistence API (JPA) to create object-oriented versions of relational database entities to use in their applications. JPA handles most of the complexity of JDBC-based database access and object-relational mappings. On top of that, ‘Spring Data JPA’ reduces the amount of boilerplate code required by JPA. That implements your persistence layer easier and faster.

Make sure to set the path in the environment variables as PG_HOME with the \bin path and verify using the command postgres –version in CMD.

Ensure to note down the username, password, and port address provided during the installation procedure.

‘PostgreSQL’ is an object-relational database management system that offers more features than MySQL. It gives you more flexibility in data types, scalability, concurrency, and data integrity.

It is an ACID-compliant RDBMS. In other words, it offers atomicity, consistency, isolation, and durability features. PostgreSQL’s advanced features include stored procedures, triggers, user-defined functions, transactions, and replication.

‘Postman’ provides an intuitive and user-friendly interface, allowing users to easily create, test, and manage API requests. Postman supports multiple HTTP methods such as GET, POST, PUT, and DELETE, enabling users to test and debug a variety of API endpoints.

‘DBeaver’ provides lots of built-in database connectors to connect with various databases. The inbuilt database functions are popped up while you are typing the function name, which makes the developer write SQL at a faster phase.