Introduction

Managing costs associated with AI-powered features, such as text, image, and video generation, can be complex. Our platform needed a unified system to convert these costs into credits, manage profit margins, and track consumption effectively.

The Challenge

Previously, our credit system lacked a standardized approach. Calculating costs for various AI services (text, image,

When working on Breniapp, it's tempting to streamline processes with automated functions. However, over-automation can sometimes lead to unintended consequences, especially when user preferences are involved.

The Pitfalls of Over-Automation

Automated processes are great for efficiency, but they can become problematic if they override user-defined settings.

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

When refactoring database schemas, developers often encounter challenges with primary and foreign key relationships. In the Reimpact platform, a recent update focused on modifying a primary key (priority_product ID) while ensuring existing foreign key references remained valid. This process highlights the importance of managing dependencies during schema alterations.

The Problem

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

The landing project focuses on creating engaging user experiences. Recent work has concentrated on refining data storage and ensuring application stability.

Addressing PostgreSQL DISTINCT Errors with JSONB

A recurring issue involved PostgreSQL's inability to efficiently use DISTINCT with JSON columns. This manifested as numerous daily errors, particularly within the Campaign editor's

Introduction

When working with database migrations and seeders in Laravel, particularly with PostgreSQL, developers sometimes encounter issues related to SQL parsing. One such issue arises when attempting to seed data into a table that already exists but is missing a specific column.

Introduction

The Reimpact platform is undergoing continuous improvements to enhance its data model and overall efficiency. One recent focus has been on refining relationships between models to ensure data integrity and reduce redundancy.

The Challenge

In a recent update, a specific issue was identified within the LatestMassiveUploadsWidget. The MassiveUpload model, designed for

Introduction

When performing database migrations, especially in multi-tenant environments, it's crucial to ensure all aspects of the schema are correctly applied to each tenant. This post explores a scenario in a Laravel application where PostgreSQL functions were unintentionally dropped during a tenant migration and how they were recovered.

The Problem: Silently Missing Functions