Browsing Tag
postgres
63 posts
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…
MongoDB Index Intersection (and PostgreSQL Bitmap Scan)
You won’t always have a perfect index for every query, but may have have single-field indexes for each…
Can we use Rust to Develop Extensions for PostgreSQL?
Although it has been a while since the event, I am sharing the full transcript of my talk…
🧱 Lesson 5 – Working with PostgreSQL (Multi-Database Setup)
Series: From Code to Cloud: Building a Production-Ready .NET Application By: Farrukh Rehman - Senior .NET Full Stack Developer /…
FastAPI & PostgreSQL Sharding: A Step-by-Step Guide (Part 2) – Step-by-Step Implementation
This is a continuation of my series of articles about horizontal scaling of databases. In the first part,…
How to Design a PostgreSQL Schema Visually (Step-by-Step)
1. What is a Schema? In PostgreSQL, a schema is just a folder inside your database where you…
Postgres is Too Good (And Why That’s Actually a Problem)
We need to talk about something that’s been bothering me for months. I’ve been watching indie hackers and…
