Re: using mysql with ldm

Gerry,

at this point i just don't have any extra time to devote to this project.
i'm involved with THREDDS and it's eating up 110% of my time so i don't
know when i'll be able to get to it.  one part that was completed for
THREDDS was the busting up the text bulletins into individual reports. if
someone wanted to use this code as a front end to store the data into
mysql, that would work.  the code is included in the decoders package at
unidata under the name *Writer programs.

robb...


On Wed, 27 Jul 2005, Gerry Creager wrote:

> Robb, reviewing some other things and I came across this.  Did you ever
> succeed in making some progress?
>
> thanks, gerry
>
> 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/
> > ===============================================================================
>
> --
> Gerry Creager -- address@hidden
> Texas Mesonet -- AATLT, Texas A&M University
> Cell: 979.229.5301 Office: 979.458.4020
> FAX:  979.847.8578 Pager:  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/
===============================================================================