Database Extensions — 3 Technical Articles

Dec 15, 2025 · Databases

Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming

The article explains how PostgreSQL has evolved from a simple relational store into a versatile platform that supports full‑text search, vector similarity, geospatial queries, JSONB, message queues, and analytical workloads, allowing developers to replace multiple specialized tools with a single unified system.

Database ExtensionsEvent StreamingFull-text search

0 likes · 6 min read

Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming

ITPUB

Jun 21, 2018 · Databases

Why PostgreSQL Is the Ultimate Full‑Stack Database for Modern Apps

The article explains how PostgreSQL can serve as a single, full‑stack database covering OLTP, OLAP, streaming, time‑series, spatial, search, NoSQL, data‑warehouse, graph, and caching workloads, while offering strong operational features, a vibrant ecosystem, and only a few manageable drawbacks.

Database ExtensionsFull-Stack DatabaseOperational Features

0 likes · 9 min read

Why PostgreSQL Is the Ultimate Full‑Stack Database for Modern Apps

ITPUB

Jan 19, 2016 · Databases

Surprising PostgreSQL Features That Redefine What a Database Can Do

This article showcases seven remarkable PostgreSQL extensions—including multi‑master replication, Greenplum MPP OLAP, pg_shard/FDW sharding, PostGIS 3D GIS, GPU‑accelerated PG‑Strom, PipelineDB streaming, and the versatile FDW interface—illustrating how they enable high‑availability, massive analytics, geographic intelligence, and real‑time data processing.

Database ExtensionsFDWGIS

0 likes · 5 min read

Surprising PostgreSQL Features That Redefine What a Database Can Do