Cybersecurity / InfoSec

How to organize data storage if we need to know the time in the user's local time zone?

Построить оптимальный индекс для SELECT * FROM employee WHERE sex = 'm' AND salary > 300000 AND age = 20 ORDER BY created_at

How do goroutines differ from threads?

Tell about a memory leak case you fixed.

How did your releases happen? What did the process look like technically?

How many goroutines make sense to create for CPU-bound tasks? And for IO-bound?

If an application is running in multiple instances and traffic switches between them — how does this affect the cache?

How to prevent overload of external services during microservice interaction? How to limit the number of outgoing requests at the code level?

Condition There are 3 entities - user, chat, message • User has a name and registration date • Chat has a name and creation date • Message has text, author, and creation date • A user can be in multiple chats simultaneously • A message must belong to a chat, and a message cannot belong to more than one chat at the same time • Describe the domain in the form of tables.

Why did you choose the BIGINT type for ID? Have you heard of the SERIAL type?

Briefly tell about your experience, any interesting cases.

There are 3 entities - user, chat, message • User has a name and registration date • Chat has a name and creation date • Message has text, author, and creation date • A user can be in multiple chats simultaneously • A message must belong to a chat, and a message cannot belong to more than one chat at the same time • Describe the domain in the form of tables -- Select all chats of user Vasya in the format (chat_id, chat_name)

How did you break down the transition from Node.js to Go into stages?

How do you monitor the application's status? What observability stack do you use?