Python

Why did Magnite use a GIN index for full-text search instead of a separate search engine (Elasticsearch)?

Tell about the merchant registration process — how is it organized?

Debug task: fix the idempotency problem (client's repeated request creates a duplicate operation) and the Outbox problem (two workers publish the same events)

What is the difference between Coroutine, Task, and Future in asyncio?

What is important to you in the code review process?

Debugging task: fix race condition during money withdrawal (two parallel requests may withdraw more than available on the account)

How does Kafka conceptually differ from RabbitMQ?

What does await do in Python?

How to protect against duplicates and races in parallel transactions in a database?

Why are locks needed in databases?

What is EXPLAIN in a database, and why is it used?

Which services were you responsible for (ownership)?

How does your team conduct code reviews?

What is AsyncSession in SQLAlchemy and what are the rules for working with it in the context of a FastAPI microservice?

What is the difference between synchronous and asynchronous service interactions?

What are the current priority tasks in the team? What's urgent?

What is a Race Condition in simple terms?

How do you generally evaluate the team approach: BDD, FastAPI, geographic separation of the system?

What does EXPLAIN do and what changes when adding ANALYZE? When is an index useless?

At the task setting stage, who do you most often interact with and in what form does the task come?