D devmobile Active Member Licensed User Jul 4, 2017 #1 Hello I have a word document that contain 20000 words and i want to add it to sqlite database This database is security and user haven't to get it with extract apk How keep it out of rich of user?
Hello I have a word document that contain 20000 words and i want to add it to sqlite database This database is security and user haven't to get it with extract apk How keep it out of rich of user?
Star-Dust Expert Licensed User Longtime User Jul 4, 2017 #2 see this: https://www.b4x.com/android/forum/t...ryption-with-sqlcipher-library.14965/#content Upvote 0
D devmobile Active Member Licensed User Jul 4, 2017 #3 Star-Dust said: see this: https://www.b4x.com/android/forum/t...ryption-with-sqlcipher-library.14965/#content Click to expand... I know but it is slow for large file Upvote 0
Star-Dust said: see this: https://www.b4x.com/android/forum/t...ryption-with-sqlcipher-library.14965/#content Click to expand... I know but it is slow for large file
tigrot Well-Known Member Licensed User Longtime User Jul 4, 2017 #4 I'd encrypt single columns and store them. Avoid to crypt key fields. Upvote 0
D devmobile Active Member Licensed User Jul 4, 2017 #5 tigrot said: I'd encrypt single columns and store them. Avoid to crypt key fields. Click to expand... Single column? But i have many record(top 100000) and how do i encrypt each record? Upvote 0
tigrot said: I'd encrypt single columns and store them. Avoid to crypt key fields. Click to expand... Single column? But i have many record(top 100000) and how do i encrypt each record?
tigrot Well-Known Member Licensed User Longtime User Jul 4, 2017 #6 You do while loading db. You decrypt while reading. I wrote "columns"... Using crypt has something to pay in performance... Upvote 0
You do while loading db. You decrypt while reading. I wrote "columns"... Using crypt has something to pay in performance...
D devmobile Active Member Licensed User Jul 4, 2017 #7 tigrot said: You do while loading db. You decrypt while reading. I wrote "columns"... Using crypt has something to pay in performance... Click to expand... Oh yes it is good solution. But how do i encrypt columns when i add it in database? Upvote 0
tigrot said: You do while loading db. You decrypt while reading. I wrote "columns"... Using crypt has something to pay in performance... Click to expand... Oh yes it is good solution. But how do i encrypt columns when i add it in database?
tigrot Well-Known Member Licensed User Longtime User Jul 4, 2017 #8 Create a field in which you encode db field content. Repeat for each field on record. Then use the result in insert sql. Access time doesn't change. You can use whatever encryption scheme you can find on this site. Upvote 0
Create a field in which you encode db field content. Repeat for each field on record. Then use the result in insert sql. Access time doesn't change. You can use whatever encryption scheme you can find on this site.
tigrot Well-Known Member Licensed User Longtime User Jul 4, 2017 #9 You must be sure that the strings obtained don"t contain special chars or you must esc them Upvote 0
