Message delivery semantics between microservices.
C#
The application with the database works in one environment, but degrades in another. Why?
How to fix it so that it displays 0-9?
How do transactions work with versions in MVCC?
How were access rights checked?
Collection of functions, loop 0-9, add lambdas capturing i, call all. What will it output?
Redis is unavailable, multiple instances — how to ensure cache consistency?
From the perspective of metric visualization — custom or standard solution?
Why is there no read uncommitted in PostgreSQL?
How is authorization implemented?
How are strings stored in .NET?
Do you know ref struct?
Tell about your experience with Rider, Docker, and development tools.
Used LINQ? What is materialization?
Singleton with a lock object, static field instance, private constructor, and GetInstance method. What are the issues?
What do you suggest to a developer to improve testability?
Дана таблица: 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) Что можно сказать об оптимальности плана запроса?
Have you used SelectMany?
Database normalization.
Do you know ArrayPool?