Can you give examples when using foreign keys is not advisable?
Middle
225
Golang
8386
379
Look at the database schema above — what can be added, or is everything fine?
Middle
223
Can we get a link/address to a specific map element?
Middle
212
How would you solve the problem of loading a million users into memory (risk of memory and delay)?
Middle
207
-- Display all books and their authors/co-authors in a simple tabular format. -- Example: -- book_name | author_name -- --------------------|------------- -- Master and Margarita | Igor -- Eugene Onegin | Ivan
Middle
197
-- List authors who have no books.
Middle
196
Does the variable capture problem in a goroutine depend on the Go version?
Middle
194
We want to get only active users, but what is wrong with the isActive filter?
Middle
188
What can you say about the output of this program?
Middle
186
-- List all authors and the number of their books. -- Example: -- author_name | book_count --------------------------- -- Igor | 2 -- Ivan | 1 -- List authors who have written more than 2 books.
Middle
182
package maptask import "fmt" import "time" func Foo() { data := make(map[int]bool) for i := 0; i < 10; i++ { go func() { data[i] = true }() } time.Sleep(time.Second * 1) for k, v := range data { fmt.Println(k, v) } }
Middle
179
Why is a regular map in Go unsafe for concurrent writes?
Middle
179
What index should we use if we want to search by book title?
Middle
174
What are maps in Go?
Middle
173
What if you need to search by part of the book's title (substring)?
Middle
172
Where would you start implementing pagination in this method?
Middle
165
What are other ways to protect a map from concurrent access besides mutex?
Middle
154
Maybe you can suggest something else besides Mutex and sync.Map for record protection?
Middle
152
What is the name of the WITH ... AS (...) construction on line 84 of the query?
Middle
146
-- List all books and their authors/co-authors in a simple tabular form. -- Example: -- book_name | author_name -- --------------------|-------------- -- Master and Margarita | Igor -- Eugene Onegin | Ivan -- List all authors and the number of their books. -- Example: -- author_name | book_count -- ------------|----------- -- Igor | 2 -- Ivan | 1
Middle
144