How to Run a WordPress Major Upgrade Safely Using WP-CLI Commands

·1 views

A step-by-step WP-CLI workflow for WordPress major upgrades recommends updating core, plugins, and themes separately rather than using the dashboard's 'Update All' button. The all-in-one dashboard approach makes it difficult to isolate the cause of any breakage and can silently mask PHP warnings behind a misleading 'Updated successfully' message. WP-CLI allows administrators to update one component at a time — starting with a database backup and core version check — before proceeding through each intermediate version explicitly. Running the database migration command manually after each core update provides a clear success or failure signal, unlike the automatic migration triggered by loading the admin screen. Verifying core file checksums after each update and confirming the site returns a 200 status between steps helps catch problems early before they compound.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

How a Browser-Based Tiled Poster PDF Generator Was Built Without a Server

A developer built Rasterbator.app, a fully browser-based tool that converts images into tiled, printable poster PDFs without uploading files to a server. The pipeline covers five stages: local image decoding, unit conversion, page grid calculation, halftone preview rendering, and PDF generation. All measurements are converted early from millimeters or inches into PDF points to keep layout logic consistent throughout. A page overlap feature allows adjacent printed sheets to share image area, making physical assembly easier. Aspect ratio is preserved during grid calculation, with the image centered horizontally and top-aligned to handle the rounding that occurs when partial page strips require a full sheet.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

NocoBase timestamp shifts explained: MySQL stores no timezone, PostgreSQL does

Developers using NocoBase have repeatedly reported datetime values appearing shifted by several hours, a pattern matching their local UTC offset. Testing NocoBase 2.x against both PostgreSQL 16 and MySQL 8.4 revealed the root cause: MySQL's DATETIME type stores only a wall-clock value with no timezone offset, while PostgreSQL's timestamptz preserves the offset as part of the stored data. Because MySQL lacks offset storage, NocoBase must interpret stored times using the server's TZ setting on every read and write, meaning any change to that setting silently shifts the meaning of all existing timestamps. On PostgreSQL, the same timezone-change experiment produced no shift, since the offset is already encoded in the stored value. The practical guidance is to set the server timezone explicitly from day one, never change it, and keep it consistent across all environments — or choose PostgreSQL to avoid the issue structurally.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Four Canvas Text Rendering Bugs That Only Appear in Spanish, French, and Portuguese

A developer maintaining multilingual web tools for generating PNG certificates and badges identified four recurring Canvas 2D text rendering failures that go undetected when testing only English and Japanese. French and Portuguese text runs 1.4–1.7 times longer than Japanese, while Spanish can expand to nearly three times the length, causing overflow and ellipsis that cuts off semantically critical words. A word-wrapping fix using a Latin character-class tokenizer introduced a new bug where accented characters like ç, é, and ã caused mid-word splits in Spanish, French, and Portuguese output. A mismatch between the DOM preview and the final PNG also emerged when auto-fit font sizing was applied only to the canvas render, breaking the tool's core promise of downloading exactly what the user sees. The developer recommends generating actual PNGs across all target locales as the only reliable detection method, since string-comparison tests cannot catch rendering-level failures.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why Your AI Coding Assistant Keeps Acting Like a Confused New Hire

A software developer writing for DEV Community argues that most AI coding workflows are over-engineered, with teams building elaborate multi-agent pipelines before solving the original problem. The real bottleneck, the author contends, is not code generation but context reconstruction — AI assistants repeatedly fetching the same Jira tickets, Confluence pages, and guidelines at the start of every session. The proposed fix is to treat frequently needed information as a local knowledge base, ideally in Markdown, so the AI can access it directly rather than making repeated external tool calls. The author highlights tools like Obsidian as a way to build a persistent 'second brain' that survives across conversations. The core argument is that less time spent fetching context means more time actually building software.

0 comments Read more at DEV Community