Page 135 - Mironsoft Blog
-
Maxim Mironjuk
-
November 06, 2025
LAG and LEAD solve a problem that used to almost always require a self-join: accessing the value of the previous or next row within a sorted order. Whether it is month-over-month comparisons, trend analyses, or detecting gaps in a sequence, this article explains the syntax, the offset and default parameters, and the practical use cases of LAG and LEAD in detail.
-
Maxim Mironjuk
-
November 06, 2025
Vue 3 and Alpine.js share the same ideological DNA: both rely on declarative template rendering, reactive state, and a directive-based HTML enhancement model. The difference lies in depth, build requirements, and target complexity, and this article shows exactly where the boundaries run.
-
Maxim Mironjuk
-
November 06, 2025
Switching between feature branches without bringing along the matching database means testing against wrong states or losing fixtures. An automated workflow with database snapshots per branch makes switching as effortless as a plain git checkout.
-
Maxim Mironjuk
-
November 06, 2025
CSS Houdini opens up the browser's rendering process to developers. Custom backgrounds, patterns and layout algorithms as worklets, usable directly in CSS. The most powerful, and also the most complex, approach to extending CSS.
-
Maxim Mironjuk
-
November 06, 2025
A theming system with CSS variables stores design tokens as native custom properties in the browser instead of recomputing them via JavaScript on every render. The result is a theme switch without re rendering components, a smaller bundle size, and an approach that works independently of the chosen CSS strategy.
-
Maxim Mironjuk
-
November 05, 2025
A Vue application that runs smoothly with 50 entries can grind to a halt with 5,000 entries. Virtualization, memoization and targeted profiling are the three levers that keep large lists performant, measured, not merely felt.
-
Maxim Mironjuk
-
November 05, 2025
Mocking composables is more complicated in Vue tests than it first appears, because composables often combine global state, network access, and reactive side effects. With vi.mock, targeted dependency injection, and provide/inject as a testing seam, components can still be tested reliably in isolation, without dragging along real composable implementations.
-
Maxim Mironjuk
-
November 05, 2025
The cache-aside pattern moves all caching logic into the application: it checks Redis, loads from the database on a miss, and fills the cache itself. Anyone who ignores error handling, TTL values and race conditions ends up with silent inconsistencies and unnecessary database load, even though Redis is supposed to prevent exactly that.
-
Maxim Mironjuk
-
November 05, 2025
A shell script that spawns a thousand external processes for a thousand files isn't a performance problem, it's a design problem. Anyone who understands how much a fork costs, which operations builtins already cover, and how caching works in the shell writes scripts that take seconds instead of minutes.
-
Maxim Mironjuk
-
November 05, 2025
JSON columns give a relational database exactly the modeling freedom that otherwise serves as an argument for a NoSQL switch, without giving up transactions, joins, and referential integrity. Whoever correctly indexes, queries, and validates JSONB in PostgreSQL or JSON in MySQL covers many semi-structured use cases within the existing database.
-