Browsing Tag
postgres
69 posts
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…
Building Secure Session-Based Authentication in NestJS – Part 1
Introduction Session-based authentication is everywhere — yet many developers use it daily without fully understanding how it actually…
Brex Database Disaster Recovery
Speaker: Fabiano Honorato, Michelle Koo, Stephen Brandon @ AWS FSI Meetup 2025 Q4 Introduction to Brex Financial operating…
