B4J Library SQLite JDBC - Library version updates

Claudio Oliveira · Aug 27, 2021

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 · Jan 19, 2024

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 · Jan 31, 2024

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 · Mar 13, 2024

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 · Apr 16, 2024

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

Claudio Oliveira · May 27, 2024

Sqlite-jdbc version 3.46.0.0 (2024.05.27) available for download HERE

? Features

sqlite

upgrade to sqlite 3.46.0 (dfa37a1)

?️ Changes

fix typos in comment (662fb09)

? Build

deps

bump org.jreleaser:jreleaser-maven-plugin (2ae0884)
bump org.apache.maven.plugins:maven-gpg-plugin (88fa86f)
bump org.apache.maven.plugins:maven-jar-plugin (7f3fd87)
bump org.graalvm.sdk:nativeimage from 24.0.0 to 24.0.1 (d9fd689)
bump com.tngtech.archunit:archunit-junit5 from 1.2.1 to 1.3.0 (9e4a9df)

deps-dev

bump org.mockito:mockito-core from 5.11.0 to 5.12.0 (ce10957)

unscoped

fix failing multi-arch (db057a8)

Contributors

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

Claudio Oliveira · Jul 30, 2024

Sqlite-jdbc version 3.46.0.1 (2024.07.30) available for download HERE

? Features

add riscv64 binaries (a4a5d48)

? Fixes

jdbc

generated columns with stored in SQLite are not marked as generated (429bbe4), closes #1132

unscoped

never return arch as aarch64 when running in a 32-bit JVM (0c3db0b), closes #1127
throw java.lang.ExceptionInInitializerError when calling SQLiteConfig.Pragma.values() (ec0a524), closes #1123

? Build

deps

bump org.apache.maven.plugins:maven-javadoc-plugin (c375a40)
bump org.graalvm.sdk:nativeimage from 24.0.1 to 24.0.2 (d50d5e6)
bump org.codehaus.mojo:versions-maven-plugin (14e07d4)
bump surefire.version from 3.3.0 to 3.3.1 (edac56b)
bump org.codehaus.mojo:versions-maven-plugin (f411591)
bump org.jreleaser:jreleaser-maven-plugin (2376d03)
bump org.apache.maven.plugins:maven-jar-plugin (d5394ea)
bump andymckay/cancel-action from 0.4 to 0.5 (99aa8d9)
bump surefire.version from 3.2.5 to 3.3.0 (b64f8fb)
bump org.apache.maven.plugins:maven-help-plugin (235143b)
bump org.apache.maven.plugins:maven-javadoc-plugin (50ef887)
bump org.apache.maven.plugins:maven-enforcer-plugin (efd5449)
bump org.sonatype.plugins:nexus-staging-maven-plugin (dbbf4e0)

deps-dev

bump org.assertj:assertj-core from 3.26.0 to 3.26.3 (7293f78)
bump org.junit.jupiter:junit-jupiter (b80a294)
bump org.assertj:assertj-core from 3.25.3 to 3.26.0 (6188b48)

? Documentation

add riscv64 in the supported OS table (2b72c94)
mention temporary databases (0035ec4)

Contributors

We'd like to thank the following people for their contributions:
Asger Hautop Drewsen, Gauthier, IAmHash, Sualeh Fatehi, 秋雨落

Claudio Oliveira · Aug 19, 2024

Sqlite-jdbc version 3.46.1.0 (2024.08.19) available for download HERE

? Features

sqlite

upgrade to sqlite 3.46.1 (be3bf30)

? Fixes

native-image

support strict image heap (029a35f)

? Build

deps

bump org.apache.maven.plugins:maven-gpg-plugin (17dffe9)

unscoped

add GraalVM for JDK 22 to native test suite (e40e5a3)

Contributors

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

Claudio Oliveira · Oct 4, 2024

Sqlite-jdbc version 3.46.1.1 (2024.09.24) available for download HERE

? Features

make slf4j optional with fallback on JUL (b8ea5ca), closes #1094

? Build

deps

bump org.graalvm.sdk:nativeimage from 24.0.2 to 24.1.0 (ec4d3fd)
bump org.graalvm.buildtools:native-maven-plugin (588614a)
bump org.apache.maven.plugins:maven-gpg-plugin (abdf61d)
bump org.apache.maven.plugins:maven-javadoc-plugin (a445f6c)
bump org.jreleaser:jreleaser-maven-plugin (1309c5c)
bump surefire.version from 3.4.0 to 3.5.0 (2ed606f)
bump org.apache.maven.plugins:maven-help-plugin (4fa9e6f)
bump surefire.version from 3.3.1 to 3.4.0 (793fac5)

deps-dev

bump org.junit.jupiter:junit-jupiter (02bac1a)
bump org.mockito:mockito-core from 5.12.0 to 5.13.0 (ea152b4)

Contributors

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

Claudio Oliveira · Oct 4, 2024

Sqlite-jdbc version 3.46.1.2 (2024.09.25) available for download HERE

? Features

jdbc

add configuration to disable eager retrieval of generated keys (aed5121), closes #1135

Contributors

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

Claudio Oliveira · Oct 4, 2024

Sqlite-jdbc version 3.46.1.3 (2024.09.26) available for download HERE

? Features

jdbc

add setGetGeneratedKeys on SQLiteDataSource and SQLiteConfig for proper cascading (d463ef7), closes #1135

Contributors

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

Claudio Oliveira · Oct 23, 2024

Sqlite-jdbc version 3.47.0.0 (2024.10.22) available for download HERE

Fixes

use lambda loggers and fix message format for JUL (fd21058), closes #1195

🛠 Build

deps

bump org.apache.maven.plugins:maven-help-plugin (46cc36d)
bump org.graalvm.sdk:nativeimage from 24.1.0 to 24.1.1 (2c86dcf)
bump org.apache.maven.plugins:maven-javadoc-plugin (a88f62a)
bump surefire.version from 3.5.0 to 3.5.1 (9fadf17)
bump org.apache.maven.plugins:maven-gpg-plugin (132ab17)

deps-dev

bump org.mockito:mockito-core from 5.14.1 to 5.14.2 (c0b9f99)
bump org.junit.jupiter:junit-jupiter (82a5f2a)
bump org.junit.jupiter:junit-jupiter (761eb2e)
bump org.junit-pioneer:junit-pioneer (7586ce9)
bump org.junit.jupiter:junit-jupiter (69ea4db)
bump org.mockito:mockito-core from 5.13.0 to 5.14.1 (dd79b6d)

Contributors

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

Claudio Oliveira · Nov 26, 2024

Sqlite-jdbc version 3.47.1.0 (2024.11.26) available for download HERE

Changelog

Features

upgrade to sqlite 3.47.1 (67d28cb)

Fixes

possible StringIndexOutOfBoundsException in ExtendedCommand (2fdb1e9), closes #1141
update module-info.java to make org.slf4j static requirement (81b05ec)

🛠 Build

deps

bump org.codehaus.mojo:versions-maven-plugin (da8596c)
bump org.apache.maven.plugins:maven-javadoc-plugin (6e4c691)
bump org.jreleaser:jreleaser-maven-plugin (9f354be)
bump surefire.version from 3.5.1 to 3.5.2 (aa92c59)

Documentation

add supported API level for Android (4a41998), closes #1204

Contributors

We'd like to thank the following people for their contributions:
Arthur Chan, Gauthier, Gauthier Roebroeck, Rodolfo M. Raya

B4J Library SQLite JDBC - Library version updates

Active Member

Changelog​

? Features​

? Build​

Contributors​

Active Member

Changelog​

? Features​

? Fixes​

? Build​

Contributors​

Active Member

Changelog​

? Features​

? Perf​

? Build​

? Documentation​

Contributors​

Active Member

? Features​

? Build​

Contributors​

Active Member

? Features​

?️ Changes​

? Build​

Contributors​

Active Member

? Features​

? Fixes​

? Build​

? Documentation​

Contributors​

Active Member

? Features​

? Fixes​

? Build​

Contributors​

Active Member

? Features​

? Build​

Contributors​

Active Member

? Features​

Contributors​

Active Member

? Features​

Contributors​

Active Member

Fixes​

🛠 Build​

Contributors​

Active Member

Changelog​

Features​

Fixes​

🛠 Build​

Documentation​

Contributors​

Similar Threads

Privacy & Transparency

Privacy & Transparency

Changelog

? Features

? Build

Contributors

Changelog

? Features

? Fixes

? Build

Contributors

Changelog

? Features

? Perf

? Build

? Documentation

Contributors

? Features

? Build

Contributors

? Features

?️ Changes

? Build

Contributors

? Features

? Fixes

? Build

? Documentation

Contributors

? Features

? Fixes

? Build

Contributors

? Features

? Build

Contributors

? Features

Contributors

? Features

Contributors

Fixes

🛠 Build

Contributors

Changelog

Features

Fixes

🛠 Build

Documentation

Contributors