[mapserver-users] Migrating mapcache sqlite database to new format

[thomas bonfort]

Hi Michael,
You'd have some options here:
- either manually hack your sqlite schema so it corresponds to the new
one (you probably only need to drop/add a few columns)
- implement a "single tileset" sqlite backend in cache_sqlite.c
(copying and adapting mapcache_cache_sqlite_create() should be
sufficient)
- implement a "generic" sqlite backend where you supply the sql
prepared statements yourself in the mapcache.xml configuration file.

regards,
thomas

On Thu, Aug 16, 2012 at 1:33 AM, Smith, Michael ERDC-RDE-CRREL-NH
<Michael.Smith at erdc.dren.mil> wrote:
> Thomas,
>
> Was just trying to update my mapcache installation and found out that the
> sqlite databases I had built are no longer compatible with the current
> format. Specifically, they don't have the TILESET column and I have multiple
> sqlite db files for multiple layers. Is there  a current configuration
> method to using this format or is there a workaround? Or should I just use
> and old SHA (b62172775d1377ef74c5499fef21101280d84377) until I have time to
> rebuild the caches. These are scattered tile caches, eg lots of areas of no
> coverage and the seeding (using GDAL to select the seed areas) can't take
> advantage of multiple threads to to the use of GDAL.
>
> Mike
>
> --
> Michael Smith
> US Army Corps
> Remote Sensing GIS/Center
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>