[Xastir-dev] Re: Database Storage

[Jeffrey Johnson]

Paul,

Thanks for this. My bad for not grabbing the latest code, reading the
INSTALL file and doing the configure/make/install dance before asking. This
is done now, and I have a 1.9.3 instance going now with PostGIS support. I
will play with all this and let you know how it goes.

Where can I find more info about this xastir-ng stuff other than the few
threads I find when googling?

In the process of doing this implementation, I will end setting up a REST
API on top of the positions DB using GeoDjango to query the database etc and
return GeoRSS, KML, GeoJSON etc. If anyone is interested in this sort of
thing, I am happy to share.

Also, I will look into the APRSWorld schema if this is the best place for me
to make an initial contribution.

Jeff

On Tue, Jul 8, 2008 at 11:10 AM, Paul J. Morris <mole at morris.net> wrote:

> On Tue, 8 Jul 2008 09:04:21 -0700
> "Jeffrey Johnson" <ortelius at gmail.com> wrote:
> > What ever became of this?
> >
> > http://lists.xastir.org/pipermail/xastir-dev/2007-July/002674.html
> >
> > I am perhaps interested in contributing to this effort if its still
> > alive.
>
> It is at a working proof of concept stage in the current 1.9.3
> development release.  I haven't had a chance to work on in for a few
> months, but (depending on the shift of effort to xastir-ng [where most
> of this layer could be built rapidly with code generation tools]), it
> is still quite alive, if rather experimental still.  You can store
> station positions as they are heard in a table in either MySQL or
> PostGIS, and retrieve those positions on restarting xastir.
>
> Support for MySQL 5 or Postgresql+PostGIS can be enabled by building
> xastir using:
>
> configure --with-mysql --with-postgis
>
> See section 12 in the INSTALL file.
>
> Only a minimal set of data is currently being stored (expanding to the
> APRSWorld schema might be a nice next step).
>
> SQL to create the relevant tables can be found in
> scripts/db_gis_mysql.sql and scripts/db_gis_postgis.sql
>
> http://xastir.cvs.sourceforge.net/xastir/xastir/scripts/db_gis_mysql.sql?view=markup
>
> http://xastir.cvs.sourceforge.net/xastir/xastir/scripts/db_gis_postgis.sql?view=markup
>
> Most of the code is in src/db_gis.c
> http://xastir.cvs.sourceforge.net/xastir/xastir/src/db_gis.c?view=markup
> with other blocks in interface.c, interface_gui.c, main.c, and
> xa_config.c identifiable with #ifdef HAVE_DB directives.
>
> -Paul
> --
> Paul J. Morris
> Biodiversity Informatics Manager
> Harvard University Herbaria/Museum of Comparative Zoölogy
> mole at morris.net  AA3SD  PGP public key available
>