RE: LDM -> Database (mysql)???

• To: "'Michael W Dross'" <mwdross@xxxxxxxxxxxxxxx>,
• Subject: RE: LDM -> Database (mysql)???
• From: "Dan Vietor" <devo@xxxxxxxxxxxxx>
• Date: Thu, 19 Apr 2001 18:01:25 -0400

> I was wondering if anyone had tried to interface LDM into a database
> program? I was thinking of embarking on trying
> to have LDM interface with mysql ( a free database software
> package) and have it database all of the WMO products.

What I was working on about 3 months ago (with Postgres) was to database
the WMO header, location and size into a database table.  Use this as a
pointer to the data on disk.  Dumping all the data into the Database
requires expensive cleanup routines and I figured it was easier to use
the database as a quick lookup to data on disk rather than dumping the
data into the database.  This might be easier with Oracle or other
$500,000 databases which might have better garbage collection.  In other
words, I was using the database in the same fashion I use header files
in WXP.

As for surface data, it is more regular and I played around with dumping
about 10 fields into the database and keeping a pointer to the last 24
hours worth of data.  I just started this work but never got to the
point I was populating the database so I don't know about the
gotchas....

________________________________________________________
Daniel Vietor               Mail: devo@xxxxxxxxxxxxx
Unisys Corp                 Title: Engineer/Meteorologist
221 Gale Lane               Phone: 610-925-5206
Kennett Square PA 19348     Fax: 610-925-5215



> -----Original Message-----
> From: owner-ldm-users@xxxxxxxxxxxxxxxx
> [mailto:owner-ldm-users@xxxxxxxxxxxxxxxx]On Behalf Of Michael W Dross
> Sent: Thursday, April 19, 2001 5:08 PM
> To: ldm-users@xxxxxxxxxxxxxxxx
> Subject: LDM -> Database (mysql)???
>
>
> Hi all,
>
>
> Just wanted to see if it had been done before..
>
> Thanks!
>
> Mike Dross
> mwdross@xxxxxxxxxxxxxxx
>

• Follow-Ups:
  • Re: LDM -> Database (mysql)???
    • From: David Knight

• References:
  • LDM -> Database (mysql)???
    • From: Michael W Dross