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

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
 
Last edited:
Click to expand...
Claudio Oliveira

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

? Documentation​

Contributors​

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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
Sqlite-jdbc version 3.46.0.0 (2024.05.27) available for download HERE

? Features​

sqlite
  • upgrade to sqlite 3.46.0 (dfa37a1)

?️ Changes​

? 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

Contributors​

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

Claudio Oliveira

Active Member
Licensed User
Longtime User
Sqlite-jdbc version 3.46.0.1 (2024.07.30) available for download HERE

? Features​

? 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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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

Claudio Oliveira

Active Member
Licensed User
Longtime User
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
 
You must log in or register to reply here.

Similar Threads

Claudio Oliveira
  • Article
B4J Library New sqlite-jdbc version 3.34.0 (2020.12.10)
Replies
2
Views
1K
Claudio Oliveira
Claudio Oliveira
Claudio Oliveira
  • Article
B4J Library New sqlite-jdbc version 3.32.3.3 (2020.12.08)
Replies
0
Views
964
Claudio Oliveira
Claudio Oliveira
Claudio Oliveira
  • Article
B4J Library New sqlite-jdbc version 3.32.3.2 (2020.07.28)
Replies
0
Views
1K
Claudio Oliveira
Claudio Oliveira
Claudio Oliveira
  • Article
B4J Library New sqlite-jdbc version 3.30.1 (2019.12.25)
Replies
0
Views
1K
Claudio Oliveira
Claudio Oliveira
KMatle
  • Article
Other Updates for sqlite-jdbc
Replies
4
Views
3K
Claudio Oliveira
Claudio Oliveira
Top