← All articles

Vladimir Lovtsov / Leadership notebook

#data

Practice, analysis and observations on this topic.

Articles: 4

036 min read

data / sql / systems analysis

SQL in Practice: Your First PostgreSQL Queries

A self-contained SQL exercise for analysts: create two tables and practise SELECT, filtering, JOINs, aggregates, data changes, and transactions.

045 min read

architecture / data

Message Brokers: Where the Guarantees Stop

A practical comparison of RabbitMQ, ActiveMQ Classic, and Kafka: messaging models, acknowledgements, partition ordering, and the real limits of at-least-once and exactly-once.

Short observations and new writing in my Telegram channel (in Russian).

@it_underside ↗