Ihnat Z

Just after lunch on a Monday, an alert fired: FIX session disconnected.

Improving query performance is always challenging, especially when working with large-scale databases.

Visualization is a great opportunity to see some complex structures from another side.

SQL triggers is something that everybody heard a lot about.

Let’s assume you want to find all node leaves.

PostgreSQL provides you ltree extension to organize tree-like structures.

Materialized view is an object that contains the query’s results.