MySQL Connector/Python Fails to Close Pooled Sockets on App Termination: Solution Explored
Introduction In the world of database-driven applications, efficient resource management is critical. However, a subtle yet significant issue has em…
Architecture
⚑ Report a ProblemLatest Architecture news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
career
database
devchallenge
devops
javascript
llm
machinelearning
mcp
news
opensource
performance
productivity
programming
python
react
security
showdev
softwareengineering
systemdesign
tutorial
typescript
webdev
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT
Installing a plugin fails with: Duplicate entry '0' for key 'PRIMARY' The obvious reading is that the plugin tried to insert a row with id 0. The ac…
MySQL to PostgreSQL Migration: A Practical UK Guide for Decision-Makers
Database migration is rarely just a technical exercise. For UK businesses, moving from MySQL to PostgreSQL can affect application performance, opera…
The rollback that only rolled back half of it
I was testing a new screen against the production ERP database: a box comes back from the customer, and the screen has to release the material insid…
Firebase больше не тянет: как мы строили real-time-чаты на Centrifugo
Расскажу, как мы отказались от внешних серверов, безболезненно пережили переезд, избежали сбоев в высокий сезон и сократили расходы на эксплуатацию…
Cost-Effective Public Hosting for Typescript/MySQL Monorepo: Optimizing for Small User Base Without Unnecessary Expenses
Introduction Hosting a Typescript/MySQL monorepo application for a small user base (4-5 users) presents a unique challenge: balancing cost-effective…
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17
At one interview I was asked about VIEWs. I answered honestly: in real projects I had barely run into them; for aggregates it is safer to keep a sep…
Fashion E-Commerce Store
When I started this project, the brief was simple to state and deceptively large to build: a full fashion e-commerce platform — product catalog, siz…
Modern IT Helpdesk & Ticketing System Built with PHP Native & MySQL
Are you looking for a clean, efficient, and modern way to manage IT support requests? Stop dealing with messy manual reports via chat and start usin…
Shopify Replaced Redis With MySQL for Inventory Reservations — and It Scaled Better
Shopify just did something that would make most engineers do a double-take: they replaced Redis with MySQL for their inventory reservation system, a…
How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model
Building a personalization engine for a multi-format content feed, without machine learning, and the testing process that forced us to rebuild it. T…
Build a Maintainable Node.js CRUD API with Express and MySQL
Writing SELECT , INSERT , UPDATE , and DELETE queries is not the difficult part of a CRUD API. The difficulty begins when every route starts handlin…
Я написал мессенджер в одиночку. Поможете устроить ему краш‑тест?
Дисклеймер: Это статья-проверка на прочность. Проект работает на PHP + MySQL + Polling каждые 3 секунды. Если вы кликнули по ссылке, а сервер отдаёт…
Correlated Subqueries Explained: From Confusing to Intuitive
Hey everyone! 👋 It's been a while since I posted here. Over the past few days, I've been revisiting SQL from the ground up—not just solving problems…
TalaDB - database ToolKit for php
I'm designing a database toolkit for PHP. Here's my architecture. What problems do you see? https://github.com/NoobGreggy/TalaDB
Constraining the Agent: What I Learned Wiring MCP Into a Legacy System
Notes from January 2026, when giving an AI agent live database access still felt reckless. Written for engineers who are about to do this, and for t…
Я не хотел писать ORM для Kotlin/Native. Мне просто нужен был PostgreSQL
Всё началось с архитектурного тупика. Я занимался бэкенд-частью low-code платформы, на базе которой автоматизировались внутренние процессы крупных к…
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 fl…
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…
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 Ne…
🧠 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 vect…
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…
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 re…
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 — es…