Similar to symlink_blank, except completely skip writing a file
if a blank, fully transparent tile is detected.
Note: This setting should only be used when using the seeder. If used
on demand, mapcache will query the WMS source on each subsequent
tile request.
-->
<detect_blank/>
</cache>
<!-- memcache cache
entry accepts multiple <server> entries
requires a fairly recent apr-util library and headers
<cache name="memcache" type="memcache">
<server>
<host>localhost</host>
<port>11211</port>
</server>
</cache>
-->
<!-- redis cache
requires that hiredis library be installed
<cache name="redis" type="redis">
<host>redis.mysite.com</host>
<port>6379</port>
</cache>
-->
<!-- sqlite cache
requires building with "with-sqlite"
-->
<cachename="sqlite"type="sqlite3">
<!-- dbfile
absolute filesystem path where the sqlite database files will be stored.
this file needs to be readable and writable by the user running
apache
-->
<dbfile>/tmp/mysqlitetiles.db</dbfile>
<!-- pragma
special sqlite pragmas sent to db at connection time. The following
would execute:
PRAGMA key=value;
useful for changing default values e.g. on large databases.
-->
<pragmaname="key">value</pragma>
<!-- queries
SQL to be sent to sqlite backend for operations on tiles. The default queries that are
sent are listed below
-->
<queries>
<create>create table if not exists tiles(tileset text, grid text, x integer, y integer, z integer, data blob, dim text, ctime datetime, primary key(tileset,grid,x,y,z,dim))</create>
<exists>select 1 from tiles where x=:x and y=:y and z=:z and dim=:dim and tileset=:tileset and grid=:grid</exists>
<get>select data,strftime("%s",ctime) from tiles where tileset=:tileset and grid=:grid and x=:x and y=:y and z=:z and dim=:dim</get>
<set>insert or replace into tiles(tileset,grid,x,y,z,data,dim,ctime) values (:tileset,:grid,:x,:y,:z,:data,:dim,datetime('now'))</set>
<delete>delete from tiles where x=:x and y=:y and z=:z and dim=:dim and tileset=:tileset and grid=:grid</delete>