A full-stack social media in Nextjs, PostgreSQl & 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.

🧵 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

Zod + Middleware for secure API validation

Vercel for hosting & edge performance

Advanced SQL query optimization and pagination

Middleware-based route protection

Session handling with server + client awareness

Building modular, reusable full-stack features