InDrive - 2

Актуальность: Q1 2025

Questions

About projects and standard architecture and Go questions; go/stdlib-tooling
Standard Kafka questions; brokers/kafka
Caching, sharding, and load balancing; sql/replication-scaling
Describe the transactional outbox pattern and when to apply it. What other patterns do you know? sql/transactions
Standard database questions (indexes, EXPLAIN ANALYZE, etc.). sql/indexes

Задача: There are DB struct methods: get, set. Write a cache that: `nosql-cache/caching`

on write to DB, after successful DB write -> writes to cache;
on read: first check cache, if no value -> go to DB.

Задача: Design a database for a company that has projects and employees. `go/interfaces`

Description

there is a project, a project has employees; sql/schema-design
one employee can work on many projects; go/interfaces
one project can have many employees. go/interfaces

Write 3 tables and 2 queries

number of employees in each project; sql/general
number of non-dismissible employees working on a project. sql/general