MySQL tutorial - IT technology blog

Connecting MySQL in Node.js with mysql2: Connection Pooling, Prepared Statements, and Transactions

A guide to connecting MySQL in Node.js with the mysql2 library the right way, avoiding the common mistakes junior developers make. Learn how to use Connection Pooling for performance optimization, Prepared Statements to block SQL Injection, and Transactions to ensure data integrity when operating across multiple tables simultaneously.
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.