Python

When is a Seq Scan considered normal, including on a large table?

What signs in the code will trigger the desire to refactor?

What is the N+1 problem in ORM, why does it occur, and how to solve it?

How do select_related/prefetch_related or joinedload/selectinload work at the SQL level?

What is Saga, what types are there, and have you used it?

What is CQRS and how have you applied it in a project?

Is it possible to write an asynchronous server in Python without asyncio?

What Python web frameworks have you used in your career?

What is epoll and what role does it play in asynchronous network I/O?

What is the GIN index used for?

How is data independence ensured in a microservices architecture, and what compromises have been made in your projects?

Compare FastAPI and Django: what is good about each, and in which cases would you choose one or the other?

How does asyncio work in Python on Linux?

What is reference counting and what problem does the CPython garbage collector solve?

Can race conditions occur in multithreaded Python code with GIL, for example with `x += 1`?

What is GIL in CPython, how is it implemented, and why is it needed?

What types of indexes in PostgreSQL do you know and have used? What does B in B-tree mean?

Can a B-tree help with LIKE queries?

Compare Kafka and RabbitMQ: what tasks do you use each for?

What is the difference between Kafka and RabbitMQ interaction models?