Data Science
What Is DuckDB? In-Process Analytics SQL
DuckDB is an embedded analytical database — SQLite for analytics. Query Parquet, CSV, and Arrow with SQL, no ETL needed.
sql
8 articles tagged with #sql
Web Development
What Is Drizzle ORM? TypeScript SQL Builder
Drizzle ORM is a lightweight, type-safe TypeScript ORM with SQL-like syntax. Schema, queries, migrations, and comparison with Prisma.
Data Science
SQL for Beginners — Query Databases Like a Pro
Learn SQL from scratch — SELECT, JOINs, GROUP BY, window functions, and indexes. Practical examples for PostgreSQL, MySQL, SQLite, and BigQuery.
Data Science
Python Data Libraries Cheat Sheet 2026 — Quick Reference
Quick reference for Python data libraries 2026: Pandas, Polars, DuckDB, NumPy, Plotly. Common operations side-by-side. Bookmark for daily work.
Data Science
dbt Tutorial — Data Engineering for Analysts (2026 Guide)
dbt (data build tool) explained for data analysts: SQL-based transformations, models, tests, documentation. The modern way to build data pipelines.
Data Science
DuckDB vs Pandas — Which to Use for Data Analysis 2026
DuckDB vs Pandas: when to use each, performance benchmarks, SQL vs Python syntax, real examples. DuckDB is faster and handles larger data — should you switch?
Data Science
SQL for Data Science — Essential Queries to Master
Learn the SQL data scientists use daily: SELECT, JOINs, GROUP BY, window functions, CTEs, and date handling, with PostgreSQL examples and common pitfalls.
Data Science
Best Data Science Tools in 2026: An Evidence-Based Stack Comparison
Which data science tools people actually use in 2026, from Python, SQL and pandas to Jupyter and PyTorch, compared with survey data and official documentation.