Marat Latypov articles - 11 total
Understanding the PostgreSQL Crosstab Function
Usually piece of data in SQL is represented as a row in a table. But often it's convenient to...
Tagged services in Symfony new look
A few years ago, I wrote an article titled Strategy pattern in Symfony. It was good for its time and...
Removing orphaned Parents with Doctrine
Previously, we considered a common real-life case where, to maintain referential integrity, we might...
Database referential integrity with Doctrine
Here could be extensive AI-generated introduction about Database referential integrity, but not...
How to hydrate trees in Doctrine
Few sprints ago I had an interesting task. I should get from database a tree structure and render it...
Strategy pattern in Symfony
In general, we use the Strategy Pattern when we can do something in several ways depending on some...
Make your state safe
Imagine you have a simple component Post which just renders a post page. export const Post = ():...
useQuery: isFetching vs isLoading
In additional to query status useQuery has so called fetchStatus and isFetching flag. It causes very...
Explaining useQuery states
In the world of React.js useQuery is well-known fetching tool with great documentation. However,...
Clear as the sun explanation of De Morgan's laws
Sometimes, novice developers struggle with basic logic expressions, especially De Morgan's laws. To...
Sprinters vs marathonians
It's amazing, but developers are different! And I don’t mean different programming languages or...