Python

We found a service that performs an INSERT into this table. After adding a unique constraint, the service started failing with an error. Can we modify the SQL query so that it does not fail when the unique constraint is triggered, without changing the application logic?

What is the difference between the operators == and is in Python?

How do they avoid multiple separate requests to the database, which leads to the N+1 problem?

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?

How does task switching occur in coroutines when using asyncio?

Junior — Middle

СБЕР Центр ИИ

Can the principle of single responsibility be considered part of encapsulation in object-oriented programming?

Tell about your most significant success in professional activity.

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?

Junior — Middle

БАРС групп

What professional experience does a team lead usually have?

Junior — Middle

Jetlend

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?

Have you studied the official Python documentation to improve your knowledge?

Is it possible to describe a development approach where tests are written before the implementation of code, and explain its main principles?