Re: using mysql with ldm (fwd)

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

---------- Forwarded message ----------
Date: Thu, 23 Sep 2004 10:59:28 -0700
From: address@hidden
To: Robb Kambic <address@hidden>
Subject: Re: using mysql with ldm


Hi Robb,

We're looking the problem of missing reports and storing reports in a
SQL database (probably MySQL) right now, so it's good to hear this
news from you.  Please keep me or the list posted on the progress of
this project.  Also, if there's anything I could do to help, let me
know.  Thanks!

 --joseph

Joseph Sheedy
Technical Specialist
3TIER Environmental Forecast Group
address@hidden
(206)325-1573

On Thu, Sep 23, 2004 at 09:44:30AM -0600, Robb Kambic wrote:
> 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/
> ===============================================================================