#1 - I've never heard of Notetab, but apparently it is some sort of text editor. If the text is simple enough to enter into a web form, PHP could be used.
#2. - MySQL supports multiple databases, which are specified in the SQL language. You could use distinct domain names, but that would make more sense if the databases were hosted on different servers.
#3 - I'd go with a server. If PHP is used, I'd use Linux for the operating system with Samba for file sharing with Windows clients - with per-user access privileges.
#4 - If I recall correctly, MySQL can authorize different user accounts for access at various levels - database, table, field, etc. It should not be necessary to run multiple MySQL processes to prevent unauthorized access to data.
Here is some unsolicited advice -
Rule #1 - Don't get involved with doctors who want to be computer programmers. It's always a disaster.
Rule #2 - Don't store large TIFF files in a database. Use the shared file system instead, and store a file path to the image in the database.
This web site and I disclaim any liability for the comments above. Use at your own risk.
#1 - I've never heard of Notetab, but apparently it is some sort of text editor. If the text is simple enough to enter into a web form, PHP could be used.
It caused a lot of confusion for me as well, especially since it was a text editor. I think the Doctor used it since it was free.
#3 - I'd go with a server. If PHP is used, I'd use Linux for the operating system with Samba for file sharing with Windows clients - with per-user access privileges.
I had planned on Linux. In fact I was going to play around with rPath LAMP this weekend. So you suggest that the user scan the images to a mapped Images folder on the Server? How than do you store a file path in the database?
Here is some unsolicited advice -
Rule #1 - Don't get involved with doctors who want to be computer programmers. It's always a disaster.
Oh I know, I was going to push that he would have to relinquish admin controls. That is a reason why I want to to it my way so that I only cut him in for his assistance in marketing and selling the app.
Rule #2 - Don't store large TIFF files in a database. Use the shared file system instead, and store a file path to the image in the database.
See above. I guess this is why Misys EMR the user scans the document in with the Misys Document Manager Utility. This adds the information from the paper to the patient record. Then an image is saved in the Images folder. Than the workstations and application server have a mapped drive to the Images folder.
This web site and I disclaim any liability for the comments above. Use at your own risk.
No problem. Like I said I will be hiring somebody to do the programming. I am just trying to learn as much as possible before our next meeting.