mapserver and database connectivity.

[Stephen Lime]

I'm wrapping mapserver with SWIG now. Going ok, SWIG ain't perfect but most things I want to do should work. The perl interface allows you to define arbitrary features (points, lines and polygons) and add them to a map composition. This way just about any data source that's accessible from perl can be added to the mapserv.

Should be doable from PHP as well although I'm not sure if there is a convientent tool like SWIG for extending it. I actually had a PHP module working a few years ago so I know it can be done. 

I don't think extending the C codebase is the way to go unless there's a decent library out there. Too much reinventing the wheel otherwise.

Steve

<<< Nathan Carr <ncarr at guideguide.com> 10/ 6  4:56a >>>
	I too am interested in this functionality. Have been looking at
wrapping
mapserver with SWIG, so I could use perl DBI to access database tables.
This seems a bit
confusing as there is quite a bit of libraries and structures to
include.
 
Alternatively would it be possible to extend the JOIN functionality for
joining DBF
files to join MySQL/PostGres type tables? 

Cheerio, nathan

> 
> Hi all,
> 
> Second this question.  We are looking at building similar functionality,
> but with PHP.  When we discover any info. re. this, we will post it.
> Perhaps Steve has some insight?
> 
> Cheers,
> Jim
> 
> Robert Chavez wrote:
> >
> > Greetings,
> >
> > I am wondering if it is possible to send information to mapserver from a
> > database (PostGresql).
> >
> >  I'm using the Pg perl module to build a web interface to my PostGres
> > database so users can query and display the data set.  The next logical step
> > would be to send the results to Mapserver somehow and plot them on my
> > basemap -- or perhaps create a tranparent gif of the coordinates that could
> > be overlayed on the base map.  Has anyone had any experience  with this sort
> > of functionality?
> >
> > Thanks,
> > Rob Chavez
> 
> --
> 
-- 
Nathan Carr  ncarr at guideguide.com