Author Topic: SQLite structure  (Read 4243 times)

Offline RedSpawn

  • More than Newbie
  • *
  • Posts: 17
    • View Profile
SQLite structure
« on: June 15, 2011, 11:55:06 »
I'm making a tool to load a geocaching .gpx file on my PC and add missing map-tiles to the sqlite databases.

The structure of the tables is easy enough, but what is the "s" row in the tiles table?
« Last Edit: January 01, 1970, 01:00:00 by Guest »
 

Offline menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 10754
  • Thanked: 170 times
    • View Profile
    • http://www.asamm.com
  • Device: SGS7
Re: SQLite structure
« Reply #1 on: June 15, 2011, 13:33:55 »
hi,
  s column was in this database since begin. I use I think structure from RMaps or similar program. Because I also do not have any idea why is there s column, I use it for storing number of hours since 1.1.2011 that tile was added to database. Good value for checking oldness of tiles and ability to refresh them ...
« Last Edit: January 01, 1970, 01:00:00 by Guest »
Ideas, wishes, problems
Advanced topics, public discussion, sharing of knowledges, testing beta versions: you're here!
 

Offline RedSpawn

  • More than Newbie
  • *
  • Posts: 17
    • View Profile
Re: SQLite structure
« Reply #2 on: June 15, 2011, 15:02:51 »
thanks for the quick reply!
i'll fill in the corresponding information....

i want to congratulate you to Locus, this really is a nice piece of software!
i'm planing on using it for geocaching since it is the only one that allows for custom- (private-) servers and shows much potential with its addons-function.

i'm going to start some threads concerning geocaching and sqlite  :twisted:
« Last Edit: January 01, 1970, 01:00:00 by Guest »
 

Offline menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 10754
  • Thanked: 170 times
    • View Profile
    • http://www.asamm.com
  • Device: SGS7
Re: SQLite structure
« Reply #3 on: June 15, 2011, 15:06:24 »
fine, you're welcome. Anyway when you want download only data around geocaching points, you may use downloading function where you define poi category and radius and locus will download this by itself. Anyway some posts about Geocaching and maps etc. are of course welcome
« Last Edit: January 01, 1970, 01:00:00 by Guest »
Ideas, wishes, problems
Advanced topics, public discussion, sharing of knowledges, testing beta versions: you're here!
 

Offline RedSpawn

  • More than Newbie
  • *
  • Posts: 17
    • View Profile
Re: SQLite structure
« Reply #4 on: June 15, 2011, 15:45:05 »
nice! that's exactly what i want to do!
at least i guess so since i haven't bought pro yet  ;)

but i still continue work on my tool because downloads are going to be faster on desktop pc.
unless there is an option to change the speed limit (2 tiles at once) for custom servers?
but i guess you better not allow this or there will be banning from the map servers..
« Last Edit: January 01, 1970, 01:00:00 by Guest »
 

Offline menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 10754
  • Thanked: 170 times
    • View Profile
    • http://www.asamm.com
  • Device: SGS7
Re: SQLite structure
« Reply #5 on: June 15, 2011, 16:06:29 »
:) nono there is no chance to actually change limit of downloading threads. And you're correct. Downloading on PC is of course faster. Question is if time you have to invest for this, cannot be invested better :). But it's up to you. Good luck
« Last Edit: January 01, 1970, 01:00:00 by Guest »
Ideas, wishes, problems
Advanced topics, public discussion, sharing of knowledges, testing beta versions: you're here!
 

Offline RedSpawn

  • More than Newbie
  • *
  • Posts: 17
    • View Profile
Re: SQLite structure
« Reply #6 on: June 15, 2011, 23:36:26 »
i already made a tool to download maptiles for my old WindowsMobile phone...

now it's working for Locus:
downloading 2000 tiles and adding to Locus database: 42sec
just adding 2000 tiles from cache to database: 16sec

wooohoooooo  :D
« Last Edit: January 01, 1970, 01:00:00 by Guest »