News
Stop Hacking SQL: How to Build a Scalable Query Automation System
This article explains how to replace ad-hoc SQL jobs with a small, spec-driven system.It outlines the common failure modes (UI-on...
Spring Boot Audit Logs: Capture Every API Action Without Writing Boilerplate Cod...
This guide shows how to build an automated audit logging system in Spring Boot using AOP and JPA, enabling seamless tracking of ev...
Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunk...
The "bad" correlated subquery outperformed the "good" JOIN. The subquery triggered a Nested Loop plan with fast index lookups (25...
Storing JSON and XML in SQL Databases: An Essential Guide
In the era of big data and diverse data formats, the ability to store and query semi-structured data has become increasingly impor...
Introducing Agentic Postgres, the Database for AI Agents
Tiger is launching a new database for agents. Agentic Postgres is the first database designed from the ground up for Agents. It in...
Batch Inference Made Simple: Using Databricks Serverless Model Serving and AI Fu...
By transforming batch inference into a simple SQL function, we transform what was once a complex engineering tasks requiring Pytho...
To Sp or Not To Sp
Code that looks harmless can often lead to negative consequences. Let's dive into how a simple data copy with Entity Framework Cor...
Choosing Between SQL and NoSQL—Before the Wrong One Chooses You
Choosing the right database is one of the most important decisions you’ll make when designing a data-driven application. Both have...
