Traversing a tree stored as an adjacency list using a Recursive CTE built in SQLAlchemy
This is part of a series on combining PostgreSQL Materialized Views, Recursive CTEs, and SQLAlchemy: Using SQLAlchemy to create and manage PostgreSQL Materialized Views Traversing a tree stored as an adjacency list using a Recursive CTE built in SQLAlchemy (this post) The problem: Recently, while working on the RockClimbing.com codebase, I encountered several situations where data needed to […]