General discussion


Choosing the right tools for a database application

By MoF_ ·
I need to create a database application for a mid-sized company. After giving it a lot of thought I decided to make it a web database application running locally on their intranet.
This company has a database in access and it has starting to reach its limits.

My question is what language, platform, database to use? I'm more comfortable working with MySQL and PHP or JSP, but I'm a little worried about database-size and many users accessing the database issues, if there are any with MySQL.

The database has as top around 5000 records in its biggest tables. There will be 8-10 people accessing it as different users with different privileges.

I've spent a lot of time on Google trying to find some answers. I noticed that MS SQL Server is probably the best solution because it supports everything I need, but my problem is that I haven't used it before and I don't know much about ASP.NET or C#.

Do you have any suggestions about what language and database is the best to use in this case? Is MySQL and PHP or JSP going to do the job, or will there be any problems with many users accessing the application or with the size of the database?

I'm really confused, cause it's my first real-world project after graduating from IT University. Thank you for your time.

/Edit: Posted this as a question, why is it in the discussion forum? :S

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums