Browsing Tag
postgres
71 posts
1.4.10 Planner Hook: When It Fires, How to Use It
Everything from 1.4.1 through 1.4.9 happened inside a single function, standard_planner(). Building paths, costing them, searching for a…
PostgreSQL 22036 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22036: non numeric sql json item PostgreSQL error code 22036 (non numeric sql json item) occurs…
PostgreSQL 22027 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22027: Trim Error — Causes, Fixes, and Prevention PostgreSQL error code 22027 (trim_error) occurs when the…
RUM—Storing More in the Index
This series of posts traces the evolution from GIN to RUM to Extended RUM, showing how a single…
Debugging PostgreSQL Performance
Let’s chat about performance, optimization, and debugging a PostgreSQL database. Can you read EXPLAIN ANALYZE output fluently? Do…
Alter Queries
In this assignment, I worked on modifying existing tables using ALTER TABLE. This helped me understand how to…
How I Structured User Data for My AI SaaS
Most developers building their first SaaS make the same mistake I almost made — they reach for sessionStorage…
SQL Joins & Window Functions
JOINS They allow us to work with multiple tables and allows us to join data in different tables.…
Understanding Joins and Window Functions in SQL
Introduction In this article, we will explore two of the most powerful and widely used features in SQL:…
“Adeus ‘funciona na minha máquina’: Spring Boot com PostgreSQL usando Docker”
Introdução Quando comecei a estudar containerização de aplicações Java, uma coisa ficou muito clara: o maior ganho não…