SQL Design Patterns
by Vadim Tropashko · first published 2007
3mentions
2recommended by
3HN commenters
2015–2018first – last mentioned
67% recommend33% neutral
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
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...
on “User-defined Order in SQL” ↗All of the Joe Celko books and https://www.amazon.com/SQL-Design-Patterns-Programming-Focus...
on “Be Careful with UUID or GUID as Primary Keys” ↗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-...…
on “Tree structure query with PostgreSQL” ↗