Skip to content

Databases

You're gonna make a wrong choice first , we all did. Relational 08_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 05_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 , 10_advanced features (window functions , CTEs) , 05_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 , 05_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 -> Database HOME