I'm working on a master's project in Computer Engineering that involves creating a desktop app in .NET and mobile apps that need to interface with a SQL database. The desktop app will display updates and send them to a MySQL database, which should be accessible by about 20 mobile devices. My primary concern is how to set up SQL: should I run it on the app itself, or would it be better to use MySQL hosted on a single computer for everyone in the office? With only three people accessing the desktop app while the updates need to be visible on the phones, I'd love to get some advice on the best configuration.
1 Answer
For this setup, it's best to host your database on a dedicated server, which can even be a laptop or a small device like a Raspberry Pi. C# and .NET work seamlessly with SQL Server, but you can stick with MySQL if you prefer. I recommend using Docker to simplify the setup process. It will help you get your database up and running with just a few commands, and you'll need to ensure the correct ports are forwarded so that other devices can access it. Just make sure the database server is always on and ready to serve requests.
I appreciate the suggestions! I’m already using MySQL, and my GUI is almost complete, but I’m a bit lost on how to deploy everything.