Python

Is connection pooling a feature of FastAPI or something else? Where does it come from and how to manage it?

What types of indexes are there in PostgreSQL?

What types of engines do ClickHouse tables have?

There is an external service that responds exactly 1 second. When and why will our service crash when load increases?

What happens if you call an external service synchronously?

We have a table with a billion records. What happens if you do COUNT(*)?

Git Rebase — what is it and when is it used?

What is offset in Kafka and what is it used for?

How to update the cache with COUNT for a table with 100 billion records if COUNT itself is expensive?

Git Stash — что это и для чего используется?

What is a consumer group in Kafka and why is it needed?

How have you used dependency injection in your projects?

What is the difference between EXPLAIN and EXPLAIN ANALYZE?

If the task is to display the number of lines in a web interface, how would you solve it?