Tag Archive
Archive for this tag.
Post · January 12, 2023
Learn offset, cursor, and keyset pagination with real-world examples, SQL code, and performance tradeoffs to make better decisions in scalable system design.
Read →Post · January 05, 2023
Learn what Drizzle ORM is, why teams choose it over heavier ORMs, and when a SQL-first, type-safe TypeScript approach is the best fit for your next project.
Read →Post · January 03, 2023
Learn what a database ORM is, how it maps tables to objects, and when it's the right choice. Explore key benefits, common pitfalls, and a clear checklist for deciding between ORM and SQL.
Read →Post · December 29, 2019
Learn database design fundamentals every web developer needs to know. From normalization to indexing strategies, discover how to build scalable databases that perform under pressure.
Read →Post · November 22, 2019
A practical guide to SQL design patterns, common anti-patterns, and performance pitfalls, with concrete examples for engineers who work with relational databases daily.
Post · November 19, 2019
A practical guide to relational database fundamentals: the relational model, ACID, normalization, indexing, and trade-offs, with real code for engineers.
Read →Post · November 18, 2019
A practical SQL beginners guide with real Python examples covering queries, joins, indexes, and transactions-built for engineers who learn by doing.
Read →Post · November 17, 2019
Learn SQL fundamentals through practical examples: queries, joins, indexes, transactions, and normalization - a hands-on guide built for developers who want real understanding.
Post · March 13, 2019
Learn the core concepts of relational databases-tables, keys, normalization, ACID, and indexing-with practical SQL and code examples for engineers.
Read →