Posts

Showing posts with the label PostgreSQL

Azure Database for PostgreSQL Single Server + Spring Boot - Build REST CRUD APIs

Image
Hello everyone, Hope you are doing well. In this tutorial, you will learn how to build REST CRUD APIs with  Spring Boot ,  Spring Data JPA  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 -  https://docs.microsoft.com/en-us/azure/postgresql/single-server/overview-single-server Spring Boot Spring Boot makes it easy to create stand-alone, production-grade Spring-based A

Spring Data JDBC, PostgreSQL, CRUD Example

Image
  Hello everyone, In this article, we will learn how to develop a  REST-style web service with Spring Boot, Spring Data JDBC, and PostgreSQL Database. GitHub repository link is provided at the end of this tutorial. You can download the source code. What's new in this example?  From Java 14 onwards,  the record  is a special type of class declaration aimed at reducing the boilerplate code. For more info  click here From Java 10 onwards,  the var  keyword allows local variable type inference, which means the type for the local variable will be inferred by the compiler, so we don't need to declare that. For more info  click here Technologies used :  Spring Boot 2.6.3 Spring  Data JDBC  Java 17  PostgreSQL Maven 3+  These are APIs that Spring backend App will export:   GET all User's        :     /api/v1/users             : get  GET User by ID     :     /api/v1/users/{id}       : get CREATE User        :     /api/v1/users             : post UPDATE User        :     /api/v1/user