FeedbackAggregator RealTime Customer Feedback Platform

FeedbackAggregator helps small businesses understand customer feedback in real time. It analyzes sentiment, highlights trends, and sends alerts so owners can fix issues early and keep customers happy.

Comment

I## About FeedbackAggregator

FeedbackAggregator started from a simple observation. Customer feedback is usually spread across different places—Google reviews, contact forms, emails, and social media. For a small business, keeping track of all of that takes time, and it's easy to miss recurring issues until customers have already had a bad experience.

I wanted to build a single place where feedback could be collected, organized, and reviewed without having to jump between different platforms. The goal wasn't to build another review site, but to make it easier to spot trends and understand what customers are actually saying.

How I Built It

The application is built with:

  • Next.js
  • TypeScript
  • PostgreSQL
  • AWS RDS
  • Server Actions
  • Tailwind CSS

I started by building everything locally with PostgreSQL before moving the database to AWS RDS. As the project grew, I added:

  • User authentication
  • Business workspaces
  • Manual feedback collection
  • Sentiment tracking
  • Dashboards and reporting
  • Historical feedback trends

For this MVP, sentiment analysis uses a local fallback implementation. The application is already structured so that it can later be connected to AWS Lambda and Amazon Bedrock without changing the rest of the application.

Challenges I Faced

The hardest part of the project wasn't building new features—it was getting everything to work reliably after moving from a local environment to the cloud.

Migrating from a local PostgreSQL database to AWS RDS introduced several problems that I had to work through, including:

  • Migrating existing user and feedback data
  • Configuring SSL connections
  • Managing environment variables across local development and production
  • Synchronizing PostgreSQL sequences after migration
  • Debugging authentication issues after moving databases

I also ran into routing problems, duplicate primary key errors, session issues, and deployment bugs that only appeared outside my local machine. Solving those problems ended up teaching me as much as building the features themselves.

What I Learned

This project reinforced something I had only partially appreciated before: writing features is only part of software development.

I learned a lot about:

  • Database migrations
  • Authentication and session management
  • PostgreSQL sequence management
  • Deploying applications with Vercel
  • Connecting applications to AWS RDS
  • Debugging production issues that don't appear during local development

Several of the most valuable lessons came from tracking down problems that only showed up after deployment.

What's Next

FeedbackAggregator already gives businesses a single place to collect and review customer feedback, but there are still features I'd like to add.

Some of the next improvements include:

  • Integrating AWS Bedrock for AI-powered sentiment analysis
  • Using AWS Lambda for background sentiment processing
  • Supporting additional feedback sources
  • Adding automated notifications and smarter reporting

Building this project gave me hands-on experience with designing, debugging, migrating, and deploying a full-stack application. More importantly, it showed me how much attention to detail is needed to move a project from "it works on my machine" to something that can run in a production environment. nspiratio

Built With

Share this project:

Updates