{"repo":"OKaluzny/spring-boot-rest-api-postgresql","free":true,"listed":false,"github":"https://github.com/OKaluzny/spring-boot-rest-api-postgresql","clone":"git clone https://github.com/OKaluzny/spring-boot-rest-api-postgresql.git","description":"Plain RESTful Web Service with Spring Boot 4. Using PostgreSQL database, Hibernate and basic authentication. Also added the lombok.","language":"Java","stars":67,"topics":["postgresql-database","hibernate","spring-security","lombok","spring-data-jpa","spring-web","spring-rest","postgresql","rest-api","springboot4"],"license":null,"category":"databases-storage","readme_excerpt":"Spring Boot REST API with PostgreSQL Educational project: REST API for managing books built with Spring Boot 4 and PostgreSQL. What You Will Learn - Building REST API with Spring Boot - Working with databases using Spring Data JPA - Data validation - Error handling (RFC 7807 Problem Details) - Basic Authentication - Swagger/OpenAPI documentation - Docker for database - Writing tests Requirements Before starting, make sure you have installed: - Java 17+ — check: java -version - Maven 3.8+ — check: mvn -version - Docker — check: docker --version Quick Start (5 minutes) Step 1: Clone the repository Step 2: Start PostgreSQL Verify the container is running: You should see container book-db with status Up . Step 3: Run the application Wait for the message: Step 4: Open Swagger UI Open in browser: http://localhost:8080/swagger-ui.html Here you can interactively test the API. Step 5: Authorization API requires authentication: - Username: user - Password: user In Swagger UI click the \"Authorize\" button and enter these credentials. Your First Request with curl Create a book: Response: Get all books: API Endpoints Method URL Description -------- ----- ------------- POST /api/books Create a book GET /api/books Get all books (paginated) GET /api/books/{id} Get book by ID GET /api/books?name=Java Search by name PUT /api/books/{id} Update a book DELETE /api/books/{id} Delete a book Pagination - page — page number (starting from 0) - size — number of items per page - sort — sorting (field,di","default_branch":null,"files":null,"tree":[],"storefront":"/r/OKaluzny","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/OKaluzny/spring-boot-rest-api-postgresql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}