Python

What were you doing before 2020?

What are iterators and generators in Python, and how do they differ?

Do you like working with SQLAlchemy compared to pure SQL? Name the pros and cons.

Have you worked with CTE (Common Table Expressions)?

How to optimize the JOIN of two large tables (10 and 15 million rows) with subsequent filtering if indexes on JOIN keys already exist?

Why do you consider new proposals?

When searching for trigrams in GIN, do you need to go through all keys and compare them?

Have you had experience implementing tools based on LLM?

Why did you decide to switch to development?

What amount do you see for yourself in terms of financial component?

A user uploads a video and selects the desired processing, which he wants to get. The service accepts the video, applies the necessary processing, and outputs the final result. By processing, we can understand, for example, the following: make the video black and white, flip it, speed it up N times, etc. It is important that the user can monitor the progress of the processing. Load: 10,000 videos per minute

The service is available at `[link] documentation — `/docs` ## Commands ```bash make up # Start all services make down # Stop services make test make migrate # Run tests ``` Uses in-memory SQLite — no need to set up PostgreSQL.

What is the main difference between RabbitMQ and Kafka?

What is an index in PostgreSQL, what does it speed up, and what are its disadvantages? What indexes have you worked with?

Tell us about yourself — a brief intro of 3 minutes

What questions do you have for me at this stage?

Why was RabbitMQ chosen for asynchronous interaction instead of Kafka?

Will a composite index (A, B) be used for ORDER BY B without a condition on A?

What has caused the transition from REST to gRPC to improve performance, and how much has the system been accelerated?

What operations can a B-tree index accelerate, especially for BETWEEN and LIKE/ILIKE?