Introduction

This post details the process of seeding initial data, specifically post examples, for tenant-specific features in our application. This approach allows for features like auto-generated posts or random content display that is tailored to each tenant.

The Need for Seed Data

When building multi-tenant applications, providing default or example data for each tenant can greatly

Sometimes, the core functionality of a framework needs a little customization to perfectly fit the nuances of a specific application. Recently, we faced a situation where we needed to extend our Tenant model to directly handle subscription checks, which required overriding some core Cashier methods.

The Challenge

Our application uses a multi-tenant architecture. Each tenant needs to manage

Introduction

This post delves into optimizing SQL queries for product ranking and data aggregation, focusing on common pitfalls and effective strategies to enhance performance and accuracy. We'll explore techniques to address memory errors, improve query speed, and ensure data integrity when dealing with complex relationships and large datasets.

Addressing Memory Errors in Ranking

Introduction

This article outlines an approach to enhance the resilience of data processing components when interacting with database tables, specifically addressing scenarios where tables might be temporarily unavailable or not yet provisioned in certain environments.

The Challenge

In dynamic environments, data processing tasks sometimes encounter situations where expected database

Implementing full-text search can significantly enhance the user experience of your portfolio or blog. This post details how to add PostgreSQL-powered full-text search to a Laravel application, focusing on accent-insensitive prefix searching across multiple fields.

The Problem: Basic Search Limitations

Simple LIKE queries in SQL often fall short when dealing with complex search

When integrating with GitHub, users sometimes encounter issues when updating the granted permissions (scopes). A recent update addresses a scenario where these updates would silently fail, leaving users confused.

The Problem

When a user attempted to update their GitHub scope (e.g., from public-only access to all repositories) via the integrations page, a failure in the Socialite OAuth

Overview

Recent development activity focused on code style consistency and updates to the database schema.

Code Formatting

Applied automated formatting fixes using php-cs-fixer. This ensures consistent code style across the project, improving readability and maintainability. The tool automatically adjusts spacing, indentation, and other stylistic elements according to predefined rules.

Introduction

The application's dashboard was experiencing crashes for tenants that had not yet run the commits migration. This post details the solution implemented to gracefully handle the absence of the commits table in the tenant schema, preventing dashboard failures.

The Problem

When the dashboard attempted to query the commits table to display user activity and calculate API

Introduction

After consolidating billing to a tenant-based system (Phase 3), we encountered an issue with the Cashier package. The default customer model was still set to User, causing errors when Stripe webhook events triggered.

The Problem

The stripe_id column, expected by Cashier, was not found because it was looking in the User model instead of the Tenant model.

Introduction

In multi-tenant applications, maintaining database schema consistency across all tenants can be challenging, especially during phased rollouts or migrations. This post addresses a common issue: handling older tenant schemas that may lack certain tables.

The Challenge

Older tenant schemas may not have all the tables required by newer application versions.