Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>How likely do you think it is that your normal user will be doing this? I assume you're going through the app store, which means that everything is signed/encrypted before getting on to the user's device. They would have to jailbreak their device to get access to your database.</p> <p>What sort of data are you storing such that it needs encryption? If it contains passwords that the user entered, then you don't really need to encrypt them; the user will not need to find out their own password. If it's generic BLOB data that you only want the user to access through the application, it could be as simple as storing an encrypted blob using the <a href="https://developer.apple.com/iphone/library/documentation/Security/Reference/certifkeytrustservices/Reference/reference.html#//apple_ref/c/func/SecKeyRawSign" rel="nofollow noreferrer">security API</a>.</p> <p>If it's the whole database you want secured, then you'd still want to use the security api, but on the whole file instead, and decrypt the file as necessary before opening it. The issue here is that if the application closes without cleanup, you're left with a decrypted file.</p> <p>You may want to take a look at memory-resident databases, or temporary databases which you can create either using a template db or a hard-coded schema in the program (take a look at the documentation for <a href="http://www.sqlite.org/c3ref/open.html" rel="nofollow noreferrer">sqlite3_open</a>). The data could be decrypted, inserted into the temporary database, then delete the decrypted database. Do it in the opposite direction when closing the connection.</p> <p><b>Edit</b>:</p> <p>You can cook up your own encryption scheme I'm sure with just a very simple security system by XOR-ing the data with a value stored in the app, and store a hash somewhere else to make sure it doesn't change, or something.</p>
    singulars
    1. This table or related slice is empty.
    1. POEncrypting SQLite Database file in iPhone OS
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEd Marty
    1. USEd Marty
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 For totally agreeing with you. I think it's a non-issue. Unless the data we're talking about is a matter of (inter)national security, there's no need of ultra protecting it. (And in the case of a potential world peace compromising security risk, I strongly advise against using the iPhone)
      singulars
      1. PO
      1. USKriem
    2. COAlso if you encrypt it yourself you'll have to answer 'yes' during appstore upload questionnaire and clarify the conformance to export restriction.
      singulars
      1. PO
      1. USRemus Rusanu
    3. COSee my edit for clarification on why I want to encrypt the DB.
      singulars
      1. PO
      1. USrjstelling
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload