[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