Migrating a Magento 2 store from utf8 to utf8mb4 without losing data
A customer signed up with an emoji in their display name, and the row saved with everything after the emoji chopped off. No error in the log. The colu…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
Pagination: Always a "sort" (of) mistake [bugfix]
Pagination is a key component on web-applications that let users navigate through pages making easy to read/find records. Also, pagination is a great …
Deploying Apache DolphinScheduler 3.1.9 Cluster with MySQL Instead of PostgreSQL? A Practical Docker Compose Guide
Background Today, we'll walk through one of the most requested deployment scenarios in the Apache DolphinScheduler community: deploying an Apache Dolp…
Magento 2 EAV Performance Deep Dive: Optimizing the Entity-Attribute-Value Model
The Entity-Attribute-Value (EAV) model is both Magento's greatest strength and its most persistent performance bottleneck. It gives you unlimited flex…
We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation — Oversells Went to Zero
For two years, our Sponsored Placements service booked limited ad inventory through Redis: a counter in Redis, a Redlock around the decrement, and a T…
From Native WordPress to Headless: The Real Engineering Decisions Behind a Production Migration
Every headless WordPress conversation starts the same way — someone draws an architecture diagram with arrows pointing from a REST API to a shiny Next…
🧠 Mastering pinecone fastapi semantic search tutorial
🚀 Overview — Why Semantic Search Matters Semantic search surpasses simple keyword matching because embeddings place texts in a high‑dimensional vector…
I had to restore an entire database just to recover one deleted row
Let me vent for a second, because last week broke me a little. I've been doing SRE / database ops for about 5 years, and I keep relearning the same pa…
Replicate MySQL to ClickHouse with Sling
Introduction ClickHouse is a columnar OLAP database. It runs aggregate queries across billions of rows in seconds. MySQL is what most apps run on for …
Stop Putting dd() Everywhere Debug the Database From the Source Instead
Every backend developer has done this at some point. A request fails. Something is not inserting into the database. And suddenly the codebase turns in…
Introduction
Hi everyone! 👋 My name is Fahad and I’m a frontend web developer currently learning and building modern responsive websites using HTML, CSS, JavaScrip…
How we tracked down a mysterious latency issue in our AWS Lambda + RDS Proxy stack, and discovered Prisma was the culprit all along.
Our API Was Fine. Database Was Fine. So Why Were Queries Taking 16 Seconds? It started with a support ticket. A customer-facing API that normally resp…
CAP Theorem Explained: What I Learned Setting Up MySQL Replication
I recently started my journey into system design and data-intensive applications. This experience has completely changed how I look at software — espe…