Android Studio Tutorial - SQLite Cipher 

You're welcome :D

I will look and create new tutorial, my bro

github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.10.1 Try use it my dear :D

Yup, same here.

I think will too slow :(

select count(*) from sqlite_master Why you select from sqlite_master ?

I didn't select count(*) from sqlite_master, I followed your video but I get this error My db is test.db

Is this issue solved?Could you please help me out in solving this issue

Please import all library to com....sqlitecipher , not android.os.sqlite :D

Yep that did it. Thank you for your help with this. Awesome app.

@@damirko I am having the issue! Can you please tell me what library you imported exactly?

I will try to research , my dear

@@eddydn71 Please help me. I have pre-made database which i made using sqlite db browser i need to encrypt this db. please help 👏

:D Because my English too bad , my dear :D

EDMT Dev i dont understand any word hindi but i keep watch to learn if you want learn no thing stop you . If you found that hard to make please just keep quite music only. Thanks for interesting

what problem, please show me

@@eddydn71 It's solved. My point is When you are using SQLite Cipher in Project during release apk time you have to add proguard rules in proguard file. Otherwise, the application will crash.

gist.github.com/developernotes/3040592 I hope it can help you

I'll try to do that :D

Now i've too busy with Uber clone :D I'll do that after Uber clone seriers

EDMT Dev thnku i'll wait....

:) This is tutorial how to working with SQLite Cipher :) In real app , you must store it with Firebase Remote Config :D

@@eddydn71 can you please make a tutorial for how to store the key with firebase remote config? And if I do so, will the app still work when the mobile is offline? Thanks.

You're welcome my bro

stackoverflow.com/questions/39495820/encrypt-existing-database-with-sqlcipher-in-android Here you are

@@eddydn71 I tried a lot, but failed. Please make a tutorial about this how we can protect or secure sqlite pre-made database from asset folder. Hope this will help for many peoples. Thanks

@@eddydn71 Some one can easily get the database by unzipping from asset folder. If is it possible to encode my target column from the db it will be help for me.

You need use this libraries to encrypt databse. SQLiteAssetHelper doesn't support

Thank you very much for your answer. But I want to use SQLiteAssetHelper. Do not know the other way to protect the database in SQLiteAssetHelper?

Sure my dear

Is the process of implementing this on Room persistence is the same on what you did?

Next tutorial will be publish on Wednesday , my dear :D

Ok I am waiting for tutorial

Ali Sidhu you can check my github repository which may help you to how to store images in sqlite. But always remember if you store an image greater than 2 MB in sqlite the exception is generated so on that situation you can use the realm database and if your image is less than 2mb you can check my githun repo github.com/RishabhRawatAndroid/SmartCarParking-Android-App/tree/master/app/src/main/java/com/example/rishabh/smartcarparking

rishabh rawat thanks dear.. but the problem is that i have larger image size thats why i am facing this problem.. do you have any solution for karger image size more than 2 mb?

rishabh rawat i tried to use firebase.. but failed there also to find a pic using specfic id.. mean i will assign manually id to a pic and retive that by giving that given id in firebase

Ali Sidhu you can use the Huffman compression algorithm on image and compressed image after the image converted into byte array and pass on to the sqlite database. But truly speaking the above method is not very good way to store an image in sqlite because mobile need high computational power for doing this stuff. I discussed earlier you can use the REALM database for storing the large size image upto 16MB. And I also added one thing realm database is more power and faster database as compare to sqlite. So if you want your database will be private use the realm and if you want your database would be access anybody you simply use the sqlite database .

Ali Sidhu this is simple task but longer process. I mean you can use the free host website and make a database on the free host server like ooowebhost I think this webhost id free and after creating a database then simply write a 10 to 15 line php script which do the CRUD operations on the database. And after that in android use a retrofit android library and POST operation is performed and set the id as you like and when you retrieve the image simple use the GET operation. You can use the firebase also but in this situation you do a two operation on same time ex firstly upload an image into firebase and after that initialize the DatabaseReference class and putting the uploaded image URL on database and when use you retrieve the image you can go to specific URL with your desired image id and reterive the image onto firebase upload class I think.

:-? I can't typing slower :( But you can edit speed of video to watch :D

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wAV2Uqv9KLo.html You're welcome :)

@.@ We use SQLite Cipher in this project :( SQLite Cipher is name of one type SQLite -> it need password to decrypt database !

@@eddydn71 okay, thanks man

Password will be define by DAtabase owner

This is private tutorial about SQLite , i will release next tutorial about UBER Clone on Wednesday

:D Next tutorial will available at Wednesday , my dear