Hey Nikhil, thanks for reading. That's a good callout. However, for most scenarios, you' want to generate an ID yourself instead of relying on the database sequence, in which case it would be deterministically available in the app memory before you write the record, say a UUID or better ksuid. …

The SQL community is fairly divided on what a “null” means for a column that is a part of a unique index key. MySQL allows it, while some such as SQL Server outright reject it. …

Use Case Analysis Assume you have a use case, where there’s an input of N numbers from the user and you need to fetch the results of an expensive mathematical function f(x) computed on those numbers and return any first K that finish first. Further, the logic of computing the result of the…

Uber engineering blogs are a goldmine that provide solid insights into their architectures. There’s no doubt. Like all big tech firms, they take great pride in the quality of their content. However, there’s something off about how the page is structured. …

Pull request creation, review, comment redressal, re-review and LGTM process carve out a significant chunk of a developer’s bandwidth. There’s no denying the importance of this process. However, this can take time. Let’s discuss how we can reduce the turnaround for the entire process. For this article, let developer be…

We’ve all been there. For our pull requests (PRs), there’s this. Hoping they safely make it through the barbaric eyes of a senior developer. Hoping that we do not get nit picked on some “code” aspects by a pedant. Hoping that we are only judged by the functional completeness of the…

Debezium is a wonderful piece of technology. You can easily start a Debezium connector having followed the basic guide and lo and behold, you have events! However, problems starts to appear when the environment around the initial happy path configuration changes which then breaks your connectors and the downstream consumers. …

This is a story about how I leveraged some of the Python’s lesser known capabilities to my advantage in solving a regular expression problem in a rather esoteric way (as we’ll see) on a popular coding platform called Hackerrank. It’s been 5 years since and I think I can finally…

Explore the various ways to tackle unoptimised MySQL queries. Many times you’d like to profile the query that is being executed. This could be due to a myriad of reasons. Current execution is latent and we need to optimize. To figure out unused indexes or to determine if indexes are…