Latest Updates

Documenting code, one commit at a time.

Implementing Rate Limiting for AutoSync Jobs

Introduction

Our application relies on the AutoSyncGeneratePostJob to synchronize data. Recently, we encountered issues with exceeding the rate limits imposed by Azure, leading to job failures and data inconsistencies. To address this, we implemented rate-limiting middleware specifically for this job.

The Problem

The AutoSyncGeneratePostJob frequently triggered requests to Azure services.

Read more

Handling Video Playback Compatibility in Web Applications

Introduction

Ensuring video playback across different browsers can be a tricky endeavor. Modern web applications often face challenges related to codec support and browser compatibility. This post will explore a common issue related to video format support and a pragmatic approach to resolving it.

The Problem: Inconsistent Codec Support

Different browsers support different video codecs.

Read more

Optimizing Product Ranking and Data Aggregation in SQL

Introduction

This post delves into optimizing SQL queries for product ranking and data aggregation, focusing on common pitfalls and effective strategies to enhance performance and accuracy. We'll explore techniques to address memory errors, improve query speed, and ensure data integrity when dealing with complex relationships and large datasets.

Addressing Memory Errors in Ranking

Read more

Implementing Localized Promo Videos for Global Audiences

The Challenge

Our application needed to support multiple languages for promo videos, ensuring a localized experience for users across different regions. This included translating video content and optimizing video formats for efficient delivery.

The Solution

We implemented a solution involving content localization, component updates for internationalization (i18n), and video format

Read more

Dependency Update: Lodash to v4.17.23

Introduction

This post details a recent dependency update to Lodash within the platform. Lodash is a utility library providing helpful functions for working with arrays, objects, strings, and numbers. Keeping dependencies up-to-date is crucial for maintaining security, performance, and compatibility.

The Update

The platform's Lodash dependency has been bumped from version 4.17.21 to 4.17.

Read more

Standardizing Video Output to MP4

Introduction

Our team has been working on streamlining the video rendering process for our landing page promos. This update focuses on simplifying the output format to a single standard: MP4.

The Change

The previous setup involved generating both MP4 and WebM formats for different browsers and devices. This required maintaining separate rendering configurations and increased storage

Read more

Optimizing Auto-Sync Frequency for Enhanced Responsiveness

Introduction

We recently adjusted the frequency of our automated synchronization process to improve system responsiveness and data consistency. This post details the change and the reasoning behind it.

The Change

The auto-sync schedule was updated from running hourly to every minute. This adjustment aims to provide near real-time updates for critical data.

Schedule::command('posts
Read more