Resources: Backend

[sammdu]

Whenever someone asks you to install/use Postman, DO NOT (unless you want to then go ahead).
We can use Advanced REST Client (ARC), which is linked below under Useful Resources

Learning the Spring Framework for Java

• Static Tutorials
  • https://spring.io/guides/gs/rest-service/
• Videos
  • Spring Boot Tutorial — FreeCodeCamp https://youtu.be/vtPkZShrvXQ?t=66
  • Spring Boot - Building RESTful Web Service — Spring Academy https://youtu.be/7cvQzHC2kDE
  • Rest Controllers in Spring Boot Tutorial — Ivan Jakimovski https://www.youtube.com/watch?v=MnO5wNpE2NU

Learning SQL Basics

If asked to install some SQL database software, you do NOT need to. (Unless you want to, then go for it.)
Just use db.autodirect.tech, port 5432, https protocol (TLS/SSL). Ask @sammdu for access credentials.
Create a test table, e.g. test_samm, so it's easy to find and delete later.

• Static Tutorials
  • https://www.dataquest.io/blog/sql-basics/
  • https://www.tutorialspoint.com/sql/sql-overview.htm
  • https://www.sqltutorial.org/
• Interactive Tutorials
  • https://sqlbolt.com/
  • https://www.learnsqlonline.org/
• Videos
  • Learn Basic SQL in 15 Minutes — Vitamin Business Intelligence https://youtu.be/kbKty5ZVKMY?t=140
  • Python SQLite Tutorial — Corey Schafer https://www.youtube.com/watch?v=pd-0G0MigUA
    • I know this is in Python, but you already know Python, so it's easier to get started. Trust me this is helpful.
  • PostgreSQL Tutorials — Corey Schafer https://www.youtube.com/playlist?list=PL-osiE80TeTsKOdPrKeSOp4rN3mza8VHN

Learning PostgreSQL, Java Integration, and Full-Text Search

• Static Tutorials (PostgreSQL & Java)
  • https://www.postgresqltutorial.com/postgresql-jdbc/
  • https://jdbc.postgresql.org/documentation/head/setup.html
  • https://www.tutorialspoint.com/postgresql/postgresql_java.htm
  • https://zetcode.com/java/postgresql/
• Videos (PostgreSQL & Java)
  • Connect a PostgreSQL database to a Spring Boot Application Tutorial — Ivan Jakimovski https://youtu.be/A8qZUF-GcKo
• Static Tutorials (PostgreSQL Full Text Search)
  • https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database
  • https://compose.com/articles/mastering-postgresql-tools-full-text-search-and-phrase-search/
  • https://hevodata.com/blog/postgresql-full-text-search-setup/
  • https://www.postgresql.org/docs/current/textsearch.html
• Videos (PostgreSQL Full Text Search)
  • Full Text Search PostgreSQL — Ben Awad https://www.youtube.com/watch?v=szfUbzsKvtE
  • "The State of (Full) Text Search in PostgreSQL 12" — Jimmy Angelakos https://youtu.be/c8IrUHV70KQ?t=160
• Other PostgreSQL Reference
  • https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-20-04
  • https://www.digitalocean.com/community/tutorials/how-to-use-roles-and-manage-grant-permissions-in-postgresql-on-a-vps-2

Useful Resources

• Advanced REST Client
  • Allows you to test and play with APIs and save your options
  • Use this instead of Postman
  • https://install.advancedrestclient.com/install
• Beekeeper Studio
  • Allows you to test and edit databases, compose SQL queries, etc
  • https://www.beekeeperstudio.io/
  • The AutoDirect database host is db.autodirect.tech, port 5432, https protocol (TLS/SSL). Ask @sammdu for access credentials.

Deployment and Linux Servers

• Deploy a Spring application / generating WAR files:
  • https://www.tutorialspoint.com/spring_boot/spring_boot_tomcat_deployment.htm
  • https://javacodehouse.com/courses/spring-boot/Lesson-16-Deployment/
  • https://www.webucator.com/article/how-to-deploy-a-war-file-to-apache-tomcat-linux/
• Install and configure Apache Tomcat with an Nginx Reverse Proxy
  • MUST USE TOMCAT 9! TOMCAT 10 DOES NOT WORK!
  • https://www.digitalocean.com/community/tutorials/install-tomcat-9-ubuntu-1804
  • https://www.digitalocean.com/community/tutorials/how-to-encrypt-tomcat-8-connections-with-apache-or-nginx-on-ubuntu-16-04#option-2-http-proxying-with-nginx
  • https://www.digitalocean.com/community/tutorials/how-to-secure-nginx-with-let-s-encrypt-on-ubuntu-20-04