Before you go throwing together a solution, you need to check the laws in your state and country. Here in the US there are laws that say how patient data can be stored. There are compliant software packages for Dr's and Hospitals that include everything they need including stuff like medical billing.
Some of the newer systems also support the wireless tablet computers that the Dr's and Nurses carry from room to room.
Just keep in mind, you are handling people's private information, so security is your #1 priority.
-matt
On 8/20/07, Lanny Marcus mailing-lists@computer2.com wrote:
This is very OT. If list readers can point me in the right direction, to other mailing lists, or web sites for recommended databases, that will be much appreciated!
My wife's doctor wants to move records, for approximately 6000 patients (over a 12 year period), from paper (18th century) to a database (20th century). The data entry will be a PITA, for his secretaries, regardless of what software he goes with. I did some reading about MySQL, and I also did some googling for Linux+database and there are many other databases out there. One requirement is that one field be variable length (patient history: surgeries, treatments, etc.), which I suspect might vary from 200 words to 3000 words. That field size needs to be very flexible. If there are "front ends" that will make it easier for his secretaries to input patient records to the database and access it, that will be a "plus". It would also be a plus, but, it's not mandatory, if they can do this in Spanish. It's a small office (2 surgeons, nurses and secretaries) so I suspect there might be 4 to 6 workstations connected to the database server, maximum. I would like to help him get the best possible solution. Something with a large user base, excellent documentation and an active ML, like CentOS, is the goal. Thanks much! Lanny
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos