Page 140 - Mironsoft Blog

A plain GROUP BY over a date column is rarely enough for time series aggregation, because days without events simply do not show up in the result. This article explains how to build time buckets with DATE_TRUNC, how calendar tables and generate_series reliably fill missing periods, and how to compute comparison periods like previous year or previous week directly in SQL.

PHP projects rarely rely on just one template engine. Magento projects combine PHTML with Alpine.js and Tailwind. Symfony projects mix Twig with PHP. Laravel projects use Blade, sometimes alongside Livewire. PHPStorm can support all of this at once, if you know which switches to flip.

A single voter with twenty if branches is not an authorization system, it is a maintenance burden. This guide shows how multiple security voters in Symfony are composed cleanly, made reusable through abstract base voters, and combined with the right AccessDecisionManager strategy.

Anyone building React Native screens purely with StyleSheet.create ends up writing a separate style object for every component, losing the consistency of a shared design system in the process. NativeWind carries Tailwind CSS's utility-first approach straight into React Native and replaces scattered style objects with the same className strings that web teams already know from Tailwind.

urql replaces the monolithic client core of other GraphQL clients with an exchange pipeline made of swappable, individually testable middleware functions. Normalized caching is optional through Graphcache instead of a default. This article shows when that leaner architecture is genuinely enough for a project.

The NestJS GraphQL Module generates the entire GraphQL schema automatically from TypeScript classes and decorators, instead of maintaining a separate SDL file. ObjectType, Field, Resolver and the Args decorator together form a code-first approach where type safety stays intact all the way from the database model to the GraphQL response, including autocompletion and refactoring support in the IDE.

When requests suddenly hang while CPU usage stays low, lock contention is often the reason. With performance_schema in MySQL and pg_locks in PostgreSQL, lock contention can be diagnosed systematically, instead of guessing anew with every incident which session is blocking which other one.

Which variables need to be set? How should jobs be structured? In what order do Magento commands need to run? This cheatsheet answers these questions compactly and completely, as a reference for everyday deployment work.

React 19 is not an incremental update. Server Components leave the experimental phase, Server Actions become part of the core API, the React Compiler takes over automatic memoization, and new hooks fundamentally simplify forms, optimistic updates and asset loading. What is relevant for existing projects, and what actually changes in everyday work.

Using fetch or XHR on page unload is a race condition against the browser. When a tab is closed or the page is unloaded, the browser aborts any open requests. navigator.sendBeacon guarantees delivery of data without delaying navigation, which makes it the right solution for analytics, session data and exit tracking.