Browsing Tag
postgres
66 posts
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…
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 /…
