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/

1 day ago · PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that …

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 …

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 …

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 …

Introduction to PostgreSQL - GeeksforGeeks

https://www.geeksforgeeks.org/postgresql/introduction-to-postgresql/

Jul 6, 2026 · PostgreSQL is an open-source relational database management system (RDBMS) that stores and manages data in …

PostgreSQL Tutorial

https://www.pgtutorial.com/

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

PostgreSQL Tutorial - GeeksforGeeks

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

Jul 10, 2026 · PostgreSQL is a free and open-source database management system used to store, organize and manage data …

pgAdmin - PostgreSQL Tools

https://www.pgadmin.org/

pgadmin 4 · v9.17 The PostgreSQL management tool Administration, development and monitoring for PostgreSQL. Desktop or server …

Download PostgreSQL (free) for Windows, macOS and Linux | Gizmodo

https://gizmodo.com/download/postgresql

Aug 13, 2026 · PostgreSQL is an open source, database system known for its reliability, feature set, and performance. It's a great …

GitHub - postgres/postgres: Mirror of the official PostgreSQL GIT ...

https://github.com/postgres/postgres

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, …