Python
What is GIL in Python and how does it affect multithreading and CPU-bound tasks?
How do they avoid multiple separate requests to the database, which leads to the N+1 problem?
Have you had experience using lambda functions in projects?
What indexes in PostgreSQL do you know besides B-tree?
What are the differences between TCP and UDP, and at what level do they operate?
Can you explain what is meant by a transaction in PostgreSQL and how it works?
Can the principle of single responsibility be considered part of encapsulation in object-oriented programming?
The model service is constantly hanging, and clients are sent to it once a week — doesn't this seem inefficient, and what can be done?
Tell about your most significant success in professional activity.
How do you approach resolving conflicts between colleagues in a team?.
Can you explain the concept of hexagonal architecture and its main principles?
How can you compare two objects represented in the form of an edge?
Does Sentry process system response time information?
What methods do you know to improve the efficiency of data retrieval using Django ORM?
In what situations and why might ORM be ineffective or undesirable?
Can you give an example of a situation where an analytical approach is required to solve a problem?
How to make linters and checks run automatically before commit, instead of manually through make lint, make types, etc.?
How does interaction between AWS services and the Amazon platform occur?
Can you explain the purpose of the finally block in exception handling in Python?
Can HTTP GET request be used to create new data on the server?