5 вопросов
-
senior code_explain ```sql WITH RECURSIVE org_tree AS ( SELECT id, name, parent_id, 0 AS depth, ARRAY[id] AS path FROM employees WHERE id = 42 UNION ALL SELE…
-
senior code_explain ```python import asyncio async def fetch_all(urls: list[str], concurrency: int = 10) -> list[str]: sem = asyncio.Semaphore(concurrency) async def boun…
-
senior debug Делаешь code review PR-а. Что плохо? Список замечаний. ```python # Изменения в файле app/routes/users.py @app.get("/users/{user_id}") async def get_user(user_…
-
senior case На проде растёт p95 latency. В Postgres logs: ``` 2026-05-26 14:23:01 STATEMENT: SELECT * FROM events WHERE created_at > now() - interval '7 days' duration: …
-
senior case Сервис A в проде начал отдавать 503. В логах: ``` ERROR | service-A | upstream service-B returned 503 after 30s timeout ERROR | service-B | pool exhausted: 0 f…