• Calculate number of nodes in a linear network using message passing

    calendar Jan 20, 2024 · 4 min read · Interview  ·
    Share on: copy

    Problem In a connected network consisting of N nodes, each node is connected to either one or two neighbors, forming a line topology. The task is to develop a program that runs on each node, calculating the total number of nodes in the network. Each node is aware of its neighboring nodes and can exchange messages with …


    Read More

  • Factorial Growth of Subqueries When Using Nested WITH Clauses in ClickHouse

    calendar Jan 12, 2024 · 5 min read · Databases  ·
    Share on: copy

    ClickHouse is a popular OLAP database. It speaks SQL and earns the reputation of "fast and resource efficient". But the support of SQL comes with surprises if not careful. In this blog, I show that a simple query of nested WITH clauses in ClickHouse generates factorial number of subqueries. The simple query …


    Read More

  • Gotchas of defer in Go

    calendar Sep 10, 2023 · 6 min read · Go  ·
    Share on: copy

    A defer statement invokes a function just before the surrounding function returns. Multiple defers within a function are executed in reverse order of their calls, following the Last In First Out (LIFO) principle. Defer is commonly used to ensure resource cleanup, regardless of the function's success or failure. For …


    Read More