Sobes.tech

How much load can PostgreSQL withstand?

249

Can you explain what is meant by a Linter tool in the context of code development?

Junior — Middle
248

Transaction: transaction_id uuid identotency_id uuid from_account_id uuid to_account_id uuid amoun decimal status enum transaction_start timestamp transaction_end timestamp payments_create: user_id uuid payment_account_id uuid balance decimal currency varchar(16) status ENUM created_time timestamp update_time timestamp

247

What does the At-Most-Once message processing mode mean and how does it differ from At-Least-Once?

Junior — Middle
247

How can transactions lead to mutual locking in a database?

Junior — Middle
246

What methods can be used to detect data race conditions in a multithreaded environment?

Junior — Middle
245

Can you explain the principle of the Repeatable Read transaction isolation level in databases?

Junior — Middle
245

What is the difference between a goroutine and threads in terms of execution and performance?

Junior — Middle
245

Is absolute message delivery guaranteed in Kafka, and how is it achieved?

Middle — Middle+
244

What is the main role and application of mock objects in testing?

Junior — Middle
244

What tools do you use for debugging and error fixing in code?

Junior — Middle
244

What types of indexing in databases have you used, and for which scenarios were they most effective?

Junior — Middle
244

How can you efficiently launch and manage a large number of goroutines, for example, around 100,000?

242

Can you list the main types of contexts used in programming or system design?

Junior — Middle
240

Can you explain what the context.WithValue function in Go is used for and how it works?

Junior — Middle
237

How does a goroutine interact with the system execution thread in an operating system?

Junior — Middle
236
/7