Sobes.tech

Message delivery semantics between microservices.

Middle+
159

The application with the database works in one environment, but degrades in another. Why?

Middle+
156

How to fix it so that it displays 0-9?

Middle+
154

How do transactions work with versions in MVCC?

Middle+
153

How were access rights checked?

Middle+
153

Collection of functions, loop 0-9, add lambdas capturing i, call all. What will it output?

Middle+
152

Redis is unavailable, multiple instances — how to ensure cache consistency?

Middle+
150

From the perspective of metric visualization — custom or standard solution?

Middle+
149

Why is there no read uncommitted in PostgreSQL?

Middle+
147

How is authorization implemented?

Middle+
145

How are strings stored in .NET?

Middle+
142

Tell about your experience with Rider, Docker, and development tools.

Middle+
141

Used LINQ? What is materialization?

Middle+
140

Singleton with a lock object, static field instance, private constructor, and GetInstance method. What are the issues?

Middle+
139

What do you suggest to a developer to improve testability?

Middle+
136

Дана таблица: create table bank_users ( id bigint generated by default as identity primary key, status int, employee_number varchar(8) unique, first_name varchar(100) not null, last_name varchar(100) not null, middle_name varchar(100) default null, email varchar(100) not null unique, created_at_date_time timestamptz ); create index ix_created_at_date_time_status on bank_users (created_at_date_time, status); Есть запрос: explain (costs off, verbose) select employee_number, first_name, last_name from bank_users where status = 2 order by created_at_date_time; Возвращает: Sort Output: employee_number, first_name, last_name, created_at_date_time Sort Key: bank_users.created_at_date_time -> Seq Scan on bank_users Output: employee_number, first_name, last_name, created_at_date_time Filter: (bank_users.status = 2) Что можно сказать об оптимальности плана запроса?

Middle+
135

Have you used SelectMany?

Middle+
134
/3