;
;

DZone Databases Zone

Recent posts in Databases on DZone.com

Databricks Lakebase: Give Your Agent a Branch, Not Your Production Database

There's an awkward moment in every agentic data project. The agent works. It writes decent SQL, it reasons about schema, it proposes a migration th...
Posted on 8 September 2026 | 3:00 pm

Prevent Duplicate API Calls With Idempotency: Patterns That Work

A failure pattern I have seen repeatedly in enterprise integrations: a payment request times out at the caller, succeeds downstream, and is then re...
Posted on 8 September 2026 | 1:00 pm

Handling Large API Responses Without Freezing the Client: A Practical Architecture With Temporal, Kafka, and RAG

A large API response becomes a client problem long before it becomes a network problem. A browser can receive hundreds of megabytes and still becom...
Posted on 4 September 2026 | 5:00 pm

Your Spark Job Isn't Slow Because of Bad Code. It's Slow Because of the Wrong Join

I learned this lesson the hard way. We had a critical data pipeline running for over 3 hours every single day. The logic was perfectly clean. The o...
Posted on 3 September 2026 | 3:00 pm

Building a Python API Client That Doesn’t Fall Apart When the API Misbehaves

The first version of almost every API client I write looks embarrassingly simple. Send a request. Parse the JSON. Return the result.
Posted on 3 September 2026 | 2:00 pm

Extracting Entities and Relationships From Engineering Documents With spaCy

Engineering teams generate a lot of useful knowledge, but most of it is locked inside text. A service ownership note may tell you who owns an appli...
Posted on 2 September 2026 | 6:00 pm

3D Air Quality Maps With Neo4j, Python, and R

Air quality across the Pyrenees corridor is a pressing concern, particularly during summer heatwaves and wildfire seasons. In this region, cities o...
Posted on 2 September 2026 | 1:00 pm

Stop Hardcoding Database Checks: Building a Metadata-Driven Data Quality Framework

In high-volume data platforms, hardcoding validation logic into individual processing pipelines creates significant operational drag. As an enterpr...
Posted on 1 September 2026 | 3:00 pm

How to Detect AI-Generated Images in C# Using an API

When someone uploads an image to your application, it might look perfectly fine at first glance. It might open correctly, pass file validation, and...
Posted on 1 September 2026 | 2:00 pm

Natural IDs in Your Database. I Am Telling You for the Last Time!

Hi everyone! This is Mikhail Polivakha, tech lead of the Axelix project (btw, give us a star!). In my experience consulting teams that build enterp...
Posted on 31 August 2026 | 6:00 pm

Securing Database Connections With Mutual TLS

Stolen credentials served as the entry point in 22% of breaches last year, and in attacks on basic web applications that figure climbs to 88%. Thos...
Posted on 31 August 2026 | 5:00 pm

How I Built a SQL Diagnostic Tool That Works Without Touching Your Database

Most developers I've worked with write SQL every day. Very few of them are DBAs. According to the 2024 Stack Overflow Developer Survey — 65,000 dev...
Posted on 31 August 2026 | 3:00 pm

Deliberate Decoupling: 6 Architectural Patterns From a Regulated WAS-to-AWS Migration

Key Takeaways In regulated industries, cloud migration success is determined less by technology selection and more by how deliberately you decoup...
Posted on 28 August 2026 | 4:00 pm

When Guest Access Becomes an Attack Surface: A Technical Analysis of the City-Forum Campaign

Learn how attackers enumerated Salesforce Experience Cloud and ServiceNow portals — and how defenders can detect and prevent the same abuse. When G...
Posted on 27 August 2026 | 4:00 pm

Running Sentiment Analysis Inside Neo4j With a Java Plugin

In a chapter of The SingleStore Cookbook, there is a complete sentiment analysis pipeline using Rust compiled to WebAssembly and loaded directly in...
Posted on 27 August 2026 | 2:00 pm

Designing Rayfall: One Expression Language for a Columnar Database

Columnar engines naturally organize computation around vectors to make effective use of single instruction, multiple data (SIMD) instructions. This...
Posted on 25 August 2026 | 5:00 pm

Tail-Based Sampling in the OpenTelemetry Collector: Keeping the Traces That Matter

Head-based sampling makes a decision the instant a trace starts, before anyone knows whether that trace is boring or the one you will spend Friday ...
Posted on 25 August 2026 | 4:00 pm

Multi-Account AWS Architecture: Isolating PHI Workloads Without Slowing Down Engineering Teams

Most engineering teams working on healthtech applications reach a point where someone asks a question that sounds simple but isn't: How do we make ...
Posted on 24 August 2026 | 7:00 pm

From Chat Completions to Responses: Why Is OpenAI Upgrading Its Core API?

This article was originally published on my blog. For the latest version and future updates, please visit the original post: https://jaketao.com/la...
Posted on 24 August 2026 | 1:00 pm

How to Secure Fintech REST APIs Against BOLA Vulnerabilities

Broken Object Level Authorization (BOLA) occurs when a REST API exposes an object identifier—such as an account, transaction, or loan ID — without ...
Posted on 24 August 2026 | 12:00 pm