Skip to content

Databases

You're gonna make a wrong choice first , we all did. Relational databases enforce schemas and ACID guarantees through foreign keys and constraints. NoSQL stores give you flexibility with documents , key-value pairs , and column families — trading strict consistency for horizontal scaling. Every database is a tradeoff wrapped in marketing hype , and picking wrong means migrating production data at 2AM when Burp took a coffee break and your pager just lit up

18 files covering PostgreSQL , MongoDB , Redis , SQLite , and Prisma ORM — all through a security lens where SQL injection , NoSQL injection , and data exposure are the real exam

what you'll find here

  • PostgreSQL (db_01-05) — Install , psql basics , CRUD , indexing strategies , advanced features (window functions , CTEs) , security (RLS , encryption , injection prevention)
  • MongoDB (db_06-09) — Document model , CRUD , aggregation pipeline , indexing , NoSQL injection patterns
  • Redis (db_10-12) — In-memory data structures , caching patterns , pub/sub , security configs
  • SQLite & Prisma (db_13-15) — Embedded database use cases , Prisma schema design , ORM patterns
  • Reference (db_16-17) — Migration strategies , comparison guide , official docs links

prerequisites

Basic programming (JavaScript/Node.js for examples) and a terminal you're not afraid to type in

first topic -> db_00_home.md