Knowledge Factory

In this section, we will learn how to develop a REST-style web service with .Net 6 , Npgsql Entity Framework Core provider for PostgreSQL and PostgreSQL Database. GitHub repository link is provided at the end of this tutorial. You can download the source code.  These are APIs that .Net backend App will export: Create database and table First, you need to create a database in the PostgreSQL server. You can use the following command to create a database in the PostgresSQL server: CREATE DATABASE testdb; Create table: CREATE TABLE IF NOT EXISTS public.users (     id           serial primary key ,     email         VARCHAR ( 40 ) not null ,     first_name   VARCHAR ( 40 ) not null ,     last_name     VARCHAR ( 40 ) not null ); Project directory: User Entity Path: /Entities/User.cs The user entity class represents the data stored in the database for users. namespace WebApi.Entities; using System.Text.Json.Serialization; public class User {     public int Id { get ; set ; }    

In this section,  we will learn how to develop a full-stack web application that is a basic User Management Application using Spring Boot 3, PostgreSQL, and Vue 3. You could download the source code from our Github repository, the download link is provided at the end of this tutorial. After completing this tutorial what we will build? We will build a full-stack web application that is a basic User Management Application with CRUD features:  • Create User  • List User  • Update User  • Delete User     We divided this tutorial into two parts.   PART 1  - Restful API Development with Spring Boot 3 & PostgreSQL. PART 2  - UI development using Vue JS 3. PART 1 - Restful API Development with Spring Boot 3 & PostgreSQL These are APIs that Spring backend App will export: Backend project directory: pom.xml A Project Object Model or POM is the fundamental unit of work in Maven. It is an XML file that contains information about the project and configuration details utilized by Maven to bu