View Single Post
Posts: 84 | Thanked: 6 times | Joined on Feb 2007 @ Noblesville, IN USA
#79
Originally Posted by fredoll View Post
MMapper uses libsqlite3 to access the database.
you have to install sqlite3( which uses libsqlite3 too) to get a command line utility to access your database manually.

Fred
I've solved the sqlite3 installation problem:

1. go to http://eko.one.pl/maemo/index.php
2. click on "dists"
3. click on "mistral"
4. click on "user"
5. click on "binary-armel"
6. click on "libsqlite3-0_3.3.8-1_armel.deb" and go through the install process
7. click on "sqlite3_3.3.8-1_armel.deb" and go through the install process.

This is not an obvious process you would be tempted to look in "bora" instead of "mistral". The link that eco.one.pl gives for sqlite3 could be changed to http://eko.one.pl/maemo/index.php?pa...Fbinary-armel/
and save a lot of headaches.

To prove that sqlite3 really works, bring up an xterm and cd to where the poi file is. Issue the command "sqlite3 poi" and you will be put in the interactive sqlite interface. Issue "select * from poi;" and you will get back all the data in the table.

Working with this table is easier if you simply ssh into your n800 from your desktop. If you have a lot of waypoints stored up from an older gps, I guess there is a way to load from a datafile. If I discover how, I'll post it.

-- rhackenb