Python

Please tell me which AI tools you use for coding.

What is the algorithmic complexity of the expression 999999 in range(1,99999999)?

[name] asked: Imagine you have two offers — from our company and another. What criteria will you use to choose, and what might sway you towards the other company?

What types of indexes do you know in PostgreSQL?

Tell me more about how select_related and prefetch_related work under the hood — what happens when you call each method.

What is the difference between Kafka and RabbitMQ?

Can you tell more about GIL: what it is, why it is needed, and why it is such a hindrance?

What problem does JWT solve?

What is GIL and why is it needed in Python?

Please tell me, what is authentication and what is authorization?

What patterns help avoid downtime during deployment?

[name] asked: How would you approach ensuring the order of event processing/delivery in a distributed system?

Which tasks in Python are well parallelized, and which are poorly?

Let's reason logically: what could be a wrong database migration that causes a 500 error when switching to an old app version (for example, if a column and the code referencing it are deleted simultaneously)? How to avoid this?

What is a descriptor in Python?

def make_order(): order = Order.objects.create(...) print(order.id) notify_order_created.delay(order.id)

Why is separating authentication and authorization important from a security perspective?

How to make linters and checks run automatically before commit, instead of manually through make lint, make types, etc.?

How is a transaction structured under the hood in PostgreSQL? What is WAL?

Besides memory allocation, in what other cases can a list affect performance?