Relational Modeling, B-Tree Indexing, EXPLAIN QUERY PLAN & Joins
Explore CodingCat.dev hands-on courses, video lessons, podcast episodes, and technical deep-dive blog posts covering SQL: Relational Modeling, B-Tree Indexing, EXPLAIN QUERY PLAN & Joins.
Official SQL Brand Lockup (16 Blog Posts · 2 Episodes)
Build stateful, long-running AI agents and resilient multi-step workflows using the Cloudflare Agents SDK, Durable Objects with embedded SQLite, WebSockets hibernation, and Workflows.
Master relational schema normalization, Primary/Foreign keys, INNER/LEFT JOINs, B-Tree composite indexes, ACID transactions, and type-safe Drizzle ORM on Cloudflare D1.
Ship sub-10ms full-stack TypeScript web applications at the edge using Astro 7 Server Islands, Cloudflare Workers V8 Isolates, Cloudflare D1 SQLite, and self-hosted Better-Auth.
Alex Patterson's hands-on web engineering breakdown of "Realtime PostgreSQL: From Data Connect to SQL Connect" (2026-04-29). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.
Alex Patterson's hands-on web engineering breakdown of "Firestore levels up: Bringing the power of search and JOINs to NoSQL" (2026-04-27). Learn how to wire up Firebase, Google Cloud, Web Dev, AI in production web apps.
Alex Patterson's hands-on web engineering breakdown of "Writing SQL in SQL Connect" (2026-03-24). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.
Alex Patterson's hands-on web engineering breakdown of "Introducing no-cost trials for Data Connect" (2026-03-12). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.
Alex Patterson's hands-on web engineering breakdown of "Data Connect: Event Triggers and Generated Admin SDKs" (2025-11-17). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.
Explore Firebase Data Connect to enhance your app with powerful SQL capabilities, bridging the gap between real-time data and managing databases.
Alex Patterson's hands-on web engineering breakdown of "Transactions Updates for Data Connect" (2025-06-05). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.
Alex Patterson's hands-on web engineering breakdown of "Server Value Expressions for Data Connect" (2025-06-05). Learn how to wire up Firebase, Google Cloud, Web Dev, SQL in production web apps.
Firebase SQL with Data Connect how to use semantic searches with vector embeddings.
James Q Quick teaches us about how Planetscale's ability to infinitely scale SQL horizontally at the push of a button.
