[Loadstone] any way to generate phone-ready points databases on PC?
shawn at odyssey.cm.nu
Mon Dec 10 00:10:11 GMT 2007
I have to say you get points for being able to read the source code and
understand what it's doing.
We'd like to be able to generate databases on the pc but unfortunately the
format of the symbian database files isn't known. Or if it is known I
haven't been able to find any information about it. Having that format
information would make a lot of things possible.
On Sun, 9 Dec 2007, Alan wrote:
> Hello, I don't know if this is feasible or not, but I thought I'd throw
> it out there.
> To import a recommended size data set (perhaps 30,000 points from the
> points exchange) takes about 10-20 minutes on my Nokia E70. This doesn't
> sound like much but adds up when you're storing multiple optimal-size
> databases to cover a certain geography. From my quick perosal of the
> sourcecode in ImportExport.cpp, the process looks like this:
> 1. The database is implemented via a Symbian RdbNamedDatabase. Each
> proposed new record is checked for duplication and an insert is made.
> 2. After 30,000 inserts into the Symbian database implementation, the
> database is compacted.
> 3. This compacted database is stored as one serialized file on the phone.
> Would it be possible to write a PC-side program to insert, compact, and
> serialize the database into a file on the PC? I imagine this might take
> 15 seconds on a PC instead of 15 minutes.
> One problem I see to this is that the database implementation uses the
> Symbian API, and I haven't been able to find any documentation
> describing the implementation, only the interface. I realize this would
> break the Symbian database abstraction but the datasets Loadstone deals
> with are very standardized and not variable and the performance and user
> experience payoff would be considerable.
> Loadstone mailing list
> Loadstone at loadstone-gps.com
More information about the Loadstone