Hey, I need some help with an upcoming project for my exam. The goal is to create an app that incorporates both MySQL and MongoDB, and users should be able to choose which database to use from the menu. In MySQL, I have to implement complex functions, stored procedures, events, triggers, and cursors, with all the SQL code in a separate file.
I'm seeking ideas for a good project that meets these requirements. Also, what technologies do you think I should use for development? I'm leaning towards PHP since I'm comfortable with it, but I'm open to exploring other languages if they might fit better. Just a heads up, I know some of this might seem excessive, but those are the requirements I'm stuck with. I'd love to hear your suggestions! Thanks!
5 Answers
Honestly, stick with PHP since you're already familiar with it. You’ll spend more time tackling database management issues than learning a new language. If you're keen on learning something new, maybe go with a .NET API and a frontend framework for a fresh challenge. Just be sure about whether you can use an ORM, as some projects require working directly with the database.
Seems like a strange exam to mix relational and NoSQL databases! I feel you; sometimes courses make us jump through hoops that don't apply in the real world.
Right? It's wild! But I guess we just have to make the best out of it.
Totally! I have to separate the logic for these two databases, even if it doesn't make much sense.
Try to think of something relatable to daily life, like an app to track your spending, an attendance manager, or even a simple note-taking app. Check out apps on your phone that look easy to mimic, like a basic messaging app or a photo gallery.
A while ago I migrated a web app from MongoDB to MariaDB, since both are DBMSs. We set up stored procedures to handle database maintenance. For your project, keeping the frameworks simple might actually be helpful and make your code clearer.
Maybe ask ChatGPT for ideas? But it suggested using Node.js and Express. I’m curious though—can you write pure SQL and MongoDB code? I’m ready to learn something new while on this project!
Yeah, that seems like a specific task where getting advice from real people might be more helpful than from AI.
I can’t use ORM for this project! If I could, I'd go with Laravel. I'm looking for a way to simplify things with a framework, but if it gets too tough, I’ll resort to plain PHP.