[postgis-users] Postgres as cache and renderer for vector tile server

[Brian Panulla]

I use TileStache for my tile layers (http://tilestache.org/doc/), all data
stored in PostGIS. While my tiles are raster images rendered with Mapnik,
TileStache also now has Vector support, which might meet your needs: (
http://tilestache.org/doc/TileStache.Vector.html).

TileStache is very simple and lightweight and needs very little in the way
of infrastructure outside of Python, a few package requirements, and a
WSGI-compatible Web server.

-B

On Mon, Mar 21, 2016 at 8:59 AM, Peter Devoy <peter at 3xe.co.uk> wrote:

> Hi all,
>
> Has anyone here tried using Postgres as the caching layer in a vector tile
> server?
>
> I need to set up a tile server and what I am thinking is have PostGIS cut
> up
> geometries into GeoJSON vector tiles as requests come in and cache the
> JSON for
> said requests in some other Postgres table(s) using a JSON/JSONB column.
> Then
> just have a cron job or something set up to prune the cache table so that
> the
> least frequently accessed tiles get removed.
>
> I know there are existing vector tile server solutions but I would like to
> be
> serving tiles in British National Grid rather than web mercator so they
> would
> all need some hacking.  I also have reservations about their architecture
> --
> I would rather not complicate my stack if Postgres can handle it.
>
> Is it a dumb endeavour?
>
> Kind regards
>
>
> Peter
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160321/1f085783/attachment.html>