Search Articles — Sudonull

https://sudonull.com/select-queries-in-clickhouse-differences-from-postgresql-prewhere-sample

PREWHERE, SAMPLE, FINAL, IN vs JOIN, FORMAT, top 10 queries for betting analytics. How to migrate SQL from PostgreSQL to ClickHouse without errors.

https://sudonull.com/database-architecture-for-parsing-tariffs-on-postgresql

Study the star schema for storing internet and TV tariffs: fact tables, dimensions, historicity triggers, indexes. Full SQL code for middle/senior developers. Implement provider monitoring without data loss.

https://sudonull.com/health-score-for-postgresql-health-monitoring

Learn how Health Score combines 150 PostgreSQL metrics into one indicator. Formulas, SQL queries, category weights and auto-diagnostics for DBA. Implement in your infrastructure.

https://sudonull.com/calculation-view-in-asapbi-without-sql

Learn how to visually build analytical models in asapBI for ADB, PostgreSQL and Trino. Export to UDF, clusters without load on DB. For DWH developers.

https://sudonull.com/ltree-in-postgresql-with-jpa-storing-trees

Integration of ltree for hierarchical data in PostgreSQL and JPA. Performance comparison with recursive SQL. Application in microservices for developers.

PostgreSQL: The world's most advanced open source database

https://www.postgresql.org/

12 hours ago · PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, …

PostgreSQL: Downloads

https://www.postgresql.org/download/

PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it yourself.

PostgreSQL - Wikipedia

https://en.wikipedia.org/wiki/PostgreSQL

PostgreSQL was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. [27][28] In 1996, the project was …

PostgreSQL Tutorial - W3Schools

https://www.w3schools.com/postgresql/index.php

In this tutorial you get a step by step guide on how to install and create a PostgreSQL database. You will learn how to create a project where you can create, read, update, and delete data.

PostgreSQL Tutorial - GeeksforGeeks

https://www.geeksforgeeks.org/postgresql/postgresql-tutorial/

Jun 10, 2026 · PostgreSQL is a free and open-source database management system used to store, organize and manage data efficiently. It is one of the most popular databases because it is reliable, …

pgAdmin - PostgreSQL Tools

https://www.pgadmin.org/

Mar 16, 2026 · The most popular and feature-rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

PostgreSQL Tutorial

https://www.pgtutorial.com/

This PostgreSQL tutorial teaches you PostgreSQL from beginner to advanced through many practical and real-world examples.

Introduction | Postgres Guide - The Complete PostgreSQL Resource

https://postgres.guide/docs/intro/

Learn PostgreSQL fundamentals, benefits, and essential features - your comprehensive guide to this powerful open-source database.

What Is PostgreSQL? How It Works, Use Cases, and Resources

https://www.datacamp.com/blog/what-is-postgresql-introduction

Jul 3, 2024 · PostgreSQL is an open-source object-relational database management system that combines the power of relational databases with the flexibility of object-oriented programming.

PostgreSQL Explained: A Complete Beginner-to-Advanced Guide

https://www.digitalocean.com/community/conceptual-articles/comprehensive-guide-postgresql

Apr 15, 2026 · A guide to PostgreSQL covering its architecture, features, installation, queries, indexing, and performance optimization for beginners and professionals.