All posts tagged with "database"
A comprehensive guide to data source patterns from Martin Fowler's PoEAA: Active Record for simple domains, Data Mapper for complex domains, Table Data Gateway and Row Data Gateway for explicit data access. Includes code examples in TypeScript and Java.
A deep dive into Redis source code to understand how RDB snapshots and AOF logging keep your data safe. Learn about fork(), copy-on-write, fsync strategies, and the AOF rewrite dual-buffer trick.
Explore how Redis actually works by reading its C source code on GitHub. Learn about robj, incremental rehashing, the event loop, integer encoding, and adaptive list storage — the real internals that make Redis so fast.
Master SQL fundamentals from scratch. Learn SELECT queries, filtering, aggregation, all JOIN types with diagrams, subqueries, and the actual execution order SQL uses — with real-world examples throughout.
Complete SQL and NoSQL learning roadmap for developers. Master SQL fundamentals, advanced queries, PostgreSQL, MongoDB, Redis, indexing, transactions, schema design, and when to choose SQL vs NoSQL.
Master database access in TypeScript with Prisma, Drizzle ORM, and raw SQL. Learn schema design, migrations, relations, query optimization, N+1 prevention, transactions, and connection pooling for production apps.
Master JPA performance optimization in Spring Boot. Learn to detect and fix N+1 query problems, optimize fetch strategies, use projections, batch operations, and write efficient JPQL and native queries.
Master database schema design from scratch. Learn normalization (1NF-3NF), relationships, naming conventions, soft deletes, UUIDs vs auto-increment, and design real-world schemas.
Master relational database fundamentals. Learn how SQL queries execute internally, ACID properties, transactions, isolation levels, data types, constraints, and when to choose PostgreSQL vs MySQL vs SQLite.
Master Redis fundamentals from scratch. Learn data structures, commands, persistence, pub/sub, and real-world use cases. Perfect foundation before implementing Redis caching in your applications.