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

[Peter Devoy]

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