Re: using mysql with ldm

• To: Gerry Creager N5JXS <gerry.creager@xxxxxxxx>
• Subject: Re: using mysql with ldm
• From: Robb Kambic <rkambic@xxxxxxxxxxxxxxxx>
• Date: Thu, 23 Sep 2004 09:44:30 -0600 (MDT)

hiya,

i've been looking into the pqsurf problem of missing reports and the
storing of the reports into gdbm database  because the pqsurf maintenance was
done by me many years ago. UPC tried to deprecate the code because there are
better more efficient solutions possible.  the last couple of years my current
work has been with the THREDDS project that involved work with the surface
observations, actually all the NWS products on the IDD. one can view the
surface servers at:

http://my.unidata.ucar.edu/content/projects/THREDDS/tech/server/motherlode.html

these servers have been available for over a year, feel free to use them.

anyway getting back to the above problem, i'm working on a solution using
my THREDDS work to implement a decoder to bust up surface bulletins into
individual reports and to store then into a database.   an estimate of 2
weeks for a working solution, trying to make a generalized solution so
different databases can be used instead of only gdbm.

comments

robb...



On Wed, 22 Sep 2004, Gerry Creager N5JXS wrote:

We've been doing some of this with perl, php and Postgres.  I'm sorta
swamped but we're reentering a development phase on this, so if you've
troubles getting it going, within a month or so, likely we can offer
some examples.

Gerry

Waldenio Almeida wrote:
> Hello All,
>
> I would like to feed a MySQL database with LDM.
> I saw how to do with a gdbm database, using the
> DBFILE command. unfortunately, the gdbm allow
> only one key per registry.
>
> My database will store the WMO bulletins (the raw
> data), so I need preserve the WMO Headers too.
>
> My objective is retrieve the WMO bulletins using
> parts of the WMO Header as a Key, like the codes
> T1T2, A1A2, date, origin, timestamp, country code
> CCCC, etc.
>
> Can someone help me about this task ?
>
> Many Thanks
> Waldenio Gambi
> CPTEC/INPE

--
Gerry Creager -- gerry.creager@xxxxxxxx
Texas Mesonet -- AATLT, Texas A&M University
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Page: 979.228.0173
Office: 903A Eller Bldg, TAMU, College Station, TX 77843

==============================================================================
Robb Kambic                                Unidata Program Center
Software Engineer III                      Univ. Corp for Atmospheric Research
rkambic@xxxxxxxxxxxxxxxx                   WWW: http://www.unidata.ucar.edu/
==============================================================================