How to solve the double payment problem in case of a database write failure?
Python
Write a function that takes a list of numbers as input and returns a new list containing only the unique elements of the original list, maintaining their order.
Have you worked with Protocol in Python? What are Generics?
Tell about locks and semaphores. What are locks needed for, and what is the difference between multithreaded and asynchronous modes?
Tell me about the Unit of Work pattern. How to manage transactions in the business scenario of creating an order?
Tell about ways to execute code in Python: multiprocessing, multithreading, asynchronous.
What package managers do you use? Why is a lock file needed?.
Tell us about Pydantic. How does it differ from dataclass?
How would you solve the problem of slow database queries?
Tell me about architectural patterns. How to organize code for integration with an external gRPC service?
Tell me about your experience. What have you been doing, what have you worked on?
Tell about the levels of transaction isolation.
How does Read Committed work at the level of two transactions? Provide an example.
Tell about window functions in SQL.
What linters, formatters, and type checkers have you worked with in Python?
Tell me about MVCC (Multi-Version Concurrency Control).
Что такое ACID? Расскажи про каждую букву.
Tell me about indexes in Postgres. What types are there, and how does a B-tree index work?