Introduction

When building multi-tenant applications with Laravel, managing database schemas for each tenant can become complex. We recently improved our tenant schema population process in the platform project to handle various edge cases and ensure data integrity across companies.

The Problem

Our initial schema population process had several limitations:

1. PostgreSQL's

When working on the Reimpact platform, a key aspect is ensuring data accuracy and efficiency. Recently, we addressed an issue within the generated reports functionality. The goal was to streamline data processing and eliminate redundant calculations, resulting in a more efficient system.

Identifying the Issue

The initial analysis revealed that certain data points within the generated reports

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

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.

Introduction

When bootstrapping a new environment for the Reimpact platform, it's often necessary to populate the database with initial data. This post details how we approached seeding rate data from a production MySQL dump into a new PostgreSQL instance, focusing on an idempotent migration strategy.

The Challenge

We needed to migrate 448 rows of rate data from an existing MySQL

Introduction

The Reimpact platform is undergoing improvements in how it manages tenant schemas and streamlines database refreshing. These changes aim to improve data consistency, developer experience, and overall system maintainability.

Tenant Schema Updates

Several updates have been made to how tenant schemas are populated and managed:

• Purchase Data Mapping: Added a mapping for

The Reimpact platform is focused on streamlining various business processes. Recent updates enhance the platform's interaction with databases, specifically focusing on user notifications and improved error handling for foreign key violations in both MySQL and PostgreSQL.

Database Notifications

A key improvement involves enabling database notifications within Filament panels.

Introduction

When building multi-tenant applications with Laravel, ensuring proper tenant context and efficient file handling are critical. Recent updates to the Reimpact platform focus on improving these aspects, streamlining tenant schema management and simplifying large file uploads.

Tenant Schema Isolation Improvements

Proper tenant schema isolation is essential for maintaining data