A GUI SQLite client compatible with MMEX encryption

[guangong]

Hope the tool can help one your regular usage with MMEX


Windows (wxsqliteplus.zip)


Mac

ubuntu.png (107.52 KiB) Viewed 3515 times

ubuntu

wxsqliteplus.zip

(2.54 MiB) Downloaded 2492 times

[guangong]

the tool could now open mmex4desktop (default) and mmex4android's encrypted file.

for mmex4desktop, the default is

Code: Select all

PRAGMA cipher=aes128cbc;

for mmex4android, we need

Code: Select all

PRAGMA cipher=SQLCipher;
pragma legacy=4;

shortly, we believe the two would be unified.

Snip20240224_10.png (172.64 KiB) Viewed 17807 times

[guangong]

wxSQLitePlus would both directly now. next step is to unify them

Download It

Snip20240225_11.png (101.64 KiB) Viewed 17696 times

[guangong]

three steps to convert encrypted desktop (aes128) to android one (SQLCipher/aes256)
1. Download wxSQLitePlus
2. Open your desktop database file (either encrypted or plained)
3. Check and update page size if not 4096 (refer to the latest reply)
4. File -> Encryption Key will upgrade the cipher to SQLCipher/AES256 in place.

[guangong]

with switch default cipher to CipherSQLCipher4(AES256) from AES128 PR merged, MMEX4Desktop will start to support SQLCipher(AES256) soon.

Then wxSQLitePlus would play as a handy tool to convert historical AES128 database to SQLCipher(AES256)

[guangong]

if your database uses the legacy page size (1024), checked via

Code: Select all

PRAGMA page_size

Here are the instructions for updating the legacy page size (1024) to the default page size (4096).

run the following code to update the page size in place

Code: Select all

PRAGMA page_size = 4096;
VACUUM;

then re-check via

Code: Select all

PRAGMA page_size