Embedded / IoT

How to speed up inserting 100 billion records into a database? Currently: generate + insert + commit in a loop for each row.

What is the purpose of partitioning in PostgreSQL?

How was the issue of event ordering in Kafka (ordering) addressed for entity audit trail?

How did you implement pagination for data unloading?

What dependency injection methods are available in Spring? Which is preferred?

Таблица PERSON ID NAME 1 alice 2 john 3 bill 4 mike 5 sara 6 helen 7 steven 8 garry 9 kile 10 liza Таблица PHONE ID PERSON_ID NUMBER [phone] select NAME, NUMBER from PERSON p left join PHONE ph on p.ID=ph.PERSON_ID

How did it work before your optimization? Were there double charges?

How were the records that were not processed (went to the DLQ) tracked?

Why is UPDATE in PostgreSQL essentially a DELETE and INSERT?

Is there a constructor in an abstract class?

Question to the interviewer: Is there a synchronization mechanism between the Lucene index and the main SQL storage? How is consistency addressed?

What are the steps involved in transforming Java code from source to execution?

What Stream API collectors do you know? What does groupingBy return? How does it differ from toMap? How does toMap behave with duplicate keys?

What types of garbage collectors are available in Java?

How to correctly pass context in a goroutine when sending an SMS (two-factor authentication)?

Are you referring to debiting a subscriber’s personal account? Why did this problem occur before your intervention?

What are indexes in PostgreSQL and what types exist?

What else can be used besides Poller for Outbox?

How to get the only element from a List? How to get the only element from a Set if get(0) is not available?

Was the Transactional Outbox pattern used to guarantee message delivery in Kafka?