Databases for web applications
Web Technologies · Engineering
Study notes
Blog app: PostgreSQL stores users/posts (relations, JOINs); Redis caches sessions (fast); S3 images. ORM (Prisma): await prisma.post.create({data}). Index post.authorId for fast queries. Migrations version schema. Choose SQL for relations, NoSQL for scale/flexibility.