Re: using mysql with ldm

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 -- address@hidden
> 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
address@hidden             WWW: http://www.unidata.ucar.edu/
===============================================================================