updating sqlite3 package

[esseffe]

I notice that the currently distributed version is 3.7.10 (released on 2012-01-16)
The most recent version of SQLite is 3.7.14.1 (released on 2012-10-04)
Anyway I read this notice on SQLite's own web site:

Version 3.7.14.1 of SQLite is recommended for all new development.
Upgrading from version 3.7.6.3, 3.7.7, 3.7.7.1, 3.7.8, 3.7.9, 3.7.11, 3.7.12, 3.7.12.1, or 3.7.13 is optional.
Upgrading from all other SQLite versions (including version 3.7.14) is recommended.

So version 3.7.10 has clearly been declared as "officially deprecated", i.e. it surely contains some major defect.
I suppose that quickly upgrading to 3.7.14.1 is highly recommended.

bye Sandro

[brushtyler]

I remember we already discussed about updating the sqlite3 package, whether that could break anything. The conclusion was it shouldn't need to rebuild anything (see ticket #266).

[brushtyler]

It's necessary to enable the sqlite-rtree extension as grass7 need it to work (see #305).

[esseffe]

SpatiaLite as well strongly depends on the sqlite-rtree extension

other highly recommended build settings are: /D_LARGE_FILE=1 /D_FILE_OFFSET_BITS=64 /D_LARGEFILE_SOURCE=1

[required in order to enable sqlite3 accessing huge database files > 4 GB]

[aperi2007]

I see there is available the 3.7.15.1 and as the sqlite dev says:

Version 3.7.15.1 of SQLite is recommended for all new development. Upgrading from all other SQLite versions is recommended.

I could try to prepare a new package with sqlite 3.7.15.1.

But I need to know what is the method used before.

I guess the more easy and fast method actually is get the compiled package from sqlite site it give only the .dll but using it .def is possible to produce the .libs using the LIB command from VC.

(LIB /DEF:sqlite3.def)

Otherwise the other solution is to recompile all using VC from source.

What is the method used on last package?

Thx,

[brushtyler]

The last time I recompiled it from sources.

Getting it from the sqlite site would be good, but IIRC the sqlite-rtree-extension is disabled by default in the latest versions, and instead we need it's enabled.

[aperi2007]

ok.

I prepare a new package compiled from source. I apply the suggested options: _LARGE_FILE=1 _FILE_OFFSET_BITS=64 _LARGEFILE_SOURCE=1

it is downloadable from here.

​http://tinyurl.com/d2tyfjk

In my compile , I notice the static library (sqlite.lib) is bigger than previous version.

[aperi2007]

oops, sorry I forgot link.

this is the good link.

[178.79.137.173:8080/vario/sqlite3-3.07.15.01-1.tar Download]

[jef]

Please review the PackagingInstructions. Your tar archive isn't bzip2ed and the contained files are gzipped instead...

[aperi2007]

Replying to jef:

Please review the PackagingInstructions. Your tar archive isn't bzip2ed and the contained files are gzipped instead...

ok, sorry.

I prepare a new package. Please don't use actual package. I miss an important setting value.

[aperi2007]

I see the sqlite code.

The two options: _LARGEFILE_SOURCE and _LARGE_FILE is normally enabled. To disable them is necessary set the variable SQLITE_DISABLE_LFS. So they can be omitted.

The _FILE_OFFSET_BITS=64 is controlled by the SQLITE_DISABLE_LFS. So it can be omitted in the settings.

[aperi2007]

I recompile the package using these options:

SQLITE_DEFAULT_FOREIGN_KEYS=1 SQLITE_ENABLE_RTREE SQLITE_ENABLE_STAT3 SQLITE_ENABLE_TREE_EXPLAIN SQLITE_ENABLE_UPDATE_DELETE_LIMIT SQLITE_ENABLE_FTS3 SQLITE_ENABLE_FTS3_PARENTHESIS SQLITE_ENABLE_FTS4

[aperi2007]

I have prepared the new package bzipped

the package is downloadable from here.

​http://tinyurl.com/cfj4g5s

Compiled with VC2008 32bit and with these options:

SQLITE_DEFAULT_FOREIGN_KEYS=1
SQLITE_ENABLE_RTREE
SQLITE_ENABLE_STAT3
SQLITE_ENABLE_TREE_EXPLAIN
SQLITE_ENABLE_UPDATE_DELETE_LIMIT
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_FTS3_PARENTHESIS
SQLITE_ENABLE_FTS4

Regards.

[aperi2007]

Hi, the last package I post is ok for update on osgeo4w ?

[aperi2007]

Hi,

I notice the sqlite guys has released a new version bug-resolving.

the sqlite3 3.07.15-2 version.

So I recreate a new package with this new version.

It is downloadable from here (the previous link was dismissed).

​http://tinyurl.com/anubdcg

Regards.

[aperi2007]

Please if there is an interest to download this package, downalod early.

I remove it tonight,

regards,

Andrea