PostgreSQL – ITFROMZERO – Share tobe shared!

PostgreSQL Dynamic Data Masking: Stop Leaking Customer Data in Dev/Test

By admin May 31, 2026

Forget manual UPDATE scripts! Learn how to use postgresql_anonymizer to professionally and safely mask sensitive data in PostgreSQL for Dev/Test environments.

Development

Building a Professional-Grade REST API with NestJS and PostgreSQL: From Zero to Validation

By admin May 31, 2026

Want to build industry-standard REST APIs? This guide will help you master NestJS and PostgreSQL, from database setup to professional data validation techniques.

Database

Installing FerretDB: How to Run MongoDB on PostgreSQL to Simplify Your Infrastructure

By admin May 30, 2026

Install FerretDB to run MongoDB on PostgreSQL: The perfect solution to save resources, simplify DevOps workflows, and escape MongoDB SSPL licensing hurdles.

Database

Turning PostgreSQL into a Graph Database with Apache AGE: When SQL and Cypher Converge

By admin May 29, 2026

Learn how to turn PostgreSQL into a powerful Graph Database with Apache AGE. Detailed guide from installation to Cypher queries for social networks and recommendation systems.

Database

Percona Monitoring and Management (PMM) Setup Guide: Advanced MySQL and PostgreSQL Monitoring

By admin May 28, 2026

PMM is a tool that gives you deep visibility into MySQL and PostgreSQL performance. This guide covers quick setup and real-world Query Analytics optimization tips.

Database

Optimizing PostgreSQL with pgpool-II: Real-world Pooling, Load Balancing, and Caching Solutions

By admin May 28, 2026

Is your PostgreSQL system overloaded with connections? Discover how pgpool-II solves connection pooling, load balancing, and query acceleration in this practical guide.

Centos

Installing PostgreSQL 16 on CentOS Stream 9: A Survival Guide for Production Environments

By admin May 27, 2026

A production-ready guide for installing PostgreSQL 16 on CentOS Stream 9. This article focuses on SELinux, Firewalld security, and practical performance tuning tips.

Database

Optimizing PostgreSQL Dashboards: Speed up Queries 100x with Materialized Views

By admin May 27, 2026

Discover the power of Materialized Views in PostgreSQL. An optimal solution to make dashboards load instantly by storing pre-calculated query results.

Database

Barman: Professional PostgreSQL Production Backup Solution – From WAL Archive to PITR

By admin May 27, 2026

Don't let pg_dump keep you up at night. Detailed guide on using Barman for professional PostgreSQL backup management with second-precision data recovery (PITR).

Database

Scaling PostgreSQL ‘Unlimited’ with Citus: From 1 Billion to Tens of Billions of Records

By admin May 22, 2026

Citus is the leading solution for Horizontal Sharding in PostgreSQL. Learn how to set up a cluster, choose a Shard Key, and optimize performance for systems with billions of records.