[CentOS] OT: Suggestions for database for physicians patientrecords?

Mon Aug 20 11:58:05 UTC 2007
gjgowey at tmo.blackberry.net <gjgowey at tmo.blackberry.net>

If you want to take this offline I'll chat with you further.  However, if it's just for in office use I'd look at using CentOS, postgresql (not MYSQL), php, and APACHE.  It wouldn't be very hard to throw together an app that would do what you want that is web based.

Of course if he wants a fat client it would be very easy to develop a database structure and use either access as the custom front end or develop a program in your language of choice (java or .net based).

Geoff

Sent from my BlackBerry wireless handheld.

-----Original Message-----
From: Lanny Marcus <mailing-lists at computer2.com>

Date: Mon, 20 Aug 2007 06:48:54 
To:CentOS Mailing List <centos at centos.org>
Subject: [CentOS] OT: Suggestions for database for physicians patient
	records?


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 at centos.org
http://lists.centos.org/mailman/listinfo/centos