2023-03-21-TIL

2023-03-21-TIL

Today I Learned

Role Group Database Design

• https://dba.stackexchange.com/questions/90193/multiple-user-roles-with-different-attributes
• https://dba.stackexchange.com/questions/186130/designing-a-database-structure-for-a-permissions-system
• https://mysql.tutorials24x7.com/blog/guide-to-design-database-for-rbac-in-mysql
• https://stackoverflow.com/questions/50969509/user-role-permissions-and-a-specific-group-rbac

Menu Table

메뉴에 대한 접근이나 관리를 위해서 DB의 테이블에 메뉴를 저장해놓고 사용하는 것이 장점이 있다고 한다.

• https://stackoverflow.com/questions/34605480/what-is-the-benefits-of-creating-menu-for-web-application-based-on-database
• https://stackoverflow.com/questions/21399549/application-performance-database-table-for-dropdown-menus-vs-population-in-cod?rq=1
• https://www.codeproject.com/Articles/461654/Generating-menu-from-database-according-to-user-pr

Progressive Download vs Streaming

progressive download는 비디오가 클라이언트의 컴퓨터에 직접 다운로드 되는 방식이다. 기본적으로 HTTP를 사용하며 보안수준은 낮다. streaming은 임시 비디오 링크를 통해 비디오 콘텐츠를 보호한다. RTMP를 사용하며 보안수준은 상대적으로 높다.

• https://www.brightcove.com/en/resources/blog/progressive-download-versus-streaming/

Dolby Atmos

• https://azure.microsoft.com/es-es/blog/delivering-premium-audio-experiences-with-dolby-digital-plus/
• https://docs.aws.amazon.com/mediaconvert/latest/ug/using-dolby-atmos-encoding.html
• https://namu.wiki/w/Dolby%20Atmos

Full-text Search with MySQL and Elasticsearch

• https://medium.com/@mazraara/full-text-search-with-mysql-and-elasticsearch-b48e79a8ad4a

Boolean Field vs Y/N

• https://salesforce.stackexchange.com/questions/47980/boolean-field-v-yes-no-picklist
• https://stackoverflow.com/questions/1908454/using-0-1-versus-y-n-versus-t-f-in-a-logical-boolean-database-fiel
• https://stackoverflow.com/questions/615702/is-there-a-difference-between-yes-no-true-false-and-true-false-in-objective-c

HTTP Headers

• https://gmlwjd9405.github.io/2019/01/28/http-header-types.html
• https://velog.io/@jkijki12/HTTP-Header-%EC%A0%95%EB%A6%AC
• https://developer.mozilla.org/ko/docs/Web/HTTP/Headers
• https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/administrating/cem-configuration/transaction-definition/about-transaction-identification/http-request-parameter-types.html

Instancio

• https://www.instancio.org/user-guide/#creating-a-stream-of-objects
• https://github.com/instancio/instancio