Medium

Alexander Obregon

Pinned

Alexander Obregon

·

Dec 22, 2023

About Me

Hello, I’m Alexander Obregon, a 29-year-old who’s passionate about code and software development. I’m living in the U.S. now, but a lot of…

About Me

Alexander Obregon

·

Nov 5

Hashing Data with SQL Functions

Comparing large amounts of data can get complicated when records contain lengthy text, multiple columns, or information that changes…

Hashing Data with SQL Functions

Alexander Obregon

·

Nov 2

How to Call REST APIs with RestClient in Spring Boot 4

Calling external REST APIs allows a Spring Boot application to retrieve information, submit data, and communicate with other services over…

How to Call REST APIs with RestClient in Spring Boot 4

Alexander Obregon

·

Oct 30

Sampling Rows with SQL Queries

Large database tables can contain millions of records, but we don’t always need to retrieve every row to inspect data, test queries, or…

Sampling Rows with SQL Queries

Alexander Obregon

·

Oct 28

How to Manage Transactions in Spring Boot 4

Database operations can involve several steps within the same service method, from creating a new record to updating existing data through…

How to Manage Transactions in Spring Boot 4

Alexander Obregon

·

Oct 23

Unpivot Data with SQL Server

In my last SQL article, we went over Pivot Queries in SQL Server, where we turned row values into columns to summarize data. Now we’re…

Unpivot Data with SQL Server

Alexander Obregon

·

Oct 21

How to Manage Spring Boot 4 Profiles for Different Environments

As a Spring Boot application moves through development, testing, staging, and production, its configuration usually needs to change along…

How to Manage Spring Boot 4 Profiles for Different Environments

Alexander Obregon

·

Oct 16

Pivot Queries with SQL Server

Sales tables usually store each transaction on its own row, with details such as the region, sales channel, and amount recorded in columns…

Pivot Queries with SQL Server

Alexander Obregon

·

Oct 15

How to Handle File Uploads in Spring Boot

File uploads begin with MultipartFile, though handling them well goes past accepting bytes from an HTTP request. We need to set size limits…

How to Handle File Uploads in Spring Boot

Alexander Obregon

·

Oct 8

Deduplication with SQL Window Functions

SQL data can pick up duplicate rows through repeated imports, retry logic, merged datasets, or several records that refer to the same…

Deduplication with SQL Window Functions

Alexander Obregon

Alexander Obregon

I post daily about programming topics and share what I learn as I go. For recaps, exclusive content, and to support me: https://alexanderobregon.substack.com

Following

Help

Status

About

Careers

Press

Blog

Store

Privacy

Rules

Terms

Text to speech