Changes between Version 8 and Version 9 of DataStorageEN


Ignore:
Timestamp:
Jan 5, 2011, 2:14:41 AM (10 years ago)
Author:
Martin Kolman
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DataStorageEN

    v8 v9  
    3838}}}
    3939
    40 The storage database looks like this:
    41 {{{table tiles (z integer, x integer, y integer, store_filename string, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}
    42 The store databases look like this:
    43 {{{table tiles (z integer, x integer, y integer, tile blob, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}
    44 The only difference in the structure is that the lookup databases only stores the name of the store for given coordinates and the store database stores the actual blob.
     40The storage database looks like this:[[br]]
     41{{{table tiles (z integer, x integer, y integer, store_filename string, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]]
     42The store databases look like this:[[br]]
     43{{{table tiles (z integer, x integer, y integer, tile blob, extension varchar(10), unix_epoch_timestamp integer, primary key (z, x, y, extension))}}}[[br]]
     44The only difference in the structure is that the lookup databases only stores the name of the store for given coordinates and the store database stores the actual blob.[[br]]
    4545Both also have a table called called version which has an integer column called v.  There is a single 1 inserted, which indicates the current version of the table.
    4646
     
    5050When looking for a tile in the database, modRana first asks the lookup database and when it gets an answer, it asks the store described in the store_filename for the given coordinates.
    5151
    52 '''Could this be used by other navigation apps ?'''
     52'''Could this be used by other navigation apps ?'''[[br]]
    5353Why do you think I just roughly described how it works ? :D
    5454