Hello everyone! Welcome to another Interesting Tech Update on Analytics! Recently, I came across an interesting update about  chDB in the  TDLR Newsletter, which motivated me to explore it further. Until now, I’ve mostly worked with server‑based  SQL engines such as  PostgreSQL, MySQL, and SQL Server. I’ve also used serverless  SQL engines on many challenge platforms like DataLemur, LeetCode, and HackerRank. These platforms typically use in‑process  SQL engines, which don’t

Geospatial Data in modern digital systems Geospatial data has become a cornerstone of modern digital systems. From ride‑sharing apps and logistics platforms to urban planning tools and environmental monitoring systems, location‑aware data powers decisions across industries. Geospatial data represents objects, events, or phenomena that have a location on Earth. This location can be expressed in many ways: Points  (e.g., a store location) Lines  (e.g., a road or river) Polygon

Learn how PostgreSQL window functions enable advanced data analytics without collapsing rows. This blog uses the Titanic dataset to demonstrate ranking, running totals, segmentation, and trend analysis using real-world SQL examples.

From NON - IT to Data Analytics... Could This Be Your Story Too? Photo by Deng Xiang  on Unsplash Have you ever sat at your desk and thought, “I’m doing my job well… but is this really what I want to do long term?” If yes, trust me you’re not alone. I was working in the financial sector , handling daily operations, transactions, and reports. Everything was stable. Everything was familiar. But somewhere along the way, I started noticing something interesting, every decision wa