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…
Testing & QA
⚑ Сообщить о проблемеПоследние новости Testing & QA от Tech News
Все темы
agents
ai
api
architecture
automation
backend
beginners
career
claude
cybersecurity
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
node
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
testing
tutorial
typescript
webdev
Squashing Laravel Migrations: 5 Ways schema:dump --prune Bites a Real Team
Originally published at hafiz.dev A recent r/laravel thread was titled "250 migrations in 3 years. What's yours at?" The standard answer is one comm…
Я дважды неправильно объяснил один баг в ora2pg
У меня было объяснение, почему ora2pg теряет внешние ключи при переносе схемы в PostgreSQL. Я его опроверг, придумал новое и опроверг ещё раз. Насто…
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…
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…
Safely Test a MySQL 5.7 -> 8.0 Upgrade on Azure
Upgrading a production database? Don't make production your test environment. A safer approach is to restore production to a separate Azure MySQL se…
A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands
Setting up a reliable local web development environment is one of the first steps for anyone working with WordPress, PHP, MySQL, or Apache. While XA…
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…
OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See
A WhatsApp button on a shop was dialling the wrong number. Not a formatting problem — a genuinely different number, three digits short of the one in…
Beyond the Switchover: Using RDS Snapshots to Safely Test MySQL 8.4 Compatibility Before Your Blue/Green Cutover
AWS RDS Blue/Green deployment is a powerful zero-downtime tool, but its Green environment is read-only by design. Here is how to layer a snapshot-ba…
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 секунды. Если вы кликнули по ссылке, а сервер отдаёт…
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…
NocoBase and the mystery of the shifted timestamps: MySQL vs PostgreSQL, measured
There's a class of bug reports that keeps coming back in the NocoBase community, especially in the Chinese-language forum: "all my times are off by…
Я собрал кнопку, которая сотрёт прогресс всех моих игроков. И до сих пор боюсь её нажать
Два года по вечерам в одиночку пилю текстовую MMORPG в Telegram. Сейчас в ней 1111 аккаунтов и 586 выживших, которые бродят по мрачному острову. И г…
Проектирование интеграционного решения для автоматизации детской футбольной школы
Детская футбольная школа имеет базу данных детей и их родителей, в которой более 7000 уникальных записей. На данный момент посещаемос…
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 grea…
SQL Оконные функции простым языком
Каждый SQL-разработчик помнит свое первое столкновение с конструкцией OVER(). Когда после понятных и уютных SELECT и GROUP BY ты видишь этот перегру…
Два года один пилю MMORPG на CI4: пять багов, за каждым из которых стоял живой игрок
Строка “false” в PHP равна true. Я узнал это, когда рубильник, которым я выключаю фичи перед живыми игроками, полгода отказывался выключаться. Два г…
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…
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 fo…
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…