Opened 9 years ago

Closed 8 years ago

#318 closed enhancement (invalid)

updating sqlite3 package

Reported by: esseffe Owned by: osgeo4w-dev@…
Priority: major Component: Package
Version: Keywords: sqlite3
Cc:

Description

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

Change History (16)

comment:1 Changed 9 years ago by brushtyler

Keywords: sqlite3 added; libsqlite removed
Summary: updating libsqliteupdating sqlite3 package

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).

comment:2 Changed 9 years ago by brushtyler

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

comment:3 Changed 9 years ago by 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]

comment:4 Changed 9 years ago by 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,

comment:5 Changed 9 years ago by 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.

comment:6 Changed 9 years ago by 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.

comment:7 Changed 9 years ago by 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]

comment:8 Changed 9 years ago by jef

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

comment:9 in reply to:  8 Changed 9 years ago by 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.

comment:10 Changed 9 years ago by 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.

comment:11 Changed 9 years ago by 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

comment:12 Changed 9 years ago by 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.

comment:13 Changed 9 years ago by aperi2007

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

comment:14 Changed 9 years ago by 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.

comment:15 Changed 9 years ago by aperi2007

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

I remove it tonight,

regards,

Andrea

comment:16 Changed 8 years ago by jef

Resolution: invalid
Status: newclosed
Note: See TracTickets for help on using tickets.