Page 1 of 1

A GUI SQLite client compatible with MMEX encryption

Posted: Wed Jul 23, 2014 10:14 am
by guangong
Hope the tool can help one your regular usage with MMEX


Windows (wxsqliteplus.zip)
Image

Mac
ubuntu.png
ubuntu.png (107.52 KiB) Viewed 3578 times

ubuntu
wxsqliteplus.zip
(2.54 MiB) Downloaded 2517 times

Re: A GUI SQLite client which is compatible with MMEX encryption

Posted: Sat Feb 24, 2024 1:10 am
by 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
Snip20240224_10.png (172.64 KiB) Viewed 17870 times

Re: A GUI SQLite client which is compatible with MMEX encryption

Posted: Sun Feb 25, 2024 8:30 am
by guangong
wxSQLitePlus would both directly now. next step is to unify them

Download It
Snip20240225_11.png
Snip20240225_11.png (101.64 KiB) Viewed 17759 times

Re: A GUI SQLite client compatible with MMEX encryption

Posted: Wed Mar 20, 2024 3:18 am
by 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.

Re: A GUI SQLite client compatible with MMEX encryption

Posted: Sat May 04, 2024 1:52 pm
by 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)

Re: A GUI SQLite client compatible with MMEX encryption

Posted: Sat Nov 30, 2024 11:52 pm
by 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