Author: A

A foreign key (FK) can refer to a primary key in the same table in MySQL. This is known as a self-referential foreign key or a recursive foreign key. It allows you to create hierarchical relationships within the same table, which can be useful for representing structures like organizational charts, bill of materials, or nested… Continue reading Relation DB – Foreign key →

Path Parameter vs. Request Body Parameter Path Parameter: Use Case: Typically, path parameters are used to identify specific resources. For instance, if you want to add a child node to a specific parent node, using the parent’s node_id as a path parameter (e.g., POST /nodes/{parent_id}/children) clearly indicates the relationship and hierarchy. Best Practice: This aligns with REST principles… Continue reading Basic – API Request →

Uber - https://www.uber.com/en-IN/blog/reliable-reprocessing/https://www.uber.com/en-IN/blog/kafka-async-queuing-with-consumer-proxy/ Confluent - https://www.confluent.io/blog/introducing-confluent-parallel-message-processing-client/https://github.com/confluentinc/parallel-consumer?tab=readme-ov-file 21 min in video to understand offset management in kafka parallel https://play.vidyard.com/5MLb1Xh7joEQ7phxPxiyPK.jpg

XML-RPC is an example of an RPC system that is simple and uses XML for encoding, but it can be inefficient compared to modern RPC systems like gRPC that use more compact binary serialization formats like Protobuf.Thrift (Apache Thrift): A flexible cross-language RPC framework that supports a variety of serialization formats (including both text and… Continue reading RPCs over HTTP →

The JSON and binary representation of the string "John" would store the actual characters as 4 bytes (1 byte per character), as each character like J, o, h, n is typically represented in ASCII or UTF-8 encoding, which takes 1 byte per character. The key distinction between JSON and binary representation in this case lies… Continue reading storing data as binary →