Specify to use v4.6.1 instead of the latest version of SQLCipher

lucydodo · lucydodo · commit 1f230b489128 · 2025-04-19T20:42:50.000+09:00
THIS IS A TEMPORARY CHANGE. Due to a breaking change in SQLCipher v.4.7.0, where the SQLite3 and executable/library file names were made identical, we are locking to version 4.6.1 while we conside a solution. Related: #3915
diff --git a/.github/workflows/cppcmake-ubuntu.yml b/.github/workflows/cppcmake-ubuntu.yml
@@ -34,7 +34,8 @@ jobs:
       - if: matrix.bundle == 'SQLCipher'
         name: Build SQLCipher
         run: |
-          git clone https://github.com/sqlcipher/sqlcipher && cd sqlcipher && git checkout $(git describe --tags --abbrev=0)
+          # git clone https://github.com/sqlcipher/sqlcipher && cd sqlcipher && git checkout $(git describe --tags --abbrev=0)
+          git clone https://github.com/sqlcipher/sqlcipher && cd sqlcipher && git checkout v4.6.1
           ./configure --enable-tempstore=yes --with-crypto-lib=openssl --enable-load-extension --disable-tcl CFLAGS="-DSQLCIPHER_CRYPTO_OPENSSL -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_SNAPSHOT=1 -DSQLITE_ENABLE_STAT4 -DSQLITE_HAS_CODEC -DSQLITE_SOUNDEX"
           make -j2 && sudo make install -j2
 
@@ -123,4 +124,4 @@ jobs:
           fi
 
           echo "## Libaries used" >> $GITHUB_STEP_SUMMARY
-          echo "OpenSSL: $OPENSSL_VERSION, Qt: $QT_VERSION, SQLCipher: $SQLCIPHER_VERSION, SQLite: $SQLITE_VERSION" >> $GITHUB_STEP_SUMMARY
+          echo "OpenSSL: $OPENSSL_VERSION, Qt: $QT_VERSION, SQLCipher: $SQLCIPHER_VERSION, SQLite: $SQLITE_VERSION" >> $GITHUB_STEP_SUMMARY
diff --git a/.github/workflows/cppcmake-windows.yml b/.github/workflows/cppcmake-windows.yml
@@ -92,7 +92,8 @@ jobs:
           cd C:\dev
           git clone https://github.com/sqlcipher/sqlcipher SQLCipher/
           cd SQLCipher
-          git switch $(git describe --tags --abbrev=0)
+          # git switch $(git describe --tags --abbrev=0)
+          git switch v4.6.1
           nmake /f Makefile.msc sqlcipher.dll USE_AMALGAMATION=1 NO_TCL=1 SQLITE3DLL=sqlcipher.dll SQLITE3LIB=sqlcipher.lib SQLITE3EXE=sqlcipher.exe LTLINKOPTS="C:\dev\OpenSSL\lib\libcrypto.lib" OPT_FEATURE_FLAGS="-DSQLITE_TEMP_STORE=2 -DSQLITE_HAS_CODEC=1 -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_STAT4=1 -DSQLITE_SOUNDEX=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_RTREE=1 -DSQLCIPHER_CRYPTO_OPENSSL=1 -DSQLITE_MAX_ATTACHED=125 -IC:\dev\OpenSSL\include"
           mkdir sqlcipher
           copy sqlite3.h sqlcipher
@@ -207,4 +208,4 @@ jobs:
           }
 
           echo "## Libaries used" >> $env:GITHUB_STEP_SUMMARY
-          echo "OpenSSL: $OPENSSL_VERSION, Qt: $QT_VERSION, SQLCipher: $SQLCIPHER_VERSION, SQLite: $SQLITE_VERSION" >> $env:GITHUB_STEP_SUMMARY
+          echo "OpenSSL: $OPENSSL_VERSION, Qt: $QT_VERSION, SQLCipher: $SQLCIPHER_VERSION, SQLite: $SQLITE_VERSION" >> $env:GITHUB_STEP_SUMMARY
