Latest Updates

Documenting code, one commit at a time.

PHP Java MySQL

Tenant-Centric Quota Management with Manual Overrides

Managing resource quotas across multiple tenants can be challenging, especially when the need for manual overrides arises. This post explores how we refactored our token usage service to implement a tenant-centric quota system with support for manual adjustments.

The Challenge

Previously, our token quota management was user-based. This created inefficiencies when the context already provided

Read more

Optimizing Application Performance Through Targeted Database and Code Improvements

Introduction

Application performance is often a critical factor in user experience and overall system efficiency. This post delves into several strategies for enhancing performance, focusing on database query optimization, efficient data handling, and code-level improvements.

Database Query Optimization

Inefficient database queries can be a major bottleneck. One common issue is the N+1

Read more

Enhancing Subscription Recognition in Billing Systems

Introduction

This post addresses an issue where a billing system, specifically when using a service like Cashier, fails to correctly identify active subscriptions beyond the default type. We'll explore the problem and provide a solution to ensure all subscription types are properly recognized.

The Problem: Default Subscription Type Bias

In many billing systems, especially those utilizing

Read more
PHP Laravel MySQL

Fixing Type Errors in Subscription Models

When working with custom models that extend core framework functionalities, it's crucial to maintain type compatibility. A recent fix in our application addressed a TypeError that arose from an incorrect extension of the Subscription model.

The Problem: Type Hint Mismatch

The custom Subscription model was initially set up to extend Eloquent's Model directly.

Read more

Improving Data Accuracy with Enhanced API Integration

Introduction

This post details an enhancement to our application's data aggregation process. We addressed an issue where total counts were inaccurate by switching from a local database to an external API for data retrieval, ensuring more reliable results.

The Problem: Data Discrepancies

Previously, our application relied on a local database table, populated with data from an events API,

Read more

Improving Database Transaction Handling in Tests

Introduction

During recent testing of the social login functionality in our application, we encountered intermittent failures. These "flaky" tests were traced back to how database transactions were being handled, particularly in PostgreSQL.

The Challenge

The core issue was that within a test, a failed database query (e.g., due to a validation error during profile synchronization) would

Read more