Android Question How to open Encrypted SQLite database?

A

Alex_197

Well-Known Member
Licensed User
Longtime User
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.
 
Sort by date Sort by votes

KZero

Active Member
Licensed User
Longtime User
Check this

Android database encryption with SQLCipher library

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 almost no need to change any code in order to switch from regular SQL to SQLCipher. The...
www.b4x.com
 
Upvote 0
A

Alex_197

Well-Known Member
Licensed User
Longtime User
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.
 
Upvote 0

Lucas Siqueira

Active Member
Licensed User
Longtime User
Alex_197 said:
Do you mean to post an example of my database?
Click to expand...

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 ...
 
Upvote 0
A

Alex_197

Well-Known Member
Licensed User
Longtime User
Lucas Siqueira said:
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 ...
Click to expand...
Here it is - password is tetris166. It doesn't have any records yet. Just a few tables.
 

Attachments

  • test_p.zip
    28.1 KB · Views: 365
Upvote 0

KZero

Active Member
Licensed User
Longtime User
i think SQLiteStudio supports SQLCipher , try it https://sqlitestudio.pl
 
Upvote 0
A

Alex_197

Well-Known Member
Licensed User
Longtime User
KZero said:
i think SQLiteStudio supports SQLCipher , try it https://sqlitestudio.pl
Click to expand...
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.
 
Upvote 0

KZero

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

Alex_197

Well-Known Member
Licensed User
Longtime User
Thanks, will check.

I thought that something already exists on Google Play Market.
 
Upvote 0

Peter Simpson

Expert
Licensed User
Longtime User
Alex_197 said:
I don't know how to open it on my Android.
Click to expand...

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
 
Upvote 0
A

Alex_197

Well-Known Member
Licensed User
Longtime User
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.
 
Upvote 0
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…