api, api-rest, restful-api, http, postgres, dotnet, net8, c#, aot, database, rest, server, postgresql, npgsqlrest, pgsql, pg, automatic, programming, arrays, sql, benchmarks, plpgsql, function, functions, record, recursion, tree, cte, tool, temporal, history, table, tables

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

NpgsqlRest v2 Update 🐘🔥

Automatic REST API for PostgreSQL Database as .NET8 Middleware

NpgsqlRest Update 1.6.2

Automatic REST API for PostgreSQL Database as .NET8 Middleware

PostgreSQL Arrays 🐘

PostgreSQL Array Example

PostgreSQL Paging Benchmarks

PostgreSQL Paging Benchmarks

NpgsqlRest NuGet Library

Automatic REST API for PostgreSQL Database as .NET8 Middleware

Execute Custom Function For Each Record

PostgreSQL crazy experiment with the record type.

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.

PgRoutiner Documentation

PgRoutiner Documentation

PgRoutiner Code-Gen

PgRoutiner Database Management

PgRoutiner Blog

Database-First Tool for Development With .NET And PostgreSQL Native Build

PgRoutiner Concept

PgRoutiner High Level Concept

PgRoutiner Database Management

PgRoutiner Database Management

Custom Temporal Tables in PostgreSQL

PostgreSQL script that implements temporal tables without extension.

Recursion with PostgreSQL Part 3 - Cycle Detection

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