Tech watch

PostgreSQL

Modeling, querying and operating PostgreSQL relational databases.

1 Nov 2026Article

.NET range types as first-class domain objects

Article banner showing its title, Ricardo Groß’s name, and the date “Jun 11” on a white background.

CodoMetis.ValueRanges offers .NET range types to replace pairs of dates and their scattered logic. Its five variants—finite, unbounded on either side, infinite, and empty—make possible shapes and rules explicit, while operations such as Contains and Overlaps run in memory.

The companion EF Core package bridges the domain model to PostgreSQL: the same operations are translated into SQL operators through Npgsql. The article also explains the design trade-off: abstract records rather than structs, so each variant can be represented by a type hierarchy.

.NET C#Entity Framework Core PostgreSQL Software Architecture

@Found via C# Digest

22 Oct 2026Article

PGX: disposable PostgreSQL databases for agents and tests

github.comPermalink

GitHub preview of the pgrundev/pgx repository, described as lightweight PostgreSQL for AI agents, written in Rust.

PGX runs isolated PostgreSQL databases inside a single Rust runtime, targeting short-lived agent, CI, and test environments. On-demand creation from a sealed template and copy-on-write on ZFS reduce the cost of branching; without block cloning, the system makes a full copy.

The project is at v0.1.0 and targets disposable databases, not production data: fsync is disabled, and one runtime is a single failure domain. Its benchmarks document their measurements and conditions; the PostgreSQL regression suite reports zero result differences in the stated configuration, without claiming general compatibility.

PostgreSQL Testing AI Agents CI/CD

19 Jul 2025Repository

FireGEO: a SaaS starter for brand visibility monitoring

github.comPermalink

FireGEO combines authentication, billing, AI chat and brand monitoring in a Next.js and PostgreSQL application. The repository documents prerequisites and setup.

Next.js PostgreSQL SEO

26 Feb 2025Tool

PeerDB: replicate PostgreSQL into data warehouses

peerdb.ioPermalink

PeerDB focuses on replication from PostgreSQL into analytical systems and queues. The site presents change data capture and its ClickHouse integration.

PostgreSQL Databases

30 Jul 2023Tool

Build an application on Postgres with Supabase

supabase.comPermalink

Supabase combines Postgres with authentication, REST APIs, functions, storage, and realtime sync. The platform provides common backend services while keeping data in a portable database.

Supabase PostgreSQL Databases

@supabase