Page 53 - Mironsoft Blog

GraphQL and caching are often seen as a difficult pair, because every request hits the same endpoint and CDNs do not cache POST requests by default. With the right combination of application-level resolver caching and edge caching through persisted queries, the problem can be solved systematically.

The ANSI SQL standard defines less than many developers assume, and the major database systems rarely implement it in full. This article shows which parts of SQL are actually standardized, where PostgreSQL, MySQL, Oracle, and SQL Server use their own dialect extensions, and how to recognize whether a query is portable or not.

Code that is never tested and never analyzed quietly accumulates errors. Bundling PHPUnit, PHPStan, PHPCS and composer audit as parallel GitLab CI jobs delivers feedback after every commit on tests, type safety, style and known security vulnerabilities, automatically and without manual effort.

Elasticsearch's standard analyzer treats every language the same and thereby ignores word stems, stopwords and special characters that differ completely between German, French or English. A custom analyzer per language, combined with a per-field-per-language mapping strategy, turns a generic full text search into one that actually returns the right hits in every shop language.

A Zod schema describes at once which values a form field may accept and what TypeScript type the result has after successful validation. Combined with VeeValidate through a Zod resolver, this creates a single source of truth for forms that would otherwise easily drift apart between validation logic and type definitions.

"My app behaves strangely in development mode, but runs flawlessly in production" is a warning sign, not a reason to relax. React Strict Mode makes visible bugs that will eventually surface in production. Running things twice is not a bug, it is a precise diagnostic strategy.

Date pickers and comboboxes are among the most demanding interface patterns on the web because they constantly switch between a closed input field, an open suggestion list and an actively highlighted option. Implementing the WAI-ARIA combobox pattern precisely, testing keyboard and screen reader together, and offering an independent text-input fallback makes date selection and autocomplete reliably usable for every user group, even without a mouse.

Caching in Symfony means more than $cache->get(). Anyone who really wants to gain performance combines multiple cache layers: APCu for ultra-fast in-process data, Redis for shared state across PHP processes, HTTP cache for complete response reuse, and keeps all three layers consistent through tag-based invalidation.

Many shell scripts fail silently: a command returns exit code 1, the pipeline keeps going, and monitoring sees nothing. set -euo pipefail, ERR traps with LINENO, and clean exit codes are the foundation of every Bash script that needs to run reliably in production and react instantly and traceably when something goes wrong.

x-data is the heart of every Alpine.js component. Misjudging state scope leads to unexpected reactivity effects and painful refactoring. This tutorial shows how to correctly scope, reuse, and communicate state between components.