Instant ADD COLUMN, Until a FULLTEXT Index Shows Up: A MariaDB Migration That Froze Writes
Adding a nullable column to an InnoDB table is supposed to be a non-event. On MariaDB 10.3+ and MySQL 8.0+ it is usually an instant operation: a met…
Open Source
⚑ Сообщить о проблемеПоследние новости Open Source от Tech News
Все темы
AI
agents
ai
api
architecture
automation
backend
beginners
career
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
Cloning a staging MongoDB and MySQL to your laptop without installing a single database client
Every week someone on my team needs a copy of our staging data on their laptop. Two databases, MongoDB and MySQL, a few gigabytes. For years the ans…
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…
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…
"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…
Laravel's New whereBinary(): Simple Case-Sensitive Queries in MySQL
If you have worked with Laravel and MySQL for a while, you have probably run into this situation: User :: where ( 'name' , 'john' ) -> get (); Yo…
Jev was the tipping point - I built the last MySQL search statement
The problem that kept finding me was mapping unstructured data into an existing corpus. Supplier products that needed to match a catalog. Text that…
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…
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…
Installing WordPress on Ubuntu 24.04
WordPress is a free, open-source content management system (CMS) built with PHP and backed by MySQL or MariaDB. It began as a blogging tool and has…
Laravel's Native Vector Search Now Speaks MariaDB — Plain MySQL Is Still Left Out
Originally published on my blog . On August 20, PR #61250 was merged into Laravel's 13.x branch, bringing the query builder's native vector search —…
Building a game server tracker: what I learned exposing a public JSON API
A few months ago I shipped L2 Calendar , a tracker for Lineage 2 private server openings. Players kept asking the same thing: "when's the next Inter…
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…
What I Learned Partitioning a Billion-Row Table in Production
Adding an index stops working eventually. Here's what we did when a nationwide logistics platform's core table crossed a billion rows — and the part…
Как я написал свой мигратор для ClickHouse — и почему он до сих пор жив
В 2020-м мне понадобилось версионировать схему ClickHouse в CI/CD, а готового инструмента под Go с поддержкой ClickHouse не нашлось ни одного. Пришл…
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…
How I Debugged a phpMyAdmin 500 Error While Importing a Large SQL File on Laragon
I recently ran into a weird issue while working on a Laravel project on Windows using Laragon . Everything was working fine until I tried to import…
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…
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…
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…
The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem
A news platform I maintain started serving pages in six seconds. Load average sat at 16 on a 12-core box for hours. Nothing had been deployed. Traff…
Understanding Two-Phase Commit (2PC) by Building One in Go
Introduction Imagine sending 100 from Alice to Bob. If both accounts are in one database, this is easy: start a transaction, update both balances, a…
Atomic Money: Making a PHP/MySQL Wallet Safe Under Concurrency
The lost-update bug that quietly corrupts homegrown wallet balances — and the five disciplines we used across PayWithToken to make money movement co…