Hey folks, I'm gearing up for my exam project and could really use your input. The goal is to create an application that utilizes both MySQL and MongoDB, allowing users to select between the two databases from a menu. I have to implement advanced features in MySQL, including complex functions, stored procedures, events, triggers, and cursors, and all my SQL code will be saved in a separate file.
I'm hoping for some project ideas that meet these requirements. What technologies do you think I should consider for development? Should I stick to using pure code, or would it be smarter to leverage a framework? I'm comfortable with PHP but am open to exploring other languages if they're better suited for this project. Thanks a ton for any suggestions!
3 Answers
It seems a bit funky to have to use both a relational and NoSQL database for your exam, but I get it. Anyway, since you know PHP pretty well, why not stick with that? It’ll free up time to focus on learning the database management aspects. If you're looking to dive into something new, perhaps consider .NET with a frontend framework—it can give you good exposure. Just keep in mind some courses may not allow ORMs, so check the requirements on that front.
I once worked on a project where we migrated data from MongoDB to MariaDB. We used PHP to handle queries and set up stored procedures for maintenance tasks. In your case, keep it simple—if the project doesn’t need to go online, frameworks might be overkill. You can get a lot done just focusing on the databases directly.
Interesting! Did you find it hard to manage both databases? I’m curious about whether I can write pure code for MySQL and MongoDB as they’re pretty different.
Try thinking about any real-life data scenarios you encounter. You could create an app for budgeting, note-taking, attendance tracking, or a video game character stats calculator. Look around your phone for apps that look easy to build, like a WhatsApp clone, a gallery app, or a contact book. Those could all translate well into a project using both databases.
I can’t use ORMs either! I’d love to use Laravel if it was allowed. I’m thinking about making it framework-based to ease the workload, but if it gets too messy, I might revert to just plain PHP.