Learn how to correlate PHP-FPM access and slow logs with a database slow-query log to find the SQL behind a slow request.
Tag Archives: database
How to Connect a Cloud App to an Office Database Safely
Keep an office database private by using a local connector, a private VPN, narrow API operations, and idempotent retries.
How to Split Billing Across Companies Without Duplicating Work
Keep one operational order as the source of truth, then allocate billable items to separate issuing companies with controls that prevent duplicate invoicing.
How to Separate Laravel Configuration from Tenant Settings
Use Laravel config for bootstrap values and a tenant-aware database settings layer for safe runtime overrides.
How to Roll Out Migrations Across Separate Tenant Databases
A separate database per tenant improves isolation, but schema changes must be applied to every tenant deliberately and safely.
Why Audit Logs and Error Logs Should Be Separate
Audit history and technical error logs serve different purposes. Separating them improves search, performance, retention, and privacy.
How to Keep Sequence Numbers Continuous Across Grouped Data
Keep the group identifier and the global sequence number separate. This prevents numbering from restarting when data is divided into sections.
Why Filament Table Actions Can Lose Their Record Context
A practical lesson on why Filament modal callbacks can receive a null record and how to choose a more reliable edit flow.
How to Handle Old Slugs Without Breaking Links
A safe URL migration pattern: check the current slug first, use redirect history only after a miss, and return a small 404 response for unknown URLs.
How to Prevent MySQL Placeholder Errors in Large Batch Upserts
Large multi-row upserts can exceed MySQL’s prepared-statement placeholder limit. Split the work into smaller chunks and keep the chunks inside one transaction.