Android Question How to open Encrypted SQLite database?

[Alex_197]

Hi, I've successfully created a small test project with SQLCipher. Works fine.

I can open this database file on desktop with SQLiteDatabaseBrowserPortable.

I don't know how to open it on my Android. Unencrypted file created with SQL but not with SQLCipher I can open with aSQLiteManager app but now can't do it - the app says that this not a database file. I tried few others apps from play market with no success.

Any idea?

It helps me a lot while I'm creating my project and I need some app to view the encrypted database.

Thanks.

 

[Lucas Siqueira]

please post an example from the database so you can test it.

 

[Alex_197]

please post an example from the database so you can test it.

Do you mean to post an example of my database?

 

[KZero]

Check this

Android database encryption with SQLCipher library

Edit: this library isn't compatible with the 16KB page size requirement. Don't use it. SQLCipher is an open source project that extends SQLite and adds full database encryption. License: https://www.zetetic.net/sqlcipher/open-source/ B4A SQLCipher is a special subtype of SQL object. There is...

www.b4x.com

 

[Alex_197]

Check this

Android database encryption with SQLCipher library

Edit: this library isn't compatible with the 16KB page size requirement. Don't use it. SQLCipher is an open source project that extends SQLite and adds full database encryption. License: https://www.zetetic.net/sqlcipher/open-source/ B4A SQLCipher is a special subtype of SQL object. There is...

www.b4x.com

Thank you for your replay.

I created my app based on this tutorial and it works fine.

My question is - how to open this database file by itself. Like, for example I can open it on desktop?

aSQLLiteManager or any other SQLite managers work only with non-encrypted files.

 

[Lucas Siqueira]

Do you mean to post an example of my database?

yes post an example of the database that you can open on your computer, and you cannot open on your android phone ...

I'll investigate why you can't ...

please send the access data as you are using encryption to protect the bank ...

 

[Alex_197]

yes post an example of the database that you can open on your computer, and you cannot open on your android phone ...

I'll investigate why you can't ...

please send the access data as you are using encryption to protect the bank ...

Here it is - password is tetris166. It doesn't have any records yet. Just a few tables.

 

[KZero]

Thank you for your replay.

I created my app based on this tutorial and it works fine.

My question is - how to open this database file by itself. Like, for example I can open it on desktop?

aSQLLiteManager or any other SQLite managers work only with non-encrypted files.

i think SQLiteStudio supports SQLCipher , try it https://sqlitestudio.pl

 

[Alex_197]

i think SQLiteStudio supports SQLCipher , try it https://sqlitestudio.pl

Thank you for your replay.

I found a tool for windows, now I need it for Android. Let say I sent my app for testing and it doesn't work as expected. I need to open a database right on a phone itself to see what inside. For example I connect to the tester over teamviewer, he runs PowerMirror on his phone that mirrors android screen to his computer and I see what is going on. So I need some app that opens encrypted database right on a phone. For un-encrpypted app I'm using aSQLite manager. But it doesn't work with encrypted files.

 

[KZero]

you can easily create you own SQLCipher editor in B4A

check this samples (just use SQLCipher insteadof SQL, i think the rest of code will be the same)

SQLiteLight four simple SQLite projects

Some users asked here for a simple SQLite project as an example to make their first steps in SQLite. The already existing examples seem beeing somewhat complicated for beginners. These examples are explained in the B4XSQLiteDatabase Booklet. Attached three small projects: - SQLiteLight1 A...

www.b4x.com

 

[Alex_197]

you can easily create you own SQLCipher editor in B4A

check this samples (just use SQLCipher insteadof SQL, i think the rest of code will be the same)

SQLiteLight four simple SQLite projects

Some users asked here for a simple SQLite project as an example to make their first steps in SQLite. The already existing examples seem beeing somewhat complicated for beginners. These examples are explained in the B4XSQLiteDatabase Booklet. Attached three small projects: - SQLiteLight1 A...

www.b4x.com

Thanks, will check.

I thought that something already exists on Google Play Market.

 

[Peter Simpson]

I don't know how to open it on my Android.

Unable to connect to my SqliteCipher Database

I create 2 SqliteCipher databases with 2 different software, 1. https://sqlitestudio.pl/ 2. https://sqlitebrowser.org/ I have tables with data in them each I downloaded the lastest libary and event the old one yet it keeps returning this error ** Service (starter) Start ** ** Activity...

www.b4x.com

 

[Alex_197]

Unable to connect to my SqliteCipher Database

I create 2 SqliteCipher databases with 2 different software, 1. https://sqlitestudio.pl/ 2. https://sqlitebrowser.org/ I have tables with data in them each I downloaded the lastest libary and event the old one yet it keeps returning this error ** Service (starter) Start ** ** Activity...

www.b4x.com

Thank you for your replay.

I don't have any problem connecting to the database from my app. I need some database manager app like aSQLiteManager that can work with encrypted database to open it outside my app, run queries, etc.. I found one for desktop SQLiteDatabaseBrowserPortable but they don't have Android version.

 

[Peter Simpson]

Thank you for your replay.

DB Browser for SQLite

sqlitebrowser.org

The answer was in my previous response on the same page, it pays to read more than one post...

 

[jcmartini]

DB Browser for SQLite

sqlitebrowser.org

The answer was in my previous response on the same page, it pays to read more than one post...

It's the only app I tested, working with Fts5 and Sqlcipher