Скачать или смотреть Insert, Delete and Update in Adjacency List Model | PostgreSQL Hierarchies (#02)

In this video, we learn how to insert, delete, and update nodes using the Adjacency List Model in PostgreSQL — one of the most practical ways to represent tree-like structures in relational databases.

📂 Code Repo:
https://github.com/Rowadz/adjacency-l...

☕ Support my work:
https://www.buymeacoffee.com/rowadz

📺 Full Adjacency List Playlist:
   • 🐾 Adjacency List Model in SQL 🐾  

🌱 Related Resources:

Trees Are Everywhere (Video) →    • A Different Way to Model Trees & Graphs — ...  

Visual Summary → https://rowadz.github.io/trees-are-ar...

Nested Sets Trees Playlist →    • 🐉 Nested Sets Trees 🐉  

Graphs & Trees Playlist →    • 🔱 Graphs & trees 🔱  

Intro Article on Adjacency Lists → https://adrianmejia.com/data-structur...

⏱️ Timestamps:
00:00 Introduction
00:20 Create the table
01:00 Inserting nodes
02:45 Deleting nodes by deleting branches (CASCADE)
03:38 Deleting a node and uplifting one of its descendants
07:37 Updates
08:05 End