B4J Library SQLite JDBC - Library version updates

Hi everybody!

This thread is supposed to get all SQLite JDBC library version links together so as to find and download them easier.
As a heavy B4J+SQLite user, I'm always looking forward to have new JDBC versions.
All information contained herein has been taken from Mr. Taro L. Saito (xerial), library author, GitHub documentation.
Thank you @mcqueccu, for suggesting the creation of this thread.
There are earlier versions available. They can be easily found HERE, should you ever need them.

Future versions might be found in additional posts in this thread.

Having this said, let's get to it!

Sqlite-jdbc version 3.25.2 (2018.10.01) available for download HERE

• Implements UPSERT, ALTER TABLE ... RENAME COLUMN and added the Geopoply module.

​

Sqlite-jdbc version 3.27.2 (2019.03.15) available for download HERE

• Upgrade to SQLite 3.27.2

Sqlite-jdbc version 3.27.2.1 (2019.03.20) available for download HERE

• Make smaller the jar size by using -Os compiler option
• Performance improvement for concurrent access.

Sqlite-jdbc version 3.28.0 (2019.06.25) available for download HERE

• Upgrade to sqlite 3.28.0

Sqlite-jdbc version 3.30.1 (2019.12.23) available for download HERE

• Upgrade to sqlite 3.30.1
• Various fixes

Sqlite-jdbc version 3.31.1 (2020.05.05) available for download HERE

• Upgrade to sqlite 3.31.1
• Support update/commit/rollback event notifications #350
• Remove sparse index checks #476
• Support alpine linux (Linux-alpine)
• Enabled SQLITE_ENABLE_STAT4 flag

Sqlite-jdbc version 3.32.3 (2020.06.19) available for download HERE

• Fix multiple CVE reported issues https://github.com/xerial/sqlite-jdbc/issues/501

Sqlite-jdbc version 3.32.3.1 (2020.07.15) available for download HERE

• Remove SQLITE_MAX_MMAP_SIZE compile option, which might be causing performance issuess.

Sqlite-jdbc version 3.32.3.2 (2020.07.28) available for download HERE

• Enable SQLITE_MAX_MMAP_SIZE compile option again.
• Fixes issues when using Arm Cortex A8, A9 (32-bit architecture)

​

Sqlite-jdbc version 3.32.3.3 (2020.12.08) available for download HERE

• Apple Silicon (M1) support

Sqlite-jdbc version 3.34.0 (2020.12.10) available for download HERE

• Improved the performance of reading String columns
• Support URI file names (file://...) in backup/restore commands https://sqlite.org/uri.html
• Show SQL strings in PreparedStatements.toString()

Sqlite-jdbc version 3.35.0 (2021.06.27) available for download HERE

• Don't use 3.35.0 if you are Apple Silicon (M1) user. 3.35.0 failed to include M1 binary

Sqlite-jdbc version 3.35.0.1 (2021.06.27) available for download HERE

• Upgraded to SQLite 3.35.0
• Avoid using slower ByteBuffer decode() method (#575)
• Allow increasing SQLite limits (#568)
• Add Automatic-Module-Name for OSGi (#558
• Avoid using shared resource streams between class loaders when extracting the native library. (#578)
• (Note: Don't use 3.35.0 if you are Apple Silicon (M1) user. 3.35.0 failed to include M1 binary)

Sqlite-jdbc version 3.36.0 (2021.06.27) available for download HERE

• Upgrade to SQLite 3.36.0

Sqlite-jdbc version 3.36.0.1 (2021.06.30) available for download HERE

• Fixed a date parsing issue #88
• Added CI for testing JDK16 compatibility. sqlite-jdbc works for JDK8 to JDK16

Sqlite-jdbc version 3.36.0.2 (2021.08.25) available for download HERE

• Newly Supported OS and Arch
  • Support custom collation creation (#627)
  • Newly Supported OS and Arch
  • Windows armv7 and arm64 (e.g., Surface Pro X) (#644)
  • FreeBSD aarch64 (#642)
  • Bring back Linux armv6 support (#628)
  • FreeBSD x86 and x86_64 (#639)
  • Dropped DragonFlyBSD support (#641)
• Other Intenal Fixes
  • Add reflect-config, jni-config and native-image.properties to graalvm native image compilation (#631)
  • Fix multipleClassLoader test when directory is renamed (#647)
  • CI tests for Windows and MacOS (#645)

Sqlite-jdbc version 3.39.2.0 (2021.08.25) available for download HERE

 

[Claudio Oliveira]

Sqlite-jdbc version 3.45.0.0 (2024.01.19) available for download HERE

Changelog​

Features​

jdbc

• reintroduce improved support for Statement#getGeneratedKeys (f7d49f6)

sqlite

• upgrade to sqlite 3.45.0 (961e6c1)

🛠 Build​

build-native

• migrate upload/download to v4 syntax (02d0371)

deps

• bump surefire.version from 3.2.3 to 3.2.5 (e37b720)
• bump org.apache.maven.plugins:maven-compiler-plugin (5520295)
• bump org.jreleaser:jreleaser-maven-plugin (1cb9462)
• bump actions/download-artifact from 3 to 4 (47c2b52)
• bump org.apache.maven.plugins:maven-compiler-plugin (f094bff)
• bump surefire.version from 3.2.2 to 3.2.3 (585d0d0)
• bump actions/upload-artifact from 3 to 4 (d58b364)
• bump org.apache.maven.plugins:maven-javadoc-plugin (1f57928)
• bump actions/setup-java from 3 to 4 (0874939)

deps-dev

• bump org.mockito:mockito-core from 5.8.0 to 5.9.0 (93cd00c)
• bump org.assertj:assertj-core from 3.24.2 to 3.25.1 (688fa0c)
• bump org.mockito:mockito-core from 5.7.0 to 5.8.0 (7d44a45)
• bump ch.qos.logback:logback-classic (16216ac)
• bump com.tngtech.archunit:archunit-junit5 (e8d6c7a)

unscoped

• add 2024 folder for amalgamation download (2da5480)

Contributors​

We'd like to thank the following people for their contributions:
Gauthier, Gauthier Roebroeck, Stephen Lombardo

 

[Claudio Oliveira]

Sqlite-jdbc version 3.45.1.0 (2024.01.31) available for download HERE

Changelog​

Features​

sqlite

• upgrade to sqlite 3.45.1 (8a47fb0)

Fixes​

jdbc

• support CTE and REPLACE syntax with Statement#getGeneratedKeys (2cf1b26)

🛠 Build​

deps

• bump org.graalvm.sdk:nativeimage from 23.1.1 to 23.1.2 (a84e560)

deps-dev

• bump org.assertj:assertj-core from 3.25.1 to 3.25.2 (2e336d9)
• bump org.mockito:mockito-core from 5.9.0 to 5.10.0 (0eb6cb8)

Contributors​

We'd like to thank the following people for their contributions:
Gauthier, Gauthier Roebroeck, Stephen Lombardo

 

[Claudio Oliveira]

Sqlite-jdbc version 3.45.2.0 (2024.03.12) available for download HERE

Changelog​

Features​

sqlite

• upgrade to sqlite 3.45.2 (c56fbf1)

🏎 Perf​

• CoreStatement uses optimize regex for generated key matches (95b8efa)

🛠 Build​

deps

• bump org.apache.maven.plugins:maven-gpg-plugin (3b83760)
• bump org.jreleaser:jreleaser-maven-plugin (9ccd1e7)
• bump org.graalvm.buildtools:native-maven-plugin (eca45e5)
• bump andymckay/cancel-action from 0.3 to 0.4 (b11f8be)
• bump org.graalvm.buildtools:native-maven-plugin (cdad828)

deps-dev

• bump org.mockito:mockito-core from 5.10.0 to 5.11.0 (07b38af)
• bump org.junit.jupiter:junit-jupiter (6c2e966)
• bump org.assertj:assertj-core from 3.25.2 to 3.25.3 (daca050)

unscoped

• use BC signer (c84d122)

Documentation​

• add gpg key to README (18c0bd4), closes #1049
• adding try-with-resources to examples and demo. related #938 (9a072d3), closes #938

Contributors​

We'd like to thank the following people for their contributions:
David Schlosnagle, Gauthier, Gauthier Roebroeck, Tamas Cservenak, hbobenicio, prubel

 

[Claudio Oliveira]

Sqlite-jdbc version 3.45.3.0 (2024.04.16) available for download HERE

Features​

sqlite

• upgrade to sqlite 3.45.3 (f271cf9)

🛠 Build​

deps

• bump org.graalvm.sdk:nativeimage from 23.1.2 to 24.0.0 (09ca844)
• bump org.apache.maven.plugins:maven-jar-plugin (12316ca)
• bump org.apache.maven.plugins:maven-gpg-plugin (3420859)
• bump org.apache.maven.plugins:maven-source-plugin (14f27ec)
• bump org.apache.maven.plugins:maven-gpg-plugin (139e914)
• bump org.apache.maven.plugins:maven-compiler-plugin (607d48c)
• bump org.apache.maven.plugins:maven-gpg-plugin (c556f08)

Contributors​

We'd like to thank the following people for their contributions:
Gauthier, Gauthier Roebroeck