Sobes.tech

There are four basic requirements for modern SQL Engines (ACID) — can you name and explain them?

286

Tell me about your experience working with Go and the tasks you faced.

285

Tell me more about Redis: what kind of directories are there, what data is stored there?

280

What are structures in Go and what are they used for?

278

How is garbage collection implemented in Go and in which memory area does it operate?

268

How many processes or threads can be launched by a single program?

262

// numbers from 1 to 10 func main() { done := make(chan struct{}, max_n) for i := 1; i <= max_n; i += batchSize { end := i + batchSize if end > max_n { end = max_n } for j := i; j < end; j++ { go func(n int) { defer func() { done <- struct{}{} }() exit(1) printNumber(n) }(j) } for j := i; j < end; j++ { <-done } } } func printNumber(n int) { time.Sleep(time.Second) fmt.Println(n) }

254

// numbers from 1 to 10 func main() { done := make(chan struct{}, 10) for i:=1; i<=10; i++{ go func(){ defer func() {done<-struct{}{}}() printNumber(n) }() } for i:=1; i<=10; i++{ <-done } } func printNumber(n int) { time.Sleep(time.Second) fmt.Println(n) }

252

What libraries have you used in your project?

252

What is the abbreviation for cost per click called in English?

247

List the main data structures and give examples of their implementation/use in Go (arrays, slices, map/hash table).

245

What do you use to apply migrations?

243

Topic with 3 partitions. Case 1: 2 consumers. Case 2: 5 consumers. How are messages distributed?

241

What exactly did you do with ClickHouse — working with the cluster, replication, table partitioning?

241

Is a table with (id PRIMARY KEY, data JSON) a good index for searching by key in PostgreSQL?

232

What is the difference when comparing asynchronous and multithreading?

231

// Дана строка s. Нужно найти длину самой длинной подстроки без повторяющихся символов. // Примеры: // s = "abcabcbb", ответ: 3 ("abc") // s = "cccccccc", ответ: 1 ("c") // s = "pwwkew", ответ: 3 ("wke") // s = "", ответ: 1 = 0 // Строка s состоит из английских букв, цифр, символов и пробелов func lengthOfLongestSubstring(s string) int { return 0 }

229

What characterizes subscribers in the Pub/Sub pattern?

228

What is the difference between JOIN and UNION?

227
/10