postgresql, programming, arrays, ddd, sql, model, modeling, data, data model, relational model, domain, domain model, benchmarks, plpgsql, function, functions, record, temporal, history, table, tables, recursion, tree, cte, database, stored procedure, procedure

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

PostgreSQL Arrays 🐘

PostgreSQL Array Example

How DDD is screwing up your SQL

How DDD is screwing up your SQL

PostgreSQL Paging Benchmarks

PostgreSQL Paging Benchmarks

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.

What have the STORED PROCEDURES ever done for us?

Apart from security, performance, maintainability, and availability, what STORED PROCEDURES have ever really done for us?