Golang

What is a connection pool in the database/sql package in Go?

What is a Materialized View in ClickHouse?

How does Dependency Inversion differ from Dependency Injection?

Can a primary key be composite?

Can a B-tree index be on multiple fields at once?

Tell about your latest work experience.

The service started responding in 3 seconds instead of 100 milliseconds. What will be your actions?

What is the difference between the EXPLAIN and EXPLAIN ANALYZE commands in PostgreSQL?

What is a reverse proxy and how can it be implemented?

How can database queries be optimized?

What is deduplication in Kafka?

What happens when reading from a closed channel?

What is a consumer group in Kafka?

What is the key difference between Dependency Inversion and Dependency Injection?

What is the difference between a deadlock and a livelock?

What is the CAP theorem?

What will we do if we have many players around the world and the ping will affect the quality of the game?

Tell me about the SOLID principles.

How to add to the system a storage of all events from the entire project for analytics and aggregation?

What is a reverse proxy and what is usually used to implement it?