Knowledge Factory

In this section, we're gonna build CRUD REST APIs using Spring Boot application that use Spring  JdbcClient  to interact with PostgreSQL database. We are recommending you to cover  Spring JdbcClient Example   tutorial to get better understanding about JdbcClient .  What we will build? We will build CRUD RESTFul APIs for a Simple Student Management System using Spring Boot, JDBC API, and the PostgreSQL database. In this application we use JdbcClient to interact with PostgreSQL database. Creating a spring boot application First, open the Spring initializr  https://start.spring.io Then, Provide the Group and Artifact name. We have provided Group name com.knf.dev.demo and Artifact spring-boot-jdbcclient-crud. Here I selected the Maven project - language Java 17 - Spring Boot 3.2.0, Spring Web,JDBC API, and PostgreSQL Driver. Then, click on the Generate button. When we click on the Generate button, it starts packing the project in a .zip(spring-boot-jdbcclient-crud) file and downloads t

In this section, we will learn how to build REST CRUD APIs with  Spring Boot ,  Spring JDBC API  and  Microsoft  Azure Database for PostgreSQL Single Server. A little bit of Background Azure Database for PostgreSQL Single Server Single Server is a fully managed database service with minimal requirements for customizations of the database. The single server platform is designed to handle most of the database management functions such as patching, backups, high availability, and security with minimal user configuration and control. The architecture is optimized to provide 99.99% availability on a single availability zone. It supports the community version of PostgreSQL 10 and 11. The service is generally available today in a wide variety of  Azure regions . More Info -  Azure Database for PostgreSQL Single Server | Microsoft Learn Spring Boot Spring Boot makes it easy to create stand-alone, production-grade Spring-based Applications that you can "just run".  More Info -  Spring