Golang

What is the CAP theorem?

What is the CAP theorem and what is its essence?

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

What data type in Redis will be used for matchmaking?

There is a system designed for quick response groups. The system sends a signal, the group receives the call and deploys. A signal was received, and three groups responded simultaneously, but we only need to send one group. How can this be done at the database transaction level?

Tell me about SOLID. What is it?

What is ACID? Can you decode and explain it?

What indexes are available in PostgreSQL?

Что такое «at least once» и «exactly once» в Kafka?

Which channel transmits data faster: buffered or unbuffered?

Give an example of a system that is resilient to partitioning and has consistency (CP system).

What delivery guarantee will we use in Kafka?

Tell about your latest work experience.

How does EXPLAIN differ from EXPLAIN ANALYZE?

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

Have you worked with Clean Architecture and Domain-Driven Design?

Tell me, why did you decide to look for new projects and what kind of development would you like?

Have you worked with Domain-Driven Design and clean architecture?

Is the order of fields in a composite index important?

What is Kafka and how does it differ from RabbitMQ?