SQL Design Patterns

What Hacker News says

1. mciMar 2018
   Vadim Tropashko wrote a book "SQL Design Patterns" that, among others, presents non-trivial approaches to storing trees and graphs in SQL databases. I highly recommend it. The PDF version is free here: https://vadimtropashko.wordpress.com/%E2%80%9Csql-design-pat...
   thread
2. sitkackJun 2017
   All of the Joe Celko books and https://www.amazon.com/SQL-Design-Patterns-Programming-Focus...
   thread
3. chxFeb 2015
   I am not sure of performance. What I do know is that Vadim Tropashko's SQL Design Patterns has a few ideas on how to encode a materialized path see http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.102... . Also, bojanz and me have ideas here, see http://bojanz.wordpress.com/2014/04/25/storing-hierarchical-... and I know that these are as fast as they can be.
   thread