[Tilesathome] Key types - single string key instead of multiple numeric keys?
OJW
streetmap at blibbleblobble.co.uk
Thu Jul 19 19:20:31 BST 2007
On Thursday 19 July 2007 01:05, you wrote:
> Just checking to see how the preperations are going and wondering how
> long it might be before db change is done?
Database field "key" (32 character text) has added to tiles_meta and
tiles_blank, and the queue should now be restarted
Next, we need to update every bit of PHP code which stores and retrieves tiles
from the database, so that they store the new-style of key when creating
tiles, and use it when doing lookups. I was hoping some people could help
with that (it's all in SVN) so that we can just "svn update" on the server*
when we're ready to use the new system.
I presume we want to keep the existing x,y,z,layer fields rather than
extracting them from the key, since it means we can filter by layer, zoom,
etc. within the database.
* I guess we should also make a tag in SVN, so that it's easy to retrieve the
"pre-change" source code if we want to revert.
More information about the Tilesathome
mailing list