Knowledge Base

Explain how constant expressions (`const expressions`) work in Rust, when they are evaluated, and provide an example of practical usage where the compiler computes values at compile time.

ProgrammingAutomation, Embedded and System Developer

How to work with arrays and array-like structures in SQL for storing and analyzing multiple values in a single cell, and when is such an approach justified?

ProgrammingFullstack Developer

How does nesting anonymous structures (struct embedding) work in Go and how does embedding differ from a regular struct field?

ProgrammingBackend Developer

What is ARC in Swift? How to avoid retain cycles when working with closures and delegates?

ProgrammingiOS Developer

How are different scopes implemented in Perl, and how to properly use local and global variables in complex scripts?

ProgrammingBackend Perl Developer

Explain how the visibility modifiers work for fields and methods of structures in Rust, as well as the peculiarities of visibility matching of nested structures?

ProgrammingBackend Developer

What is the role of a business analyst in automating routine business processes, and what are the main challenges of such automation?

Business AnalysisBusiness Analyst

What is Unsafe Rust, why is it needed, what are its rules, and how to properly use unsafe blocks to minimize risks?

ProgrammingSystems Programming Engineer / Rust Senior Developer

How to implement reliable error handling and logging in SQL procedures to quickly detect and analyze failures during business logic execution?

ProgrammingSQL Developer

Tell us about the features of working with concurrent collections (e.g., sync.Map) in Go. When and why should you use sync.Map instead of a regular map?

ProgrammingBackend разработчик

How are asynchronous programming and Future working in Rust? What are the unique features of the async/await implementation and how does it differ from similar mechanisms in other languages?

ProgrammingSystem Programmer

How does a system analyst work through error handling scenarios and exceptional situations in distributed systems?

Business AnalysisSystem Analyst, Enterprise

What is type erasure in Swift, why is it needed, and how to properly implement it in practice?

ProgrammingiOS Developer, Middle/Senior

Tell us about the implementation and use of the Result structure in Rust. What are its advantages, how does it eliminate the unsafe practices common in other languages, and how to correctly handle errors using Result?

ProgrammingBackend Developer

What are key-paths in Swift? How to use WritableKeyPath and why are they needed, what problems do they solve, what pitfalls exist when working with the KeyPath API?

ProgrammingiOS Developer

Explain the rules and nuances of declaring and initializing variables in C, including auto-initialization for different storage areas. How do you distinguish between definition and declaration, and why is it important?

ProgrammingC Developer

Describe the process of ensuring repeatability and determinism in automatic tests: history of the issue, main problems, their solutions.

Automated Testing (IT)Automation QA Engineer

What happens when passing values through a channel in Go: how is copying done, which types are passed by value, how can you accidentally get a race condition when passing complex structures or pointers?

ProgrammingMiddle Backend Go Developer

How to implement a class hierarchy with inheritance and polymorphism in Visual Basic? Describe how to properly use virtual methods (Overridable/Overrides), and provide a code example with a base and derived class.

ProgrammingVB.NET Developer

Explain the differences between the UPDATE, MERGE, and INSERT ... ON DUPLICATE KEY UPDATE commands in SQL. In which cases is each approach preferable, and how do these tools affect performance and data integrity?

ProgrammingBackend Developer
...
Showing 1 – 20 of 1980