A full-stack social media in Nextjs, PostgreSQl & Tailwind CSS
Anas Ahmed
Like this project
Posted Jul 25, 2025
A scalable and modern social media application that allows users to create accounts, follow others, view personalized feeds, and interact in real time
Likes
0
Views
0
Timeline
Apr 25, 2025 - Jun 11, 2025
🧑🤝🧑 Full-Stack Social Media Platform
Built with Next.js, TypeScript, Neon PostgreSQL, Cloudinary, and Tailwind CSS
A scalable and modern social media application that allows users to create accounts, follow others, view personalized feeds, and interact in real time — all with optimized database queries and clean architecture.
🔧 Key Features:
🧵 User Feeds: Personalized timelines based on followed users
🔍 Suggestions Engine: Shows users you don’t follow (via SQL filtering logic)
📱 Fully Responsive: Optimized layout for mobile, tablet, and desktop
🛡️ Authentication: Secure sign-in with sessions using NextAuth and middleware protection
📱Post: Video and Photos can be post as well as Links for affiliate marketing
📄 D ynamic Routing: Clean URLs with server-side logic for SEO
⚙️ PostgreSQL Optimization: Uses Neon for serverless PostgreSQL with efficient joins and pagination
🌐 Region-aware Features (Optional): Designed to support IP/user-agent based personalization
🚀 Fast & Scalable: Built with SSR, ISR (if needed), and server actions for seamless UX
🛠️ Tech Stack:
Next.js 15 (App Router)
TypeScript
Tailwind CSS
Neon (PostgreSQL)
Prisma ORM
NextAuth.js
Zod + Middleware for secure API validation
Vercel for hosting & edge performance
💡 What I Learned:
Advanced SQL query optimization and pagination
Middleware-based route protection
Session handling with server + client awareness
Building modular, reusable full-stack features