Introduction

Row-level filtering is common for multi-tenancy, but what if you need stronger isolation? At Reimpact's platform, we're migrating towards PostgreSQL schemas to achieve true tenant separation, leveraging Laravel, Filament, and the middleware pattern.

This post details our approach to dynamically setting the PostgreSQL search_path for each tenant, ensuring data isolation and

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

Introduction

When developing dashboards that rely on precise data comparisons in PostgreSQL, case sensitivity can be a silent but critical issue. This post examines a case in the Reimpact platform where case sensitivity in unit comparisons caused dashboard calculations to return incorrect results, and how it was resolved.

The Problem: Case-Sensitive Comparisons

PostgreSQL, by default,

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

Sometimes, the most effective UI changes are the ones that make things less noticeable. Consider a 'reset chat' button. Initially, it might seem intuitive to style it with a prominent color like red, signaling a potentially destructive action. However, in practice, this can create unnecessary visual noise and even user anxiety.

The Problem with Red

Red is often associated with errors,

This post explores the recent efforts to unify the visual style of chat components within the Breniapp/brenia project, focusing on creating a consistent onboarding experience for users.

The Goal

The primary objective was to standardize the look and feel of various chat components, including Brand Assistant, Brand Section, Skeleton Section, and QA chats.

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

Introduction

Recently, users of the Reimpact platform experienced instability in their dashboards. This was due to a combination of data inconsistencies and error handling issues. Specifically, missing data in the public.rates table and unhandled PostgreSQL errors were causing Livewire components to crash, impacting the entire dashboard experience.

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

Introduction

In the Breniapp project, we've recently refactored the credit settings page to simplify the user interface and improve maintainability. The primary goal was to remove redundant configuration options and consolidate credit management under a more centralized approach.

The Old Approach: Redundancy and Confusion

Previously, the credit settings page exposed pack_size and