Databases Resources

Fix Circular Dependencies in PostgreSQL Row-Level Security With SECURITY DEFINER Functions

Circular RLS policy dependencies in PostgreSQL silently return no rows. Here is why it happens and how SECURITY DEFINER functions fix it.

July 20, 2026

by Lex Mulier

· 2,082 Views

Mitigating Cache Stampedes in Dynamic API Translation Using Java 21 Virtual Threads

Building a dynamic API translation proxy that leverages Java 21 Virtual Threads and Redisson distributed locking to safely execute AI-driven schema mapping.

July 17, 2026

by Aniruddha Chatterjee

· 3,424 Views · 3 Likes

Seeding Postgres When Your Schema Has Foreign-Key Cycles

Three strategies for seeding Postgres schemas with foreign-key cycles: nullable two-pass, DEFERRABLE constraints, and schema-aware generators.

July 17, 2026

by Mikhail Shytsko

· 2,910 Views · 3 Likes

Designing Scalable Containerized Backend Services

Learn to build high-concurrency relational microservices using Python and Docker, focusing on async connection pooling and state management.

July 17, 2026

by Estefanio Fernando

· 2,381 Views · 1 Like

Going Stateless: Scaling MCP Servers to Cloud-Native Java and HTTP

The Model Context Protocol has evolved to be entirely stateless over HTTP, removing complex session bottlenecks. Pairing this update with cloud-native Java, Quarkus!

July 16, 2026

by Daniel Oh

CORE

· 4,598 Views · 2 Likes

Cloud Cost Optimization Was Hard; AI Cost Optimization Will Be Worse.

Cloud cost optimization was hard because cloud made infrastructure consumption easy; AI cost optimization will be worse because AI makes decision consumption easy.

July 15, 2026

by Raghava Dittakavi

CORE

· 4,435 Views · 3 Likes

Jakarta NoSQL 1.1: Advancing Polyglot Persistence for Jakarta EE 12

Jakarta NoSQL 1.1 brings Jakarta Query integration, projections, fluent updates, and automatic converters, strengthening polyglot persistence in Jakarta EE 12.

July 15, 2026

by Otavio Santana

CORE

· 3,212 Views · 1 Like

How to Build a Brand Monitoring Dashboard With SerpApi and Python

Track your brand across Google News, YouTube, and online discussions in a single Python dashboard with data from SerpApi.

July 14, 2026

by Tomas Murua

· 3,139 Views · 1 Like

12 Factor Framework for Building Secure and Compliant Cloud Applications

Learn how a practical 12-factor framework embeds security, compliance, resilience, and governance into cloud-native applications.

July 14, 2026

by Josephine Eskaline Joyce

CORE

· 2,870 Views · 3 Likes

GraphRAG in Practice Using Spring AI, Neo4j, and Goodreads Data

Building a GraphRAG application with Spring AI and Neo4j, covering data modeling, Cypher-based data loading, vector search, and key gotchas.

July 14, 2026

by Akmal Chaudhri

CORE

· 5,095 Views · 3 Likes

AWS Glue ETL Design Principles for Production PySpark Pipelines

Learn eight AWS Glue ETL design principles for building production PySpark pipelines that are maintainable, scalable, observable, and cost-efficient.

July 14, 2026

by Janani Annur Thiruvengadam

CORE

· 3,324 Views · 2 Likes

From Gherkin to Source Code Without Losing the Business Language

Instead of hiding business rules inside technical layers, I'll show how to keep them visible and explicit in the code. The code reads like the original Gherkin scenario.

July 14, 2026

by Douglas Cardoso

· 3,185 Views · 1 Like

API Facade vs. Orchestration vs. Eventing, Now With AI in the Loop

Discover architectural patterns for integrating AI into enterprise systems without sacrificing governance, reliability, observability, or loose coupling.

July 13, 2026

by Jubin Soni, FBCS

CORE

· 2,766 Views · 1 Like

Machine Identity Debt: Why Human Identity Is No Longer Cloud Security's Primary Boundary

Machine identities now outnumber human ones in cloud environments. Learn how to secure workloads with modern identity governance and trust.

July 13, 2026

by Igboanugo David Ugochukwu

CORE

· 6,389 Views · 1 Like

Database Normalization, ACID Properties, and SCDs: A Comprehensive Guide

Master database normalization, ACID properties, and Slowly Changing Dimensions (Types 0–3) with practical examples and performance best practices.

July 10, 2026

by arvind toorpu

CORE

· 2,714 Views · 4 Likes

Replacing Direct Storage URLs With a Media Proxy at Scale

Direct storage URLs broke under production constraints, so I replaced them with a UUID-based media proxy for auth, thumbnails, bulk downloads, and storage abstraction.

July 10, 2026

by Deepak Gupta

· 1,293 Views · 1 Like

Top 10 Best Places to Prepare for Your Next Data Engineer Interview

Candidates must demonstrate strong SQL, Python, data modeling, ETL, Spark, data warehousing, and system design expertise while solving real-world data challenges.

July 10, 2026

by Rahul Han

· 1,948 Views · 1 Like

Azure Databricks vs Microsoft Fabric: An Honest Guide to When to Use What

Azure Databricks and Microsoft Fabric overlap, but they're built for different priorities. Databricks for data engineering, ML, open-source, and Spark workloads.

July 9, 2026

by Jubin Soni, FBCS

CORE

· 1,872 Views

A Step-by-Step Guide to Implementing Columnar Tables in SQL Server

SQL Server columnar storage organizes data by columns instead of rows, delivering faster queries, better compression, and efficient analytics.

July 7, 2026

by arvind toorpu

CORE

· 2,578 Views · 1 Like

HTTP QUERY in Java: The Missing Method for Complex REST API Searches

HTTP QUERY gives Java REST APIs a cleaner way to handle complex searches with request bodies, avoiding long URLs and POST misuse while keeping reads explicit.

July 6, 2026

by Otavio Santana

CORE

· 2,172 Views

The Latest Databases Topics