Golang

How can API versioning be implemented? What options do you know?

Through what were your logs collected? What is the name of the agent for Loki?

Tell me about JOIN in SQL. Add a LEFT JOIN of the authors table to the books query, taking only the author's name.

What delivery guarantees can a message broker provide? At most once, at least once, exactly once.

Tell me about soft delete. What is it and why is it needed?

Have you worked with composite indexes?

Tell me about buffered and unbuffered channels. When do we use which? How do they block, and when do they lead to deadlock?

Which HTTP methods can be cached by the browser?

Add pagination to the SELECT query from the books table (50 records per page).

Write a simple SELECT of all columns from the books table.

What do you know about the sync/atomic package?

What can you tell about Mutex?

Are you familiar with partitioning and sharding? What is the difference?

Tell me about transactions in PostgreSQL. What are ACID and isolation levels?