Latest Updates

Documenting code, one commit at a time.

Enhancing Data Visualization in Filament with PostgreSQL Functions

Introduction

This post explores how the Reimpact/platform project enhanced its Filament-based dashboard by leveraging PostgreSQL functions to improve data visualization. The focus was on creating a more insightful and efficient packaging dashboard.

From MySQL to PostgreSQL: A Performance Shift

The initial implementation relied on MySQL stored procedures. To optimize performance and

Read more
PHP Service Layer

Improving Component Management and Data Handling in Platform

The Reimpact/platform project focuses on building a robust and scalable platform. Recent work has concentrated on improving component management and ensuring data integrity across different modules. These changes streamline the codebase and address potential errors in data handling.

Fixing Data Type Handling

A critical fix addressed an issue in channels.php related to UUID comparison.

Read more

Enhancing Data Synchronization in the Reimpact Platform

This post details recent improvements to the data synchronization process within the Reimpact platform, focusing on dependency management, data integrity, and automation.

The Challenge

Data synchronization can be complex, especially when dealing with relational databases that have foreign key constraints and auto-generated values. Ensuring data consistency and avoiding errors during

Read more

Scaling with Schemas: Multi-Tenancy Migration in Laravel

The Reimpact platform is undergoing a significant architectural shift, moving from a MySQL row-level multi-tenancy model to a more robust PostgreSQL schema-per-tenant setup. This post dives into the key considerations and steps involved in this migration, leveraging Laravel and Filament.

The Motivation for Schema-Based Tenancy

Row-level multi-tenancy in MySQL, while initially simpler to

Read more

Multi-Tenancy with PostgreSQL Schemas in Laravel

Introduction

When building multi-tenant applications, choosing the right architecture is critical. This post explores how to leverage PostgreSQL schemas within a Laravel application to achieve tenant isolation, enhance security, and improve scalability.

The Multi-Tenant Challenge

Traditional multi-tenant approaches often involve sharing a single database and distinguishing tenants by a

Read more
PHP Service Layer

Navigating Merge Conflicts in Collaborative Projects

When working on collaborative projects like the landing page project, merge conflicts are almost inevitable. Understanding how to resolve them effectively is crucial for maintaining a smooth workflow.

Understanding Merge Conflicts

Merge conflicts arise when multiple developers modify the same lines of a file or when one developer modifies a file while another deletes it.

Read more