SQLite Encryption

I know Xojo uses AES-128 encryption for its SQLite databases, but need to know which mode… OFB or CCM?

Does anyone perhaps know which encryption mode is used by Xojo as per the SQLite Encryption Extension (SEE)?

Did you try?
Using the wrong one should fail quickly.

Actually I’m not using the database other than in Xojo, so I cannot test the mode in another environment. My application produces encrypted databases and I might have to specify to my clients which encryption was used.

I was just wondering if anyone knew the mode right off the bat, but if not I’ll see if I can download something to test with.

MBS Plugin includes SQL with SEE extensions.
So the other app could be our plugin. You can try it.

Great, thanks Christian. I will definitely keep that in mind.

Ok, after some testing with SQLiteManager I can encrypt a database with Xojo and then view it in SQLiteManager.

SQLiteManager claims to support AES-128 encryption only with OFB mode, so I think it is safe to assume that Xojo uses OFB mode.