About MindsDB Stress Test
I found this quest on Quira with MindsDB Knowledge Base (KB) as the topic of the quest. I have been interested about MindsDB for some time but with quest and prize as cherry on top, why not.
Idea
I need to find idea before starting to write the app and then decided to create hackathon aggregator web app that includes a chatbot to showcase capability of semantic search using MindsDB KB. Why hackathon aggregator ? Simply because I love to participate in hackathon.
Development
I started using vibe coding, in order to help me accelerate development especially on creation of front-end. To interact with MindsDB, I don't rely on MindsDB SDK but solely rely on mysql SDK in Node.js, in this case using mysql2 library. For IDE, I use cursor.
Challenge
While doing development and learning at same time, I found issues that perhaps could be easily avoided if I use MindsDB SDK, as the issue seems like happening only if I use mysql client to access MindsDB using its MySQL API. I'll write more detail about the issue and submit as bugs on MindsDB repo.
Repository
Please find the repository of the app here.
Demo Video
It's included in the github repo. Please watch it there.
Result
Roughly 2 days doing vibe coding and learning by doing, I can create a hackathon aggregator web app with following feature:
🔍 Smart Search & Filtering: Find hackathons by title, description, tags, status, and type
🤖 AI-Powered Chatbot: Interactive assistant that helps users find relevant hackathons
🎯 Personalized Recommendations: AI-driven suggestions based on user questions
📱 Responsive Design: Beautiful, modern UI that works on all devices
🔄 Multi-Source Integration: Aggregates data from Devpost, Topcoder, and Quira
⚡ Real-time Updates: Hackathon data fetching and updates
🔐 Admin Dashboard: Manage data sources
Recommendation
- Try to use MindsDB SDK to do development on MindsDB instead of
mysqlclient. While I have not tested it, theoretically the development should be smoother with native SDK. - Accelerate your development with AI (vibe coding).
- Understand how AI Model and Agent work inside MindsDB. There'll be no need to use another AI Agent framework, let model and agent work from your SQL statement. Without proper understanding, I originally would like to use another agent framework such as langgraph.