Python
What is GIL in CPython, how is it implemented, and why is it needed?
There is an external service that responds exactly 1 second. When and why will our service crash when load increases?
What Python generator capabilities were used for asynchrony before async/await?
What is the difference between EXPLAIN and EXPLAIN ANALYZE in PostgreSQL?
Provide an example of one of the most challenging tasks at your last job: what was the difficulty, what did you do, and what was the result?
[name] asked: What is your current search status: active search, interviews, offers?
What is an index in a database, what types are there, and what are the pros and cons?
What does the YAGNI principle mean?
What feature of immutable objects in Python allows them to be used as dictionary keys?
Can a B-tree help with LIKE queries?
When does the complexity of dictionary operations cease to be constant?
How to organize the database migration process without service downtime (CI/CD)?
How to refresh the access token after expiration without requiring the user to log in each time? Where does the refresh token come from and how is it used?
What is the N+1 problem in ORM, why does it occur, and how to solve it?
Have you had performance reviews, how often were they conducted, and what was your last performance rating?
Do you have any questions about the selection stages?
What happens in Python when a string is modified?
What signs in the code will trigger the desire to refactor?
Why are access level agreements private, protected, and public necessary in Python?
[name] asked: Explain how ORDER BY works here — the one used inside the window function OVER, is it different from the overall query execution order?
ivi