drug databases

2008-01-18 Thread paul van den berg
Hello, as a pharmacoepidemiologist I regularly use drug databases. Most of them are non-free, but the ATC/DDD system is available free of charge. I have a shell script to wget the data from http://www.whocc.no/atcddd and a perl-script to convert it in a mysql database. Anyone interested? Since 1

Free drug databases

2002-11-08 Thread Andreas Tille
Hello, I've got another hint to a free - at least in the sense free of charge, but no real license applied -drug database: http://www.fda.gov/cder/ndc/database/default.htm Anybody wants to evaluate this? Kind regards Andreas.

Re: drug databases

2008-01-19 Thread Karsten Hilbert
On Fri, Jan 18, 2008 at 10:40:02PM +0100, paul van den berg wrote: > as a pharmacoepidemiologist I regularly use drug databases. Most of them are > non-free, > but the ATC/DDD system is available free of charge. > I have a shell script to wget the data from http://www.whocc.no/atcddd

Re: drug databases

2008-01-20 Thread Andreas Tille
On Sat, 19 Jan 2008, Karsten Hilbert wrote: Does your script turn the data into SQL statements ? That would be *most* useful, much more than a mysql database as such. Sounds very reasonable. I could imagine scripts create_act-ddd_drug_db update_act-ddd_drug_db featuring a command line

Re: drug databases

2008-01-20 Thread Karsten Hilbert
On Sun, Jan 20, 2008 at 05:30:41PM +0100, RKI Andreas wrote: >> Does your script turn the data into SQL statements ? That >> would be *most* useful, much more than a mysql database as >> such. > > Sounds very reasonable. I could imagine scripts > >create_act-ddd_drug_db >update_act-ddd_dr

Re: drug databases

2008-01-20 Thread paul van den berg
On Sun, Jan 20, 2008 at 05:30:41PM +0100, RKI Andreas wrote: >> Does your script turn the data into SQL statements ? That >> would be *most* useful, much more than a mysql database as >> such. > > Sounds very reasonable. I could imagine scripts > >create_act-ddd_drug_db >update_act-ddd_dr

Re: drug databases

2008-01-20 Thread Karsten Hilbert
On Sun, Jan 20, 2008 at 10:28:07PM +0100, paul van den berg wrote: > >> Does your script turn the data into SQL statements ? That > >> would be *most* useful, much more than a mysql database as > >> such. > > > > Sounds very reasonable. I could imagine scripts > > > >create_act-ddd_drug_db >

Re: drug databases

2008-01-20 Thread Karsten Hilbert
On Sun, Jan 20, 2008 at 11:09:23PM +0100, Karsten Hilbert wrote: > > It is easy to convert $dbh->do(insert ..) to print(insert ..), > > but it is not so easy to write fully portable sql. > > In my script I use > > create table if not exists .. PG: drop table if exists ... create

Re: drug databases

2008-01-20 Thread Andreas Tille
On Sun, 20 Jan 2008, Karsten Hilbert wrote: I suggest you provide two options: --data-only output INSERT statements only, no table creation don't use MYSQLisms in INSERT INTO queries --schema-only output table defs only, can be mysql-specific Sounds reasonable. If

Re: drug databases

2008-01-21 Thread paul van den berg
On Sun, Jan 20, 2008 at 11:09:23PM +0100, Karsten Hilbert wrote: > create table if not exists .. > drop table if exists ... > create table ... That is not equivalent! With mysql you would add data to an existing table. But I found a workaround in perl-DBI. > insert ignore into .. >

Re: drug databases

2008-01-22 Thread Karsten Hilbert
On Mon, Jan 21, 2008 at 10:54:05PM +0100, paul van den berg wrote: > Subject: Re: drug databases > > On Sun, Jan 20, 2008 at 11:09:23PM +0100, Karsten Hilbert wrote: > > > create table if not exists .. > > drop table if exists ... > > create table ... > T

Re: drug databases

2008-01-22 Thread Karsten Hilbert
Paul, any chance you could include an option/script to not actually *import* the data but rather write INSERT statements into a file for later import ? That would be great ! Thanks, Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- To UNSU

Re: drug databases

2008-01-23 Thread paul van den berg
> > That is not equivalent! With mysql you would add data to an existing > > table. > You are correct. The thought never occurred to me that you > would want to risk using an existing table. At the moment I download one of 14 atc-main-groups with getatc.sh. In the end I want all atc codes in one ta

Re: drug databases

2008-02-08 Thread paul van den berg
On Sun, 20 Jan 2008 22:28:07 +0100 "paul van den berg" <[EMAIL PROTECTED]> wrote: >> Does your script turn the data into SQL statements ? That >> would be *most* useful, much more than a mysql database as >> such. I made .csv files from atc/ddd data for 2006 and 2007. See http://home.orange.nl/

Re: drug databases

2008-02-09 Thread Karsten Hilbert
> >> Does your script turn the data into SQL statements ? That > >> would be *most* useful, much more than a mysql database as > >> such. > > I made .csv files from atc/ddd data for 2006 and 2007. > See http://home.orange.nl/pbvandenberg/medicindata.html Ah, very nice. Karsten -- GMX FreeMail

Re: Free drug databases

2002-11-08 Thread Elizabeth Barham
Andreas Tille <[EMAIL PROTECTED]> writes: > I've got another hint to a free - at least in the sense free of charge, > but no real license applied -drug database: > >http://www.fda.gov/cder/ndc/database/default.htm > > Anybody wants to evaluate this? I like it but the data is less than t

Re: Free drug databases

2002-11-08 Thread Kevin Rosenberg
Andreas Tille wrote: > I've got another hint to a free - at least in the sense free of charge, > but no real license applied -drug database: > >http://www.fda.gov/cder/ndc/database/default.htm > Anybody wants to evaluate this? I'm awaiting licensing claification about data in the Unified

Re: Organised mirroring of public databases, Re: drug databases

2008-01-20 Thread Charles Plessy
Le Fri, Jan 18, 2008 at 11:04:37AM +0100, Steffen Moeller a écrit : > I parked here > > http://svn.debian.org/wsvn/debian-med/trunk/community/infrastructure/getData.pl?op=file&rev=0&sc=0 > > a script which allows the download of external databases in a fairly > straight-forward manner. This is fa