How to organize parallel task execution using multithreading and asyncio (worker pool, task queue, gather)?
Python
Tell us about your experience, key projects, and technology stack.
What is ACID, how is each property ensured?
Уровни изоляции транзакций: Read Uncommitted, Read Committed, Repeatable Read, Serializable.
What salary level do you expect based on your qualifications and experience?
How to optimize a slow SQL query? EXPLAIN ANALYZE, indexes, index types.
What rating would you give to your professional skills?
SOLID principles: tell about each.
What types of multitasking are available in Python? What are they used for, and what problems do they pose?
Why is searching in a list and a dictionary different? Why is the dictionary O(1)?
What is a coroutine? How does asyncio work under the hood?
Where do you live?
Describe the most recent project you have implemented and your role in it.
How can you obtain a list of all user accounts, including system and hidden ones, in a Linux system?
What is GIL and why was it created in Python?
Design a URL shortening system.
What should be the keys of a Python dictionary?
Please share your professional journey and the main projects you have participated in.
Challenges of microservices architecture: data consistency, distributed transactions, API versioning.
What is the point of using API Gateway if we only have one service?