Tag: #sql
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 11 posts
SQL Injection and Parameter Binding — The Places That Still Break When You Use an ORM
The first thing people search for as a defense against SQL injection is an escaping function, but the right answer is parameter binding. Escaping is an attempt to make a value safe inside a string literal, while binding
2026-07-26 · 16 min read #security#sql#database#orm#pythonDuckDB in Practice — The Era of Embedded Analytics That Ends on Your Laptop
Why is DuckDB, often called the SQLite of OLAP, so loved? We start from the architecture and cover direct Parquet querying, hands-on examples of window functions, PIVOT, and ASOF JOIN, zero-copy integration with pandas,
2026-06-12 · 14 min read #duckdb#database#olap#analytics#parquetThe Complete Guide to Flyway -- Automating Database Migrations
A comprehensive guide to automating database migrations with Flyway. Covers installation, configuration, version control, CI/CD integration, and team collaboration strategies.
2026-04-12 · 14 min read #database#flyway#migration#sql#devopsThe Complete Guide to Database Fundamentals — SQL, Normalization, Indexes, Transactions, NoSQL
Everything about databases from SQL basics to normalization, index internals (B-Tree), transactions (ACID), NoSQL selection criteria, and query optimization.
2026-04-12 · 17 min read #database#sql#nosql#postgresql#mongodbSQL Mastery 2025: Developer Interview SQL — From JOINs to Window Functions and Query Optimization
Everything about SQL interviews! 7 types of JOINs, Window Functions (ROWNUMBER/RANK/LAG/LEAD), Subquery vs CTE, Index internals (B-Tree/Hash/GIN), EXPLAIN ANALYZE, Transaction Isolation Levels, and 30 practice problems.
2026-03-23 · 30 min read #sql#database#join#window-function#indexingSnowflake Data Engineer Career Guide: Mastering the Cloud Data Warehouse King
A complete analysis of the Snowflake Data Engineer role. Snowflake architecture (compute-storage separation), Snowpark, Cortex AI, Iceberg Tables, dbt integration, streaming (Snowpipe), cost optimization — 20 interview q
2026-03-23 · 24 min read #snowflake#data-engineering#data-warehouse#sql#dbtN+1 Problem Deep Dive — The Silent Performance Killer in ORMs
What the N+1 problem is, why it is dangerous, how to find it, and how to fix it. A complete guide with practical code covering solutions across all ORMs including Django, SQLAlchemy, JPA/Hibernate, Prisma, and ActiveReco
2026-03-02 · 10 min read #database#n-plus-1#orm#django#sqlalchemySQL Practical Cheatsheet — Complete Reference for Everyday Commands
From SELECT, UPDATE, INSERT, DELETE to subqueries, window functions, CTEs, index strategies, and execution plan analysis. All the SQL patterns you use daily in one place. Copy and use right away.
2026-03-02 · 36 min read #database#sql#mysql#postgresql#selectPostgreSQL Performance Tuning Practical Guide — Query Optimization, Index Strategy, EXPLAIN Analysis
A hands-on guide to the core of PostgreSQL performance tuning. Covers how to read EXPLAIN output, index strategies, query optimization patterns, and configuration tuning with practical code examples you can apply immedia
2026-03-02 · 11 min read #database#postgresql#performance#sql#indexingMySQL SQL Basics (SELECT, INSERT, DELETE, UPDATE) Usage
Learn how to use SQL (SELECT, INSERT, DELETE, UPDATE) in MySQL.
2023-01-01 · 2 min read #mysql#sqlApache Hive Query Example (MovieLens)
Learn how to use Apache Hive queries with the MovieLens dataset
2022-11-24 · 3 min read #hadoop#hive#sql