[Tiling] Steps towards a better filemanagement

[Frederic Junod]

Hello,

Do you know http://mbtiles.org/ ?

Never tried myself but it looks exactly what you planning to do: 'x,
y, z, blob' table in a SQLite database.

fredj

On Mon, Apr 11, 2011 at 1:27 PM, Oliver Tonnhofer <olt at omniscale.de> wrote:
> Hi list, hi Steven,
>
> On 11.04.2011, at 10:32, Steven M. Ottens wrote:
>> Last week I met Oliver Tonnhofer at FOSSGIS in Germany. We discussed the problems of tiling and especially tile-cache-management. My immediate problems are too many files to manage (for instance backups), updating of tiles, smart seeding (seeding the most popular regions first).
>> He said that he already had done some benchmarks on SQLite and it appears to be fast enough to serve tiles. So our idea is to use SQLite as a tilestore. Storing both the tiles and its metadata. Most likely using one database per tilecache-layer or maybe one database per tilecache-layer and zoomlevel.
>
> Yes, we developed an SQLite based prototype (simple table with x, y, z, blob) and the numbers where quite comparable with the file system based tile backend (tilecache schema). I'll post the numbers here in the next days.
>
> I've also started to design a database schema for a new tile store format that supports multiple caches per database and also caches split into multiple databases. I'll write that all up and post it here for discussion.
>
>
> Regards,
> Oliver
>
> --
> Oliver Tonnhofer    | Omniscale GmbH & Co KG    | http://omniscale.de
> http://mapproxy.org | https://bitbucket.org/olt | @oltonn
>
>
>
>
> _______________________________________________
> Tiling mailing list
> Tiling at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/tiling
>



-- 
Frédéric Junod
Camptocamp SA