Re: [Gretl-devel] New Topic: Connecting gretl with external databases!
On Tue, 16 Sep 2014, Konstantinos Kaleris wrote:
Dear gretl developers,
greetings from Patras, Greece, from a small workgroup that was formed in
the frame of a seminar regarding open source software at the University
of Patras.
Greetings from Ancona, at the other end of the ferry trip :)
In the case of our group, the task is to extend gretl according to
the
needs of our work, hoping that other people would also find these
features useful.
Our first attempt would be to extend the database list and provide users
with the possibility to access data from some other statistics sources -
especially at first containing greek/european data. As we understood so
far, ODBC provides an interface for gretl to interact with database
servers and that the databases provided in the default installation of
gretl reside on a database server dedicated to gretl. We would like to
investigate the possibility of accessing databases that reside on
other/external servers. This email is an attempt to make a first contact
and see if there is anybody who has experience from similar tasks and
could possibly give us hints on the process!! For a reply we would be
glad. And we hope to be able soon to contribute to the gretl community!
What you want to do is not exactly clear to me. At present you can
* use databases provided with your gretl installation (eg fedstl) or by
downloading the whole database from Allin's server at Wake Forest
* use ODBC to establish an SQL connection with any RDBMS server you want.
BTW: this has been available for a long time but so far we've had very
little feedback; I like to think that this means that it works ok ;)
* use the newer hansl functions for handling URLs (curl, open, jsonget),
to access data from a publicly available server on the Net (see the
yahoo_get package for a simple example); you may want to contact Logan
Kelly <logan.kelly(a)uwrf.edu>, who has been very active in this area and
I believe can share his expertise with you.
-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)
Università Politecnica delle Marche
(formerly known as Università di Ancona)
r.lucchetti(a)univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------