Frontend

What is ACID? How do Atomicity and Isolation work in PostgreSQL?

How does cursor-based pagination work? What are the advantages and disadvantages compared to LIMIT/OFFSET?

What is Saga and Transactional Outbox? Why are distributed transactions needed?

If there is a table with JOINs and an OFFSET is needed — how to optimize?

What are covering indexes and how do they help?

Why did you switch to cursor pagination? What is the problem with LIMIT/OFFSET?

What can be done besides using a cursor if you don't want to use it?

How do you receive a task and push it through the development cycle?

How does MVCC work in PostgreSQL? Why is versioning needed?

How to implement pagination in PostgreSQL without Elasticsearch?

Did you use AI only for testing and documentation, or did you write something serious from scratch?

Why use Redis for deduplication in Kafka?

How do you customize AI tools for yourself?

Why write to the Outbox table if the data already exists in the main table? Why not read WAL directly?.

What are the isolation levels in PostgreSQL? Is Read Uncommitted available?

Tell us about your experience, what have you been doing lately?

How do you see your work considering that AI takes on some tasks?

What did you use besides Kafka? What are the pros and cons of Kafka?