Recursive SQL Queries with PostgreSQL
When working with databases, most of the time, all you need is SELECT, UPDATE (CRUD operations), few JOINs and WHERE clauses and that’s about it. But, sometimes you will run into datasets and tasks, that will require you to use much more advanced features of SQL. One of them is CTE or common table expression and more specifically, Recursive CTE, which we can use to make recursive SQL queries.
Appears in lists (1)
More like this (3)
Speeding Up Recursive Queries on Hierarchic Data — A hierarchical query is an SQL query that...Speeding Up Recursive Queries on Hierarchic Data — A hierarchical query is an SQL query that handles hierarchical model data such a tree. Postgres’s standard ltree module can be used to speed up some common use cases.
Declarative recursive computation on an RDBMS… or, why you should use a database for distributed machine...Declarative recursive computation on an RDBMS… or, why you should use a database for distributed machine learing Jankov et al., VLDB’19 If you think about a system like Procella that’s combining transactional and analytic workloads on top of a cloud-native architecture, extensions to SQL for streaming, dataflow based materialized views (see e.g. Naiad, Noria, Multiverses, … Continue reading Declarative recursive computation on an RDBMS