Re: drug databases

["paul van den berg" <paulbvdberg@gmail.com>]

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_drug_db
>
> featuring a command line options for instance -m for MySQL and

> -p for PostgreSQL.
>
> Our task in Debian-Med would be to turn this script into an
> easily installable Debian package.

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 ..
 insert ignore into ..
and these constructs are mysql-specific.

I have tried (with postgresql and sqlite3) to rewrite it in
portable sql, but that is not yet ready. Maybe someone else can
give it a try.
I have put my scripts online at 
http://home.orange.nl/pbvandenberg/medicindata.html

Regards, Paul