Python

What parameters in Docker Compose should be set to improve fault tolerance and reliability of the service?

What is the time complexity and additional memory of the two-pointer solution?

What is the difference between `__new__` and `__init__`?

How does Gunicorn differ from Uvicorn?

How is an iterator implemented in Python?

Why is `__slots__` needed?

Why is a WAL file needed in PostgreSQL?

What types of functions exist in PostgreSQL?

In what order does Python search for a variable or function name in scope?

What problem may arise if a random UUIDv4 is used as a key in a large table's B-tree index?

In what order does Python search for methods during multiple (horizontal) inheritance?

When should you use threads and when processes?

Can there be access to the device at L7 level but no access via TCP and UDP?

How do indexes affect database performance?

Describe the algorithm you use to find and optimize slow queries. Can you share a real case?

Tell us about your experience: on which projects you worked at [company] and [company], what technologies you used, and what you were responsible for?

What is the difference between a function and a procedure in PostgreSQL?

What are SQL window functions?

List the basic principles of OOP and briefly explain them.

How would you design storage and fast search for a large stream of IoC (Indicators of Compromise: hashes, IP addresses, domains)?