rtreeupdate - needed?

[Christian]

Hi,

I finally managed to get a working set of spatialite libraries for
windows mobile 5!
I am going to publish those stuff soon.

I have some smaller bugs to fix, one of them is, that the method
rtreeUpdate
is not available, it seems that either SQLITE_CORE is defined or
SQLITE_ENABLE_RTREE is undefined.

But rtreeUpdate is set in the spatialite.def file, which defines the
functions that are being exported to DLL.

Is this function needed? Should I try to enable rtree?

cheers
Christian

[noel frankinet]

Christian a écrit :
Hello,

I use spatialite on windows Mobile 5 since more than one year ?
Whar kind of problem did you had ?

Noël

[Christian]

Hi,

beside getting a working version of libiconv and finally getting the
available proj.4 and geos libraries to compile under Windows Mobile 5
(and not Pocket PC 2003), I didn't have problems ;)

I enabled rtreeUpdate by setting SQLITE_ENABLE_RTREE; seems not to
cause any trouble, so I think it's alright.

cheers
Christian

[Christian]

btw. what would be the preferred way for developers?
Providing a set of libraries (libiconv, proj, geos, spatialite) or
provide a single file (libspatialite.dll) with all the needed stuff
inside?

[noel frankinet]

Christian a écrit :
Hi,

Yes I remember now, libiconv was a problem
I had a proj4 for pocket pc from a previous project, sqlite and
spatialite compile without problem

Best regards
Noël

[a.fu...@lqt.it]

Hi,

the 'rtreeUpdate' function plays an absolutely
strategic role, because it manages R*Trees,
i.e. the Spatial Index key component.

please note: while building SQLite you MUST define
some macro defs in order to enable some 'advanced'
features subject to conditional compilation.

-------

LARGE_FILE=1
FILE_OFFSET_BITS=64
LARGEFILE_SOURCE=1

the above defs are required if you wish to
enable support for arbitrary size DBs: if you
omit them a 32-bit system will be unable to
handle any DB exceeding 2GB.
Please note: this is surely true for Win32,
Linux, MacOsX [and any other Unix-like], but
I completely ignore if this is required/supported
on WindowsCE / WindowsMobile

---------

SQLITE_ENABLE_RTREE=1

this is required in order to enable RTree aka
Spatial Index (RTree is strictly required in
order to fully support SpatiaLite)

bye,
Sandro

[Christian]

Hi,

thank you for the

I added those entries you told me, my Compact Framework.NET
Application still works with the new compiled libraries :)

I promise, I'll post them as soon as possible and publish a small
project website which will include the Visual Studio Solutions and/or
makefiles to do that stuff on your own!

bye
Christian