Re: [Gnumed-devel] database installation

[David Grant]

Ian Haywood wrote:

> On Mon, 09 Jun 2003 21:49:17 -0400
> David Grant <address@hidden> wrote:
>
>  
>
> > I'm an experienced Linux user and I know Python, but I'm a total 
> > postgresql newbie (and a newbie to all databases for that matter).
> >
> >    
> Welcome aboard!
>
>  
>
> > I think I recognize "select name from distributed_db;" as some sort of 
> > SQL query...  Is my database not initialized properly?  
> >    
> Correct.
>
> scripts for installing gnumed databases are found in 
> gnumed/gnumed/server/bootstrap, in
> the CVS tree.
>
> the commands I used were:
>
> $ ./make-links.sh
> $ ./bootstrap-gm_db_system.py --conf=bootstrap-standard-AU.conf
>
> This database has some customisations for Australian practice (probably more 
> informative than
> German: the only other options at this stage) At present this is only the postcodes (zip codes) 
> but this will have more significance as time goes on.
>
>
>  
>
> > By the way, 
> > what's the best way to clear my database and start over.  Can I just 
> > delete the /var/lib/postgresql/data directory?  Thanks.
> >    
>
> No. do "dropdb gnumed" first to delete the database. 
>
>  
>
> > Please CC any replies to address@hidden
> >
> > David Grant
> >    
>
> Would you mind briefly introducing yourself? Are you a doctor/ programmer/ 
> whatever?
> Can you give us any information on customisation
> for the Canadian health system? In particular, what drug databases are in use 
> over there?
>  
I am a graduate of engineering physics/electrical engineering option, 
but I am a bit slanted to software because of some of the summer jobs I 
had during school.  My fiancee is only in 2nd year medical school, and 
when she eventually sets up practice I want her to use some cheaper 
solution I hope.  Mainly I'm interested because I want to learn about 
databases and also how to set up a network and IT system from scratch 
(for non-home applications).  So in some ways I'm doing it for myself, 
but for her as well.

Secondly, I've learned Python a few months ago and I love it!  I want to 
do some more, to improve my skills.

I have no idea what customization is in order for the Canadian health 
system.  My grandma was a doctor's secretary, and all I know is that the 
software usually has a direct link-up, or an "export, then send" format 
to the provincial health care system's billing system.  The son-in-law 
of the doctor she worked with actually coded some sort of thing in 
Delphi (some old programming language?) for them a long time ago and I 
think they used that for a long time.  I was 13 at the time that this 
son-in-law was telling me this I had no idea what he was talking about.

Dave