Database 綜合

Ask HN: Is PostgreSQL better than MySQL? | Hacker News

Relationship

via: Mastering Relational Database Design: A Comprehensive Guide - DEV Community

New DB

How RocksDB works - Artem Krylysov

Topics

Change-Data-Capture, CDC

• PostgreSQL 技術筆記: 跟疾管署沒有關係的CDC. 繼上次 Dcard Tech Sharing… | by Dcard Tech | Dcard Tech Blog | Medium - Dcard (PostgreSQL)
• DBLog: A Generic Change-Data-Capture Framework | by Netflix Technology Blog | Netflix TechBlog - netflex (MySQL)

資料遮蔽

古永忠 COSCUP, 2023

https://www.linkedin.com/posts/ycku_%E8%B3%87%E6%96%99%E8%94%BD%E5%AF%A6%E5%8B%99-activity-7091439013726728192-IyI5

https://youtu.be/ocwNlci0x7w?si=c3GYTDPT3smDWdLP

Performance

• SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...

hierarchical

• https://stackoverflow.com/questions/4048151/what-are-the-options-for-storing-hierarchical-data-in-a-relational-database
• http://troels.arvin.dk/db/rdbms/links/#hierarchical
• https://vadimtropashko.wordpress.com/2008/08/09/one-more-nested-intervals-vs-adjacency-list-comparison/
• https://www.slideshare.net/billkarwin/models-for-hierarchical-data