Собеседование в VK Middle Python: создаем ленту рекомендаций для соцсети!

简介：

00:00:00 – The speakers introduce themselves and explain their roles. 00:05:14 – They share their experience as mentors. 00:05:41 – They discuss the candidate’s experience. 00:07:24 – A discussion on multithreading and multiprocessing in Python. 00:13:09 – Real‑world encounters with these concepts. 00:16:57 – Suitability of Python for desktop applications. 00:18:47 – The Global Interpreter Lock (GIL) is explained. 00:20:45 – Comparisons of GIL behavior in other languages. 00:21:57 – Whether GIL is necessary in Python. 00:24:15 – Building a personalized feed for a social network. 00:27:31 – The solution to the problem is presented. 00:31:55 – When Django is the best choice. 00:35:54 – Types of database queries. 00:37:44 – Key points when connecting FastAPI with PostgreSQL. 00:40:16 – Ensuring stable response times under high load. 00:42:21 – Implementing caching. 00:43:37 – Redis versus Memcached. 00:44:08 – Redis features. 00:45:29 – Scaling Redis. 00:46:22 – Node routing mechanisms. 00:47:09 – Choosing keys and values in Redis. 00:48:50 – Optimizing user response times. 00:50:43 – The role of PostgreSQL. 00:51:10 – Complexity of ID queries in PostgreSQL. 00:51:48 – Indexes used in PostgreSQL. 00:54:25 – Diagnosing database latency. 00:57:25 – Using EXPLAIN. 00:58:30 – Finalizing the solution and remaining gaps. 00:59:57 – Geographically synchronizing users and server nodes. 01:01:24 – DNS load balancing possibilities. 01:02:11 – Potential pitfalls of DNS solutions. 01:03:01 – Tools for logs and load testing. 01:03:45 – Considerations for ELK and microservices. 01:04:54 – Sentry’s handling of RPS and response time. 01:05:09 – Monitoring request counts and timings. 01:05:38 – Prometheus usage. 01:07:17 – How mentorship sessions are conducted. 01:14:41 – Mentor feedback. 01:15:41 – Candidate feedback. 01:16:21 – Soft‑skill development support. 01:16:49 – Experience at Mail.ru. 01:17:30 – Mentor recommendations. 01:17:53 – Questions about HR skills. 01:18:26 – Necessity of detailed answers in interviews. 01:19:38 – Transitioning from Python to Go. 01:21:52 – Career progression from junior to senior. 01:22:20 – Accelerating from junior to mid‑level. 01:23:37 – Course selection advice. 01:28:17 – Technical scaling question. 01:29:53 – Interview question analysis.