$ blog / tag
#databases
17 posts
-
A Database Connection Is Just Five Coordinates →
-
The MySQL CLI: Four Ways to Feed Inline SQL →
-
The MySQL CLI: Remote Connection and Flags →
-
One-Shot Query vs Interactive REPL: DB CLIs Fork on One Flag →
-
Reaching a Remote DB From Your Laptop: One Mental Model →
-
sqlit: a Keyboard-Only DBeaver, and the Whole Model on One Page →
-
The Connection URI Is Canonical; Flags Are It Decomposed →
-
Two Tunnels to a Remote DB: Cloud SQL Auth Proxy vs kubectl port-forward →
-
ClickHouse Data Types: The Set You'll Actually Hit →
-
count(*) vs count(col): It Comes Down to NULL →
-
Cross-Engine Query Exercises: Test Yourself (With Answers) →
-
One Operation, Many Engines: A Cross-Engine Query Mental Model →
-
LIKE vs ILIKE: Substring Search (and Case) Across SQL Engines →
-
From SQL to MongoDB: Operators and Vocabulary, Mapped →
-
The Portable SQL Core: The 80% That Runs Anywhere →
-
Spark SQL Data Types: Primitives, Nested, and struct vs map →
-
A Mutex Gives You ACID's 'I', and Nothing Else →