I'm looking for a bit of advice please.
I would like to write/develop my own web based clinic management system to store appointment details, stock information, clinic statistics etc.
I don't think it would take me long to get back into the SQL language, stored procedures etc and building a requirements spec and data structure shouldn't be an issue but my question is: what is the current best thinking on web based applications concerning language, database, platform and security? Bear in mind that I will be using a standard shared hosted web server (Windows based) and domain so cloud based apps are out.
It's a bit of a long shot I know, but I've been out of the loop for a long time. I could buy a cloud based management system but I fancy a project and some of them don't do what I want and are expensive.
Thanks for any help