Latest Updates

Documenting code, one commit at a time.

MySQL UI 10 posts
×
PHP UX UI

Enhancing User Profiles: Increasing Highlight Capacity in Landing

This post details a recent update to the landing project, focusing on improving user profile customization.

The Feature: Expanded Profile Highlights

We've increased the maximum number of profile highlights users can showcase, expanding it from 8 to 12. This provides users with greater flexibility in presenting key aspects of their professional or personal brand.

The Rationale

Read more
PHP UI admin

Improving Admin UI with Collapsed Actions in Brenia

Introduction

The Brenia project is focused on providing streamlined administrative interfaces. A key goal is to make these interfaces more efficient and less visually cluttered. This post details the effort to consolidate less frequently used admin actions into a more compact menu, while ensuring critical actions remain easily accessible.

The Problem

The original admin interface had

Read more

Improving Data Synchronization in Platform: Addressing Foreign Key Constraints and Memory Usage

Introduction

The Reimpact/platform project encountered challenges during data synchronization, specifically with foreign key constraints and memory exhaustion issues. This post outlines the problem, the solution implemented, and key takeaways for managing large-scale data transfers.

The Challenge

During the synchronization of a large dataset (1.45M rows) from a production MySQL database

Read more

Improving Database Compatibility and Code Maintainability in Laravel Projects

Introduction

Maintaining compatibility across different database systems and ensuring code consistency can be challenging in large Laravel projects. This post outlines how the Reimpact/platform project addressed these issues, specifically focusing on PostgreSQL compatibility and tenant table management.

The Challenge

When developing applications that need to support multiple database

Read more

Refactoring Database Schemas for Module-Specific Tables

We've been working on the Reimpact/platform project, and recently tackled a significant refactoring of our database schema. Our initial design had a mix of shared and module-specific tables within each tenant schema, which led to some challenges as the platform grew.

The primary goal of this refactoring was to improve modularity and maintainability by clearly separating module-specific data.

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

Navigating the Data Migration Maze: MySQL to PostgreSQL

Migrating data between different database systems can be a complex undertaking. Recently, the team working on the platform navigated a significant data migration from MySQL to PostgreSQL. This post outlines some key considerations and challenges encountered during the process. These insights can help you avoid common pitfalls when undertaking similar migrations.

The Challenge

Read more

Enhancing User Experience with Dynamic Plan Rendering and Configurable Credits in Breniapp

Introduction

In the development of Breniapp, a key focus is delivering a seamless and intuitive user experience. Recent enhancements concentrate on improving how users interact with subscription plans and purchase additional credits.

Dynamic Plan Rendering

Previously, the display of available subscription plans in the upgrade modal was static, leading to potential inconsistencies and

Read more
PHP MySQL AWS

Streamlining Local Development with Dynamic MySQL Configuration

Setting up a local development environment can often be a hurdle, especially when dealing with database credentials. Manually managing these credentials and ensuring they match the production environment can be time-consuming and error-prone. This is especially true for the Reimpact platform, where consistency between development and production environments is crucial.

The Problem: Hardcoded

Read more