PostgreSQL, sql, testing, tdd, unit testing, ddd, software-development, software-architecture, architecture, software, development, api, api-rest, restful-api, http, postgres, dotnet, net8, c#, aot, database, rest, server, postgresql, npgsqlrest, pgsql, pg, automatic, programming, arrays, model, modeling, data, data model, relational model, domain, domain model, benchmarks, plpgsql, function, functions, record, recursion, tree, cte, .net, .net core, orm, tool, temporal, history, table, tables, 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

Unit Testing and TDD With PostgreSQL is Easy

Unit Testing and TDD With PostgreSQL

From Transaction Scripts and Domain Model to SQL

From Transaction Scripts and Domain Model to SQL

Transaction Script DDD vs SQL

Transaction Script DDD vs SQL

Common Sense Software Design

Common Sense Software Design Approach for RDBMS-backed Type of Software

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

How DDD is screwing up your SQL

How DDD is screwing up your SQL

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.

What is Micro ORM?

What are the Micro ORM libraries, why do they even exist, what are their purpose, what are they used for, and what are the alternatives?

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

Piko ORM

The world's tiniest, smallest ORM for .NET

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.

Which Way .NET Developer?

You take the blue pill - the story ends, ... etc, select option 1 or option 2. Which one is better?

Haters Build Software

Some opinions on software architecture and design. What are the "ilities" what are quality attributes and why are they important for software architecture and design?

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?