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.