Re: [Gnumed-devel] question about gnumed and database

[Richard Terry]

snip.... Omar, here is the realists opinion.

gnuMEd is a long long way from being usable or installable, especially on 
mission critical things like you are indicating.

I'm interested in your currrent problems however.

 I've been running win98 + Access7.0 since, well, 1998 I guess, in mission 
critical desktop medical records system. Its a complex database which complex 
queries (eg up to 16 inner/outer joins may exist in one query taking upan A4 
page of text - querying 10-15 normalised database tables (out of total of 120 
tables) at the one time. The results are extremely quick and the database has 
performs well.

Seems odd that you are getting problems. Usually the problem is that the 
windows machine is acting as the file server. I used to have real problems 
with my windows machines until I stated using a linux file server back at 
e-smith 4, and virtually none since.

The expert on this list regarding linking the windows/linux machines is 
probably Horst, who is a bit hard to catch, but if you ring me I'll give you 
his surgery phone number (Dorrigo Medical Centre up northern NSW). I warn you 
first however, that what is easy for him is almost impossibly difficult for 
the rest of us.

Feel free to ring.

DR Richard Terry
Whitebridge Medical Centre
141 Dudley Rd
WHITEBRIDGE 2290
02 49436511


BTW I'm in Newcastle and get down to Sydney a fair bit so it you want to chat 
you can either see me here, there or ring me at surgery on 02 49436511.


>....  database be adapted for use
> in the vascular lab?


 The present database is  fairly simple  with
> patient demographics, risk factors, indications, referring physician,
> procedure, post-op write-up, and other drop-list parameters. It is old
> and does not provide any statistical info (i.e. how many patients under
> 65 had a stroke this month and how many of those were stented). Second,
> do you think it's feasible to run Fedora or some other form of Linux on
> the Vasc Lab computer and network them seamlessly with the hospital's
> Windows server (I'll have to double check that but the ward terminals
> are running win2000).
> I should also mention that my first degree was in EE (control) from UC
> Santa Barbara, hence my interest in all things technical (I get to play
> with the doppler machines in the vasc lab). Programming is not my forte
> but I know some basic C. From browsing through your website, it seems
> Python is the way to go these days. Is that true for database as well?
> BTW, do any of you live in Sydney?
> That's it for now.
> Thank you for your time.
> Cheers.
>
> Omar