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
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.
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
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
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
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
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
>
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
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
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 ..
>
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
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
> > 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
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/
> >> 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
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
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
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
18 matches
Mail list logo