2022-04-04-TIL

Today I Learned

Spring4Shell 제로데이 취약점

  • https://m.blog.naver.com/skinfosec2000/221282525919
  • https://www.lunasec.io/docs/blog/spring-rce-vulnerabilities/
  • https://svrforum.com/itnews/222674

기본키 전략, 자연키 vs 인조키

  • https://stackoverflow.com/questions/590442/deciding-between-an-artificial-primary-key-and-a-natural-key-for-a-products-tabl
  • https://sqlstudies.com/2016/08/29/natural-vs-artificial-primary-keys/
  • https://rampart81.github.io/post/surrogate_key_vs_natural_key/
  • https://www.databasejournal.com/ms-sql/sql-server-natural-key-verses-surrogate-key/
  • https://www.mssqltips.com/sqlservertip/5431/surrogate-key-vs-natural-key-differences-and-when-to-use-in-sql-server/
  • https://ncucu.me/26
  • https://multifrontgarden.tistory.com/180
  • https://bunhere.tistory.com/45

Spring Boot YAML

  • https://www.baeldung.com/spring-yaml
  • https://www.baeldung.com/spring-boot-yaml-vs-properties
  • https://www.amitph.com/spring-boot-yaml-to-list/
  • https://www.baeldung.com/spring-boot-yaml-list
  • https://docs.spring.io/spring-boot/docs/current/reference/html/application-properties.html
  • https://kwonnam.pe.kr/wiki/springframework/springboot/properties
  • https://herdin.github.io/2020/02/04/spring-property
  • https://galid1.tistory.com/664

Spring Boot Multiple Profiles

application.properties에서는 파일을 분리하는게 더 자연스러운 방법이지만, application.yml에서는 그냥 ---으로 구분하는 것이 가장 자연스러운 방법인 것 같다. 파일로 분리해서 인식시키는 방법도 존재하나 기본값은 아니므로 별도의 설정이 필요하다. YAML설정이 아무리 길어지더라도 그냥 ---으로 구분하자.

  • https://mkyong.com/spring-boot/spring-boot-profile-based-properties-and-yaml-example/
  • https://stackoverflow.com/questions/52627023/how-can-i-create-profiles-with-spring-boot-yaml
  • https://stackoverflow.com/questions/34063678/loading-multiple-yaml-files-using-configurationproperties
  • https://1minute-before6pm.tistory.com/12
  • https://www.oreilly.com/library/view/mastering-spring-boot/9781787127562/47bb7db6-fb7d-4d09-9bcc-7c1149f4f9e7.xhtml
  • https://blog.yevgnenll.me/posts/multiple-profiles-inside-a-single-yaml-file
  • https://stackoverflow.com/questions/23134869/spring-boot-how-to-use-multiple-yml-files