Apr 8 · 13 min read · The Fundamental Difference: OLAP Over History vs Streaming Over Live Data Before comparing specific features, it is worth being precise about what problem each database solves, because this choice is ultimately about use case fit rather than which da...
Join discussion
Feb 2 · 36 min read · যারা সবকিছু পরিপাটি করে রাখে, তারা মূলত খোঁজাখুঁজির কষ্ট করতে চায় না বলেই এমনটা করে। - German Proverb মৌলিকভাবে একটি ডাটাবেসকে দুটি কাজ নিখুঁতভাবে করতে হয়: ১. ডেটা স্টোর করা: যখন আপনি ডাটাবেসকে কোনো তথ্য দেবেন, তখন সেটি যেন সুরক্ষিতভাবে জমা রাখে। ২....
Join discussion
Jul 29, 2025 · 2 min read · 🚨 The Challenge:We had to replace millions of rows daily, covering data from the past 60 days, and run aggregations on top. Initially, we explored: ✅ AggregatingMergeTree: Worked well only with incremental data, but not suited for full data replace...
Join discussionJul 21, 2025 · 2 min read · OLTP means Online Transaction Processing and OLAP means Online Analytical Processing. OLTP (Online Transaction Processing) OLTP databases supports the day to day transactions. It’s a scenario database for storing day to day sales, people coming in, l...
Join discussion
Jun 14, 2025 · 5 min read · In today’s data-driven world, the demand for high-performance, low-latency analytics systems has grown exponentially. Traditional databases often crumble under the weight of massive data volumes. Enter ClickHouse: an open-source, high-performance, co...
Join discussionJun 1, 2025 · 3 min read · Hoy vamos a hablar de algo un poco más amplio: los motores de bases de datos. A grandes rasgos, los podemos dividir en dos grandes categorías: OLTP (procesamiento de transacciones online): los que están optimizados para procesar transacciones. OLAP...
Join discussion
May 4, 2025 · 3 min read · Introduction Hello everyone! Today, I am going to show you how you can create a table in ClickHouse from a CSV using Python. We use WSL to run ClickHouse on Windows. If you want to know how to run ClickHouse on Windows locally, you can check this art...
Join discussion
Mar 7, 2025 · 3 min read · Back in the days when businesses needed systems to handle transactional data such as purchases and sales, they began using online transactional processes. When transactions occur online, they are highly concurrent, meaning thousands of simultaneous t...
Join discussionDec 9, 2024 · 11 min read · In his Druid Summit 2024 keynote, Eric Tschetter emphasized Druid’s potential for behavioral analytics. This article builds on Eric’s keynote, offering insights and strategies for designing analytics that prioritise behaviour. Apache Druid is an esta...
Join discussion
Oct 4, 2024 · 5 min read · Introduction The success of a digital product heavily depends on providing users with efficient support and guidance. One of the key tools for achieving this is a well-structured help center that users can navigate to find solutions to their problems...
Join discussion
