[pgrouting-dev] [pgr_2.0] Just checked in code to eliminate GAUL

pgRouting pgrouting-dev
1

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve

2

Steve

Is the windows build instructions the same as what I did last year for the build that I made? (mingw?)

Pieter

···

On Fri, Apr 5, 2013 at 3:35 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

3

On 05/04/13 02:35, Stephen Woodbridge wrote:

Hi Stephen,

Can you drop me a line when you have fiinshed all the changes your going to make, I like to try and get the ksp code up to the same release stadnard.

Dave.

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

4

Hi Dave,

At this point you should be able to safely merge your code without any significant issues.

1. Fork my branch sew-devel-2_0
2. add a directory like
pgrouting/
     src/ksp/
         doc/ - put doc files here using .rst restructured text
         sql/ - put sql wrappers here
         src/ - put all your source code here
         test/ - put your tests here (look at src/trsp/test/* for example)
3. integrate with CMake

Ask if you need help with cmake or anything.

The new tree structure means you can do 99.9% of the work independent of the noise in the rest of the tree. The only top level file that should need to be changed is the top-level CMakeLists.txt. If you have SRF types specific to your code then the type definitions need to loaded first in your .sql file(s) or get moved to src/common/sql/pgrouting-types.txt

It would be great to get this integrated. Shoot me a pull request when you are ready, and I'll get it merged.

Thanks,
   -Steve

On 4/5/2013 9:02 AM, Dave Potts wrote:

On 05/04/13 02:35, Stephen Woodbridge wrote:

Hi Stephen,

Can you drop me a line when you have fiinshed all the changes your going to make, I like to try and get the ksp code up to the same release stadnard.

Dave.

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

5

I built this based on the postgis mingw32 and ming64 build environments. But if you pull my branch there is a tools directory at the top level that has some scripts (more as doc then a runnable script) called:

makedependanciesw64.sh - how to build the dependencies
makepgroutingw32.sh - how to build under ming32
makepgroutingw64.sh - how to build under ming64

I say to look at these as docs not as scripts because they have a lot of assumptions about directory structures and such.

There are also a couple of patch files in the tools directory also. With my latest checking you do not need to build the GAUL dependency anymore.

-Steve

On 4/5/2013 1:09 AM, Pieter du Plooy wrote:

Steve

Is the windows build instructions the same as what I did last year for the build that I made? (mingw?)

Pieter

On Fri, Apr 5, 2013 at 3:35 AM, Stephen Woodbridge <woodbri@swoodbridge.com <mailto:woodbri@swoodbridge.com>> wrote:

    Hi All,

    I have just checked in code into sew-devel-2_0 branch that
    eliminates the GAUL dependency and replaces the TSP solver with a
    simple C routine. I rewrote the TSP lib code to use the existing
    GAUL API and to use the postgresql memory management and added two
    test cases. I have build and tested on Win32-pg92 and Linux-pg84
    with no problems.

    Daniel - Thanks for the feedback on TSP, I will look at it and see
    what I can do with your suggestions.

    The current code assumes a loop, ie: the start is also the end
    point. Other than that is should work as before.

    -Steve
    _______________________________________________
    pgrouting-dev mailing list
    pgrouting-dev@lists.osgeo.org <mailto:pgrouting-dev@lists.osgeo.org>
    http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

6

Thanx Steve

Do you perhaps have prebuilt binaries? (64 and 32 bit)?

I will build during this week, just need to get my DEV machine up and running.

···

On Sat, Apr 6, 2013 at 2:38 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

I built this based on the postgis mingw32 and ming64 build environments. But if you pull my branch there is a tools directory at the top level that has some scripts (more as doc then a runnable script) called:

makedependanciesw64.sh - how to build the dependencies
makepgroutingw32.sh - how to build under ming32
makepgroutingw64.sh - how to build under ming64

I say to look at these as docs not as scripts because they have a lot of assumptions about directory structures and such.

There are also a couple of patch files in the tools directory also. With my latest checking you do not need to build the GAUL dependency anymore.

-Steve

On 4/5/2013 1:09 AM, Pieter du Plooy wrote:

Steve

Is the windows build instructions the same as what I did last year for the build that I made? (mingw?)

Pieter

_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

On Fri, Apr 5, 2013 at 3:35 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

7

Hi Pieter,

Here is my last build that runs on the following:

test1=# select version();
version

--------------------------------------------------------------------------------
----------------------------------------------------------------------
  PostgreSQL 9.2.1 on i686-w64-mingw32, compiled by i686-w64-mingw32-gcc.exe (GCC) 4.5.4 20111030 (prerelease) [svn/rev.180676 - mingw-w64/oz], 32-bit
(1 row)

test1=# select postgis_full_version();
NOTICE: Function postgis_topology_scripts_installed() not found. Is topology su
pport enabled and topology.sql installed?
postgis
_full_version

--------------------------------------------------------------------------------
-------
  POSTGIS="2.0.1 r9979" GEOS="3.4.0dev-CAPI-1.8.0 r3716" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" LIBJSON="UNKNOWN"
RASTER
(1 row)

http://imaptools.com:8080/dl/pgrouting-1.0.7DEV-pg92.zip

Installed on my system as:

$ cat install_manifest.txt
c:/ming32/projects/pgx32/pg92w32/lib/POSTGR~1/librouting.dll.a
c:/ming32/projects/pgx32/pg92w32/lib/POSTGR~1/librouting.dll
c:/ming32/projects/pgx32/pg92w32/share/POSTGR~1/extension/pgrouting--1.0.7.sql
c:/ming32/projects/pgx32/pg92w32/share/POSTGR~1/extension/pgrouting.control
c:/ming32/projects/pgx32/pg92w32/lib/POSTGR~1/librouting_tsp.dll.a
c:/ming32/projects/pgx32/pg92w32/lib/POSTGR~1/librouting_tsp.dll
c:/ming32/projects/pgx32/pg92w32/lib/POSTGR~1/librouting_dd.dll.a
c:/ming32/projects/pgx32/pg92w32/lib/POSTGR~1/librouting_dd.dll

createdb test1
psql -c "create extension postgis" test1
psql -c "create extension pgrouting" test1

I probably can not help you much with install issues, but let us know if you get it working. There are a few (10) tests already in the source tree and a perl script that runs them tools/test-runner.pl which should be run from the top level.

If you find bugs, I would be happy to get additional tests in a pull request.

-Steve

On 4/6/2013 3:16 AM, Pieter du Plooy wrote:

Thanx Steve

Do you perhaps have prebuilt binaries? (64 and 32 bit)?

I will build during this week, just need to get my DEV machine up and running.

On Sat, Apr 6, 2013 at 2:38 AM, Stephen Woodbridge <woodbri@swoodbridge.com <mailto:woodbri@swoodbridge.com>> wrote:

    I built this based on the postgis mingw32 and ming64 build
    environments. But if you pull my branch there is a tools directory
    at the top level that has some scripts (more as doc then a
    runnable script) called:

    makedependanciesw64.sh - how to build the dependencies
    makepgroutingw32.sh - how to build under ming32
    makepgroutingw64.sh - how to build under ming64

    I say to look at these as docs not as scripts because they have a
    lot of assumptions about directory structures and such.

    There are also a couple of patch files in the tools directory
    also. With my latest checking you do not need to build the GAUL
    dependency anymore.

    -Steve

    On 4/5/2013 1:09 AM, Pieter du Plooy wrote:

    Steve

    Is the windows build instructions the same as what I did last
    year for the build that I made? (mingw?)

    Pieter

    On Fri, Apr 5, 2013 at 3:35 AM, Stephen Woodbridge
    <woodbri@swoodbridge.com <mailto:woodbri@swoodbridge.com>> wrote:

        Hi All,

        I have just checked in code into sew-devel-2_0 branch that
        eliminates the GAUL dependency and replaces the TSP solver
        with a simple C routine. I rewrote the TSP lib code to use
        the existing GAUL API and to use the postgresql memory
        management and added two test cases. I have build and tested
        on Win32-pg92 and Linux-pg84 with no problems.

        Daniel - Thanks for the feedback on TSP, I will look at it
        and see what I can do with your suggestions.

        The current code assumes a loop, ie: the start is also the
        end point. Other than that is should work as before.

        -Steve
        _______________________________________________
        pgrouting-dev mailing list
        pgrouting-dev@lists.osgeo.org
        <mailto:pgrouting-dev@lists.osgeo.org>
        http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

    _______________________________________________
    pgrouting-dev mailing list
    pgrouting-dev@lists.osgeo.org <mailto:pgrouting-dev@lists.osgeo.org>
    http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

    _______________________________________________
    pgrouting-dev mailing list
    pgrouting-dev@lists.osgeo.org <mailto:pgrouting-dev@lists.osgeo.org>
    http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

8

Just a heads up. We plan to distribute pgRouting binaries with PostGIS builds moving forward. Steve has been helping us a lot with that effort as you can see.

We’ll also be setting up the PostGIS windows build bot in the next couple of weeks to autocompile/regress test whenever changes in the pgRouting code base.

We have the pgRouting32 build up:

http://winnie.postgis.net/download/windows/pg92/buildbot/

Having some issue rebuilding the 64-bit, which we’ll write up in a separate post.

Thanks,
Regina and Leo
http://www.postgis.us
http://postgis.net

From: pgrouting-dev-bounces@lists.osgeo.org [mailto:pgrouting-dev-bounces@lists.osgeo.org] On Behalf Of Pieter du Plooy
Sent: Saturday, April 06, 2013 3:16 AM
To: pgRouting developers mailing list
Subject: Re: [pgrouting-dev] [pgr_2.0] Just checked in code to eliminate GAUL

Thanx Steve

Do you perhaps have prebuilt binaries? (64 and 32 bit)?

I will build during this week, just need to get my DEV machine up and running.

On Sat, Apr 6, 2013 at 2:38 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

I built this based on the postgis mingw32 and ming64 build environments. But if you pull my branch there is a tools directory at the top level that has some scripts (more as doc then a runnable script) called:

makedependanciesw64.sh - how to build the dependencies
makepgroutingw32.sh - how to build under ming32
makepgroutingw64.sh - how to build under ming64

I say to look at these as docs not as scripts because they have a lot of assumptions about directory structures and such.

There are also a couple of patch files in the tools directory also. With my latest checking you do not need to build the GAUL dependency anymore.

-Steve

On 4/5/2013 1:09 AM, Pieter du Plooy wrote:

Steve

Is the windows build instructions the same as what I did last year for the build that I made? (mingw?)

Pieter

On Fri, Apr 5, 2013 at 3:35 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

9

Regina and Leo!

Thanks a lot for providing automated Windows builds!
A lot of people will appreciate a lot … and for me this is a big headache less :wink:

Daniel

···

On Sun, Apr 7, 2013 at 11:41 AM, Paragon Corporation <lr@pcorp.us> wrote:

Just a heads up. We plan to distribute pgRouting binaries with PostGIS builds moving forward. Steve has been helping us a lot with that effort as you can see.

We’ll also be setting up the PostGIS windows build bot in the next couple of weeks to autocompile/regress test whenever changes in the pgRouting code base.

We have the pgRouting32 build up:

http://winnie.postgis.net/download/windows/pg92/buildbot/

Having some issue rebuilding the 64-bit, which we’ll write up in a separate post.

Thanks,
Regina and Leo
http://www.postgis.us
http://postgis.net

From: pgrouting-dev-bounces@lists.osgeo.org [mailto:pgrouting-dev-bounces@lists.osgeo.org] On Behalf Of Pieter du Plooy
Sent: Saturday, April 06, 2013 3:16 AM
To: pgRouting developers mailing list
Subject: Re: [pgrouting-dev] [pgr_2.0] Just checked in code to eliminate GAUL

Thanx Steve

Do you perhaps have prebuilt binaries? (64 and 32 bit)?

I will build during this week, just need to get my DEV machine up and running.

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

On Sat, Apr 6, 2013 at 2:38 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

I built this based on the postgis mingw32 and ming64 build environments. But if you pull my branch there is a tools directory at the top level that has some scripts (more as doc then a runnable script) called:

makedependanciesw64.sh - how to build the dependencies
makepgroutingw32.sh - how to build under ming32
makepgroutingw64.sh - how to build under ming64

I say to look at these as docs not as scripts because they have a lot of assumptions about directory structures and such.

There are also a couple of patch files in the tools directory also. With my latest checking you do not need to build the GAUL dependency anymore.

-Steve

On 4/5/2013 1:09 AM, Pieter du Plooy wrote:

Steve

Is the windows build instructions the same as what I did last year for the build that I made? (mingw?)

Pieter

_______________________________________________
pgrouting-dev mailing list
[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/pgrouting-dev](http://lists.osgeo.org/mailman/listinfo/pgrouting-dev)

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

On Fri, Apr 5, 2013 at 3:35 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

Hi All,

I have just checked in code into sew-devel-2_0 branch that eliminates the GAUL dependency and replaces the TSP solver with a simple C routine. I rewrote the TSP lib code to use the existing GAUL API and to use the postgresql memory management and added two test cases. I have build and tested on Win32-pg92 and Linux-pg84 with no problems.

Daniel - Thanks for the feedback on TSP, I will look at it and see what I can do with your suggestions.

The current code assumes a loop, ie: the start is also the end point. Other than that is should work as before.

-Steve

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev