Database tutorial - IT technology blog

Apache Pinot: A Step-by-Step Guide to Setting Up a Real-Time OLAP Database for Sub-100ms Analytics Dashboards

Apache Pinot is a distributed OLAP datastore that enables analytics queries across billions of rows with sub-100ms latency, used by LinkedIn and Uber for user-facing dashboards. This guide walks you through step-by-step installation with Docker, configuring schemas and star-tree indexes, loading CSV data, and monitoring cluster health.
Database tutorial - IT technology blog

YugabyteDB: A Guide to Setting Up PostgreSQL-Compatible Distributed SQL with Auto-Sharding and Automatic Fault Tolerance

YugabyteDB is a PostgreSQL-compatible distributed SQL database with auto-sharding, automatic fault tolerance, and multi-region deployment — no changes to your SQL or ORM required. This guide covers installation from a single-node Docker setup to a real 3-node cluster, along with practical tips for working with distributed databases.
Virtualization tutorial - IT technology blog

How to Install and Use Lima on macOS: Create Lightweight Linux VMs with QEMU and VZ Framework as a Free Docker Desktop Alternative

Lima is an open-source tool for creating Linux virtual machines on macOS using QEMU or Apple's VZ Framework, replacing Docker Desktop completely for free. This article compares available solutions, walks through Lima installation, Docker integration, and managing multiple VMs from the command line.
Monitoring tutorial - IT technology blog

How to Install and Configure OpenObserve: A Next-Generation Logs, Metrics, and Traces Solution to Replace ELK Stack with 140x Lower Storage Costs

OpenObserve is a Rust-based observability solution that stores logs, metrics, and traces at up to 140x lower cost than ELK Stack, thanks to Parquet format and efficient data compression. This post shares hands-on experience installing OpenObserve with Docker, configuring Fluent Bit for log collection, querying with SQL, and setting up Alerts to avoid alert fatigue.