[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: using mysql with ldm

This would also interest me. I have many years of data in both RAW and
GDBM formats. Would be great to have all of this into MySQL or
similar, with scripts to convert from DB to RAW back and forth easily,
as well as web and shell interfaces to it.

Christian Pagé
UQAM

On Thu, 23 Sep 2004 09:44:30 -0600 (MDT), Robb Kambic
<address@hidden> 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/
> ===============================================================================
> 



-- 
Christian Pagé
http://meteocentre.com/    http://meteoalerte.com/
Etudiant au Doctorat en Sciences de l'environnement UQAM