Keep learning
All Tutorials
Embedded Databases
DuckDB vs SQLite
A practical comparison of DuckDB and SQLite for AI, ML, data analytics, Python workflows, local storage, CSV analysis, and feature engineering.
14 min readJune 10, 2026
SQL Fundamentals
SQL Window Functions Explained
A SQL window function calculates a value for each row without collapsing rows. Learn OVER, PARTITION BY, ROW_NUMBER, RANK, LAG, LEAD and running totals with worked examples.
16 min readOctober 15, 2026