Upgrade SQLite to the latest version prior to release

[Igor Sereda]

Version 3.24.0 contains a critical bug – http://www.sqlite.org/cgi/src/info/9936b2fa443fec03ff25

Before releasing the next sqlite4java, we need to update the embedded sqlite to the version that contains a fix.

[Ivan Ooi]

any news? :-)

[Ivan Ooi]

and the current latest version is 3.27

[Igor Sereda]

Hi Ivan, thanks, sorry for the slow progress. We'll try to mobilize some resources and get to the release in a few months.

Igor

[Ivan Ooi]

Great! Thanks for the great sqlite4java. really love the speed

[Daniel Micay]

Are there still blockers for the release? At a minimum, it would be really nice to get SQLite updated since there have been important security updates since the old version currently being used. If help is needed, I can get some people to help since it’s important to me that this library is in a good state for my downstream project using it. I’ve considered moving to a different library but I don’t like any of the others and they don’t seem any more actively maintained than this.

[Igor Sereda]

Hi Daniel, thanks for your comment and for offering help. I admit we haven’t spent a lot of effort on this in the past months. There’s been some effort to update SQLite – the current version in master contains SQLite 3.26.0. A number of other tickets were closed too, but we didn’t conclude that with a release.

The thing is that a full release requires quite a bit of effort to build for all the platforms it can support. I’m currently looking to hire someone to take care of this – please send me a direct email at [e-mail] in a week and I’ll update you on how it’s going.

That said, one can always pull the latest repo version and build locally. There are some docs in https://bitbucket.org/almworks/sqlite4java/wiki/BuildingFromSource . Upgrading SQLite for the sake of security and bug fixes (without introducing new features on the Java side) should be also straightforward – just replace the amalgamation files in the sqlite/ directory.

Hope this helps.

Igor

[webfolder]

Hi,

I built sqlite4java with sqlite 3.30.1 (latest).

Build scripts: sqlite4java-build

It’s built on Appveyor platform.

Currently it supports Windows 32-bit, 64-bit and GNU/Linux 64-bit

I am not familiar with arm & MacOS. Please send a pull request to support additional environments.

[Roman Pickl]

Hi,

I have revisited this, as one of our queries takes forever using the last release.
Based on @webfolder 's version I hacked together a new osgi bundle and the problematic query that takes >4000 seconds on my laptop now runs in ~700 ms.

Which kind of help do you need to provide an official release?

all the best,
Roman

btw: sqlite 3.32.0 was released two days ago

[Ivan Ooi]

nice if it can add the encryption feature
some thing like this :
https://github.com/Willena/sqlite-jdbc-crypt

[Roman Pickl]

I now know that we are in the case of the long running query we are hit by

https://sqlite.org/src/info/6f2222d550f5b0ee7ed
which is really bad.