Re: [Gnumed-devel] Some suggestions to make gnumed more efficient

[Karsten Hilbert]

Hallo Christoph,

> Dezign for databases imports an sql-schema via ImporterScript tool.  
> You can't run it against a running database.
I understand.

> Even more, because of some bugs in their ImporterScript tool,  a 
> schema-file written with pg_dump has to be run through a filter first. 
> For example character varying (n) has to be replaced with varchar(n).  
I just checked, we don't have any "character varying" in use.
Also, I replaced most varchar(n) with TEXT.

> It should be easy to install the gnumed backend on Windows when using a 
> native Windowsport of  PostgreSQL 8
Well, our bootstrapper needs testing and likely some changes
for Windows. Sure it would be nice to have a point-click
installer but someone needs to do it.

> and it should be not to difficult to 
> understand how the gnumed backend works
Writing a good schema is hard. Understanding and using it
requires thought.

> and how it can be interfaced by a GUI.
Ideally, programmers should use middleware/business APIs to
access it. Eg.:

patient = patient_searcher(lastname=..., firstname=...)
emr = patient.get_emr()
print emr.get_missing_vaccinations()
print emr.get_allergies()
print emr.get_last_encounter()
print emr.get_current_medications()

This is how the GnuMed business layer works.

> If I get Gnumed running on Windows I will send you the scripts needed as 
> well as the output of Dezign for Databases. But this may take some time.
Take your time but this would be really helpful. The problem is,
however, that the schema graphics need to be updated
regularly...

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346