# PostgreSQL · Tech watch

[Canonical source](<https://sebastien.rigaux.be/en/tech-watch/tags/postgresql>)

Modeling, querying and operating PostgreSQL relational databases.

## [.NET range types as first-class domain objects](<https://sebastien.rigaux.be/en/tech-watch/links/net-range-types-as-first-class-domain-objects>)

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.

2026-11-01 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/net-range-types-as-first-class-domain-objects.md>) · [Original resource](<https://dev.to/caffeinatedcoder/the-interval-is-the-thing-modelling-range-types-as-first-class-domain-objects-in-net-3jha>)

## [PGX: disposable PostgreSQL databases for agents and tests](<https://sebastien.rigaux.be/en/tech-watch/links/pgx-disposable-postgresql-databases-for-agents-and-tests>)

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.

2026-10-22 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/pgx-disposable-postgresql-databases-for-agents-and-tests.md>) · [Original resource](<https://github.com/pgrundev/pgx>)

## [FireGEO: a SaaS starter for brand visibility monitoring](<https://sebastien.rigaux.be/en/tech-watch/links/firegeo-a-saas-starter-for-brand-visibility-monitoring>)

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

2025-07-19 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/firegeo-a-saas-starter-for-brand-visibility-monitoring.md>) · [Original resource](<https://github.com/firecrawl/firegeo>)

## [PeerDB: replicate PostgreSQL into data warehouses](<https://sebastien.rigaux.be/en/tech-watch/links/peerdb-replicate-postgresql-into-data-warehouses>)

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

2025-02-26 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/peerdb-replicate-postgresql-into-data-warehouses.md>) · [Original resource](<https://peerdb.io/>)

## [Build an application on Postgres with Supabase](<https://sebastien.rigaux.be/en/tech-watch/links/build-an-application-on-postgres-with-supabase>)

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.

2023-07-30 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/build-an-application-on-postgres-with-supabase.md>) · [Original resource](<https://supabase.com/>)