Author Topic: SQLiteDB vs. MBTiles  (Read 3400 times)

Offline pablito

  • Newbie
  • *
  • Posts: 3
    • View Profile
SQLiteDB vs. MBTiles
« on: March 01, 2013, 14:05:29 »
Hi,
I finally managed to convert the proprietary data format of the very good topographical maps of Switzerland by swisstopo into very large GeoTiffs. Now I can choose between the classic SQLiteDB format or the more or less recently implemented MBTiles format for use on my Galaxy Note II. Are there any differences concerning performance between these two?
Thanks and kind regards
Paul Simon
« Last Edit: January 01, 1970, 01:00:00 by Guest »
 

Online Menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 11883
  • Thanked: 444 times
    • View Profile
    • http://www.asamm.com
  • Device: Pixel 2
Re: SQLiteDB vs. MBTiles
« Reply #1 on: March 01, 2013, 14:19:40 »
Hello Pablito,
  SQLite is simple format based on Sqlite database where on single row are three coordinates and one image. And MBTiles is same. It use inverted Y axis and should have some more metainformation inside, but in general, performance if same for both. Because Locus internally work with own, little bit improved SQLite format, it mainly depend if you want to use your maps really in Locus or if you plan to use them in other apps.

  I personally think, that more commonly used should be MBT format, because it's supported by larger company, etc etc. So from perspective view, there should be 0% difference, only difference is in compatibility between other apps. I'm sure you'll do it, just suggest to keep original map files. Maybe you'll find other alternatives. Suggest to check on GEMF, because it's binary based format, not database, so in general, it should be faster then all these SQLite based formats.
« 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!
Support email: locus.map@asamm.com
 

Offline pablito

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: SQLiteDB vs. MBTiles
« Reply #2 on: March 01, 2013, 14:31:28 »
Quote from: "menion"
Suggest to check on GEMF, because it's binary based format, not database, so in general, it should be faster then all these SQLite based formats.
Thanks Menion, I'll look into that GEMF format. I believe my GIS has some plugin for that too. For the moment I'll choose the MBTiles, because tomorrow I leave for a trip to the beautiful central swiss alps (ski-touring) :-)!
Btw: The 2.9.2 works flawlessly. Great work!
« Last Edit: January 01, 1970, 01:00:00 by Guest »
 

Online Menion

  • Administrator
  • Professor of Locus
  • *****
  • Posts: 11883
  • Thanked: 444 times
    • View Profile
    • http://www.asamm.com
  • Device: Pixel 2
Re: SQLiteDB vs. MBTiles
« Reply #3 on: March 01, 2013, 17:55:37 »
perfect. Enjoy vacation ;)
« 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!
Support email: locus.map@asamm.com