postgresql, sql, plpgsql, function, functions, record, temporal, history, table, tables, recursion, tree, cte

all blogs 26 # aot 3 # benchmarks 1 # c# 8 # csharp 1 # database 6 # ddd 1 # dotnet 9 # general 11 # net8 3 # npgsqlrest 3 # orm 2 # pgroutiner 5 # plpgsql 6 # postgres 3 # postgresql 16 # rest 3 # software architecture 4 # software design 4 # software development 11 # sql 10 # stored procedure 1 # tool 5

Execute Custom Function For Each Record

PostgreSQL crazy experiment with the record type.

Custom Temporal Tables in PostgreSQL

PostgreSQL script that implements temporal tables without extension.

Recursion with PostgreSQL Part 1 - A Different Type of Recursion

Exploring a different approach to recursion with PostgreSQL by using recursive plpgsql function instead of recursive CTE query.

Recursion with PostgreSQL Part 2 - Performances

Follow-Up 1 on PostgreSQL recursive function. Some performance optimizations.

Recursion with PostgreSQL Part 4 - Finding the Right Path

The last part of the PostgreSQL recursive function series resolves a mystery and tree paths calculation — final performance benchmarks.

Recursion with PostgreSQL Part 3 - Cycle Detection

Follow-Up 2 on PostgreSQL recursive function. Learning the cycle detection in recursive queries.