Using FMDB + SQLCipher with Rubymotion?

Question

I am using FMDB for handling a sqlite db in my application built using rubymotion.

I want to encryt the database with SQLCipher and I am facing issues when I try using SQLCipher methods such as sqlite3_key ?

Has anyone tried out the same ?

**********adding :

When I try to encrypt the database using the sqlite3_key method offered by SQLCipher api , it throws and exception telling the method is not defined.

Can you be more specific on the issues you face? Error messages? — Jamon Holmgren, Jan 14 '13 at 05:50

score 1 · Accepted Answer · answered Jan 22 '13 at 19:17

I think you can do this by adding SQLCipher pod then using the FMDB FMDatabase.setKey method and without having to do write any C.

In the Rakefile

app.pods do
  pod 'FMDB'
  pod 'SQLCipher'
end

Then in your Database.rb

class Database
  def self.connection
    unless @connection
      @connection = FMDatabase.databaseWithPath(db_path)
      @connection.traceExecution = true if $debug
      @connection.open
      @connection.setKey 'MySecretKey'
    end
  end
end

Now you should be able to query the db with

Database.connection.executeSelect 'SELECT * from some_table'

yep I did that already after going through the many hits and trials ! — AaShish Upadhyay, Jan 22 '13 at 22:39

Using FMDB + SQLCipher with Rubymotion?

1 Answers1