Latest Updates

Documenting code, one commit at a time.

PHP Laravel

Streamlining Filament Panel Navigation in Reimpact Platform

Introduction

The Reimpact platform recently underwent a navigation update to improve user experience within the Filament admin panel. This update focused on ensuring consistent and correct redirection after login and impersonation actions.

The Problem

Previously, users logging in or utilizing the impersonate feature were being redirected to outdated Nova paths, specifically

Read more

PostgreSQL Type Casting for Data Consistency in Laravel

When developing applications using Laravel with a PostgreSQL database, maintaining strict data type consistency is crucial, especially when dealing with dashboard functionalities that aggregate data. PostgreSQL's strong type checking can lead to unexpected errors if data types don't match exactly between the database schema and the application's expectations.

The Problem: Type Mismatches

Read more

Refactoring Filament Dashboard Filters for Clarity and Efficiency

The Reimpact platform benefits from a well-organized and efficient admin dashboard. Recently, work has focused on refining the Packaging dashboard's filter system to improve both its appearance and initial data loading performance.

The Problem: Styling Inconsistencies and Delayed Data

Previously, the dashboard filters suffered from inconsistent styling, making the interface feel disjointed.

Read more

Database Compatibility: Adapting Queries for PostgreSQL

When developing applications across different database systems, ensuring compatibility in your queries is crucial. Minor differences in SQL syntax can lead to unexpected errors and application downtime. Let's explore a practical example of adapting queries for PostgreSQL.

The Challenge: Date Extraction

MySQL provides functions like YEAR() and MONTH() to extract year and month values from

Read more
PHP Laravel

Handling Database Seed Conflicts in Laravel

Introduction

When working on the Reimpact platform, a common issue arises during database seeding: conflicting UUIDs, especially when dealing with priority products. This post details how to resolve such conflicts, ensuring smooth database setup and consistent application behavior.

The Problem: Duplicate Entries

During the database seeding process, the system attempts to insert a new

Read more
PHP Laravel

Seeding Sanity: Ensuring Data Integrity in Laravel Migrations

When working on the Reimpact/platform, we encountered an issue where seeding migrations were failing due to missing prerequisite data. This post outlines the problem and the solution implemented to ensure data integrity during migrations.

The Problem

Our Laravel application relies on a seeding process to populate the database with initial data. One particular migration was attempting to

Read more

Ensuring Data Integrity: A Migration Story

Imagine deploying a new feature only to find that a critical piece of data is missing, causing unexpected errors. This is the story of how a small, seemingly insignificant migration change prevented a larger issue in a Laravel project called platform.

The Problem

During a recent update, it was discovered that a database row, specifically the priority_product entry, was not consistently

Read more

Tenant Isolation Strategy: Global Rates in a Multi-Tenant Laravel Application

Introduction

In multi-tenant applications, data isolation is key. One common challenge is determining which data should be tenant-specific and which should be global. In our Laravel platform project, we faced this question with application rates. Initially, we considered rates to be tenant-scoped, but we discovered that, due to regulatory requirements, these rates are actually global and

Read more
PHP Laravel

Tackling QueryExceptions: Ensuring Data Integrity in Laravel Applications

When developing applications with Laravel, maintaining database schema consistency across different environments is crucial. In the Reimpact/platform project, a recent issue highlighted the importance of this practice. The project involves managing various data points, and a discrepancy arose when a column present in one database schema was missing in another.

The Problem: Missing Column

Read more