Python

Tell me what you know about message queues, message brokers. Which ones do you know, which have you used?

How to correctly, step-by-step, safely remove a column from a database that is no longer used, but the old code may still access it?

What is JWT (JSON Web Token)? What are its parts and what problem does it solve?

What is the difference between an array and a linked list? What data structure is used under the hood in a Python list?

How to run a synchronous blocking SDK from asynchronous code without rewriting it?

What is MVCC in PostgreSQL?

When should you use asynchrony, and when should you use synchrony/multithreading?

How to prepare backward-compatible database migrations for deployment without downtime?

Why are you leaving [company]?

Why are authentication and authorization separated? Can you explain?

What is 'unknown' in TypeScript and how does it differ from 'any'?

Please tell me what a metaclass is and give an example of a metaclass.

For which tasks is it better to choose RabbitMQ, and for which Kafka?

What are select_related and prefetch_related, what is the difference between them, and how are they implemented under the hood?

How would you architecturally build a new project on FastAPI or Django and where would you place business logic?

What side benefits does WAL provide that were not the main goal during its creation but are still a useful consequence?

Describe the simplest case of list operation complexity.

In which scenarios can RabbitMQ lose messages and how to prevent this?

Why can't indexes be added to all table fields? How to correctly add an index to a production table without blocking?

Describe a typical CI/CD process from commit to deployment on production.